How can I read all string from this spreadsheet file?

[Ya-hoo]

How can I read all strings from this spreadsheet. Where can I find any example code? I tried some, but seems that doesn't work.

Thanks.

Merry Christmas!

[chilly_charly]

Which one ?

[Ray.R]

Can you provide the spreadsheet?

[Ya-hoo]

Sorry, I thought I have attached the file.

[RJay]

You can use the Open Spreadsheet File.vi
Use the Context Help as a starting point. Which version of LV are you using? If it is 7.0, then you can use the example finder located within the Help menu.

[chilly_charly]

No way you could use "Read from spredsheet", since your file is a native format Excel file.
You can download a solution ready-to-use from here

CC

[Brett_B.]

Another option would be to save your Excel file to a .csv file. You can do this from Excel from the "save as" menu. Once the file is in this format, you can use the "read characters from file.vi" and the "convert from spreadsheet string" function to get your data in a 2D array of strings format.

[rpursley8]

Try this vi. You have to put in the file name and the range of cells you want to sample.

Hope this works for you. It uses ActiveX calls to get the data from the application. You may have to relink the Automation references to point to your Excel program.

[Ya-hoo]

Thanks for all of your responses.

I could read from excel file now. My application is read data from Corel Quattro Pro, which is a spreadsheet file (*.wb3 file), similar with Excel. But seems it doesn't have activex function.
If I right click the automation reference in front panel in a Labview program then click "Select ActiveX class", then browse, are all activex application in that library? There is no Corel Quattro Pro there, So I can not link Labview to it. Am I right?

I tried to open and read from file then convert spreadsheet string to array, but I got very strange code.

What's the solution in this situation?

Thanks.

[Dennis_Knutson]

Quattro Pro is a very old program. No longer sold and it's certainly possible that it never had ActiveX support. The easiest thing to do is to do a save as and pick a text file format. You can then use Read From Spreadsheet file to read from a comma or tab separated file. Trying to read a native file format is usually a waste of time because of all of the special control characters for formatting that are embedded in the file.