How to get individual xls cell value

[Peter]

Hello Bruce,

I have an xls spreadsheet which is really messy with fields and there
are no real columns.
How do I use datastreams.xls to get the value of individual cells.
I am pretty confident I can run loops using x, y positions to get the
data I need, but I cannot figure how to get individual cell values.

Thanks
Peter

[shriop]

XlsReader has a method to get the value using an x,y coordinate,
http://www.csvreader.com/csv/docs/DataStreams.Common.SpreadsheetReader.Item2.html
. Using C#, it's reader[x, y], and using VB.Net, it's reader.Item(x,
y). It's inherited from the base SpreadsheetReader class. There's also
a RecordCount property, http://www.csvreader.com/csv/docs/DataStreams.Common.SpreadsheetReader.RecordCount.html
, so you know how many records are in the sheet. There should probably
have been a way of finding the number of columns in the sheet without
looping over each record but there currently is not. Hopefully you
have logic to determine how many columns there are.

Bruce Dunwiddie

[Peter]

Thanks Bruce.

On Feb 25, 5:12 pm, shriop <shr...@hotmail.com> wrote:
> XlsReader has a method to get the value using an x,y coordinate,http://www.csvreader.com/csv/docs/DataStreams.Common.SpreadsheetReade...

> . Using C#, it's reader[x, y], and using VB.Net, it's reader.Item(x,
> y). It's inherited from the base SpreadsheetReader class. There's also

> a RecordCount property,http://www.csvreader.com/csv/docs/DataStreams.Common.SpreadsheetReade...

> , so you know how many records are in the sheet. There should probably
> have been a way of finding the number of columns in the sheet without
> looping over each record but there currently is not. Hopefully you
> have logic to determine how many columns there are.
>
> Bruce Dunwiddie
>
> On Feb 25, 12:03 am, Peter <dotnetconn...@gmail.com> wrote:
>
>
>
> > Hello Bruce,
>
> > I have an xls spreadsheet which is really messy with fields and there
> > are no real columns.
> > How do I use datastreams.xls to get the value of individual cells.
> > I am pretty confident I can run loops using x, y positions to get the
> > data I need, but I cannot figure how to get individual cell values.
>
> > Thanks

> > Peter- Hide quoted text -
>
> - Show quoted text -