'Can I read other than the first sheet with the Read Delimited Spreadsheet.vi function in LabVIEW?
I am using Read Delimited Spreadsheet.vi in LabVIEW and need to read data from other than the first sheet. How do I tell LabVIEW that want to use other than the first sheet?
Solution 1:[1]
CSV files are plain text files and there are no multiple sheets inside. Sheets are present within Excel files, but this function "Read Delimiter Spreadsheet" does not work with these.
Solution 2:[2]
Unfortunately LabVIEW still doesn't have built-in support for reading Excel files as far as I know, although it can write them with the Save to Measurement File express VI.
There are third-party toolkits available for reading Excel files in LabVIEW, or you might be able to use some Python code with openpyxl or pandas.
Solution 3:[3]
I suppose you need to read a Excel file (.xls or .xlsx) and not a CSV file (as suggested by Mateusz the CSV file doesn't have sheets).
Anyway, in LabVIEW you can read, write, manipulate and do any other operations on Excel files by using ActiveX. It is verbose but you can use it as any other LabVIEW library. Look this post or the built-in examples in your LabVIEW environment
Solution 4:[4]
As mentioned above, you can use Excel to read a spreadsheet. Alternately, you can use LibreOffice. LibreOffice to LV library
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 | Mateusz Owczarek |
| Solution 2 | nekomatic |
| Solution 3 | Fourier |
| Solution 4 | Lior Bilia |