Page 1 of 1

Read a cell

Posted: Tue Jan 01, 2013 5:24 am
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

Re: Read a cell

Posted: Wed Jan 02, 2013 4:41 pm
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];

Re: Read a cell

Posted: Thu Jan 03, 2013 8:57 am
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 :)