Hello everyone. I am having trouble with the Read Delimited Spreadsheet.vi reading a simple spreadsheet. The array it reads turns up all zeros with a few random numbers here and there. I'm sure I'm doing something dumb but this previously worked on another VI where I created data in LabVIEW, send it to a spreadsheet with the Write Delimited Spreadsheet.vi, then later imported it back into LabVIEW with the Read Delimited Spreadsheet.vi. That works just fine.
However, when I manually create a spreadsheet and attempt to read it...no luck. Converting the data into a text file/.csv works but I would like to be able to read it from a spreadsheet. Thank you.
Solved! Go to Solution.
Converting the data into a text file/.csv works but I would like to be able to read it from a spreadsheet.
A "spreadsheet file" is something completely different than your proprietary Excel XLS file!
"Spreadsheet" files usually are called "CSV files" aka "delimited text files"!
ReadSpreadsheetFile CANNOT read Excel XLS(X) files: you need to use RGT functions instead!
(Or use Excel to write your data into a CSV file…)
Ahh ok. I should have known that. I really need to start asking you guys before spending two hours trying to solve problems like this.
The version of LabVIEW I'm working with does not have the RGT. The guy who had this project before me appended .xls to the csv file then just dealt with the error message when opening it up in Excel.
I can just pull the data from a delimited text file. Thanks again.
Do you know of a method to "comment out" in the text file in this situation? So that instructions can be added that LabVIEW will not try to import?