How to read columns of a Microsoft Excel .csv file with LabVIEW?

[luisbgomez]

Hi All,

This should be simple. Any ideas on how to read an Excel file with csv extension using LabVIEW? I am stuck at reading the file using the read from spreadsheet file function.

Thanks!

[didierj]

Hi All,

This should be simple. Any ideas on how to read an Excel file with csv extension using LabVIEW? I am stuck at reading the file using the read from spreadsheet file function.

Thanks!

It's what I would have said to use. Just define as separator a comma (instead of the default tab, since "csv" means "comma separated...") and you get a 2d-array with your data. With the index-array select the columns.

...just came to my mind: check that eventual values in your file do NOT have comma as decimal separtor... or you end up with comma as decimal AND element separator, and therefore with a big mess

[luisbgomez]

Hi All,

This should be simple. Any ideas on how to read an Excel file with csv extension using LabVIEW? I am stuck at reading the file using the read from spreadsheet file function.

Thanks!

Thanks! It didn