reading a spreadsheet.

[exo]

I have an (Mac) excel generated spread sheet but read from spreadsheet.vi seems to be only able to read the first row. I am correctly wired, not wired to the read first row connector.I have also tried several different forms of the spreadsheet. tab delimited, comma delimited, etc. I am running version 7 and the spreadsheet is attached.

thanks

[exo]

Sorry, make that it only reads the first column

[Steve.Briggs]

What format do you try opening the spreadsheet with.  You can choose from %.3f which is Double format, %d which is Integer format, or %s which is String format.  Try using the string format, I know for a fact that you can bring up all the rows and columns with that format.

Good luck

[smercurio_fc]

You didn't post your code, so it's impossible to say what may be the problem, but the following works to read the contents:


Note: Since some of the columns have text information, the stock "Read from Spreadsheet File" in LabVIEW 7, which is what you said you're using, will probably be inadequate for you. You probably want to read the contents in as a 2D array of strings. You can easily modify the stock "Read from Spreadsheet File" VI to use a 2D array of strings. Just make sure you don't overwrite the one that comes with LabVIEW.

Message Edited by smercurio_fc on 10-01-2007 10:00 AM

[exo]

Here's the code. I may not have been looking at enough of the spreadsheet to tell whats going on. I also made some changes to the spreadsheet. I formating still isn't write. The spreadsheet is formatted as text but numbers are display as floats and letters are not displayed at all.

[Steve.Briggs]

You didn't change the format going in...

This works fine for bringing up the entire spreadsheet.

[exo]

I've tried %.3f and %s. Neither seem to work. I'm also running 7.0. Do you think that's the problem?

[Dennis_Knutson]

Read what smercurio_fc said about the Read From Spreadsheet function in 7.0. It cannot read strings. There are instructions on the block diagram on how to modify it to do so. And, as he said, when you make the modifications, save it with a new name and in a different location.

[Steve.Briggs]

Doh..

I missed the part where you said your running 7.0.  My apologies, go with what Dennis/smercurio suggested.

[exo]

Thanks guys.
Once more, I'd be lost without you.