LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

Read Delimited Spreadsheet.vi reading all zeros

Solved!
Go to solution

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.

Download All
0 Kudos
Message 1 of 4
(146 Views)
Solution
Accepted by topic author Kastun27

Hi Kastun,

 


@Kastun27 wrote:

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…)

Best regards,
GerdW

using LV2011SP1 + LV2017 (+LV2020 sometimes) on Win10+cRIO
Message 2 of 4
(145 Views)

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. 

0 Kudos
Message 3 of 4
(111 Views)

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? 

0 Kudos
Message 4 of 4
(84 Views)