Read a cell

Questions and answers on how to use XLSReadWriteII 3/4/5.
Post Reply
EdwinGrimshaw
Posts: 2
Joined: Tue Jan 01, 2013 5:17 am

Read a cell

Post by EdwinGrimshaw »

All I want to do is read either an integer, double or string from a cell - ultra simple

Can someone tell me how to do this ?

d :Double;
....
d := XLS.Sheets[Sheet].Cell[x, y];

Doesn't work.

Ed
Joe Griffin
Posts: 13
Joined: Tue Feb 13, 2007 8:47 am
Location: West Sussex England

Re: Read a cell

Post by Joe Griffin »

EdwinGrimshaw wrote:d :Double;
....
d := XLS.Sheets[Sheet].Cell[x, y];
Ed
Try

d := XLS.Sheets[Sheet].AsFloat[x, y];
or .AsString[x,y];
.. .AsInteger[x,y];
Joe Griffin
GerbilSoft Associates Limited
EdwinGrimshaw
Posts: 2
Joined: Tue Jan 01, 2013 5:17 am

Re: Read a cell

Post by EdwinGrimshaw »

Thank you - so obvious - I did read the help file and look at the samples !
I'll put it down to New Year excess.

Everything else is working as expected :)
Post Reply