How to get individual xls cell value - CSVChat

Message from discussion How to get individual xls cell value

Peter

More options Feb 26, 3:50 am

From: Peter <dotnetconn...@gmail.com>

Date: Tue, 26 Feb 2008 00:50:54 -0800 (PST)

Local: Tues, Feb 26 2008 3:50 am

Subject: Re: How to get individual xls cell value

  Reply to author
  |
  Forward
  | Print
  | View thread
  | Show original
  | Report this message
  | Find messages by this author
  

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 -

Reply to author Forward