read from spreadsheet vi ascii problem

[Aleph.ka]

Hallo,

there is a thing that I cannot read from an .xls file becouse every time I receive ascii signs, which I cannot successfully convert into chars (I#m running circles here). Does anybody has an idea how to open a big table with strings inside from xls in Labview? I would be really thankful,

K.

[GerdW]

Hi Aleph,

the problem is: a "spreadsheet" is not the same as an "Excel XLS" file!

The function expects "CSV" files. You can create them with Excel when using "Save as" and selecting "CSV (comma separated)" (or similar)...

[Zody]

Hi,

Could you post an sample of your excel file to have a look at it?

Best regards,

I.R.

[moderator1983]

And if at all you want to read an excel file, then you have to use either "Report Generation Toolkit" or "ActiveX based" vi to read from excel.

(The attachment is taken from: http://zone.ni.com/devzone/cda/epd/p/id/2231)

[Aleph.ka]

Hallo,

Thank you all very much, I've found my way how to deal with excel files BUT (there is always a but). Theres is a pic of ecel table I need to process via LabView, but the whole file with constant unchanged rows on the top (row 1 and 2) are not being processed by LV and i receive blank table. Is it kind of macro in Excel and how to enable LV to read open and process it? (I mean first 2 indexes of the row are constantly displayed eventhough u can scroll down and see other rows). I would be very grateful for some hints,

K.