how do you tell the read from spreadsheet vi which cell to read from?

[finny]

hey this main seem like a stupid question:( but i can't get my read from spreadsheet vi to read from a particular cell in the spreadsheet...what am i doing wrong??

kindest regards

finny

[tbob]

You can't specify a specific cell (row and column).  You usually read in the entire sheet and then use Index Array or Array Subset to extract the cell or cells you need.

[altenbach]

If reading single values is critical for you application, you should represent the data in a simple binary file. Now you can just read from a certain file position.

[Ben]

and adding one point omited by the previous.

That VI does not work on Excel files.

It is intended for delimited files.

Ben

[RavensFan]

---

@Ben wrote:

and adding one point omited by the previous.

That VI does not work on Excel files.

It is intended for delimited files.

Ben

---

It amazes me how often there are questions about reading from/writing to Excel files.  Of course the read/write spreadsheet file VI's you would think would do that based on their name.  But in reality, they don't.  Like you said, Ben, they are for delimited files.  I, myself, wouldn't call a comma delimited file (or tab delimited) a "spreadsheet" file, but NI does.  Based on the number of questions asked about Excel and "spreadsheet" files, I think most people are confused by that.

I wonder if NI should have come up with a better, more accurate name for those particular VI's.

And based on the number of times these questions are asked, you'd think they would never need to be asked again because a search of the forums would show they've been answered hundreds of times before.

Message Edited by Ravens Fan on 08-22-2007 05:22 PM

[finny]

hey guys! thanks for all the answers!!