From 04:00 PM CDT – 08:00 PM CDT (09:00 PM UTC – 01:00 AM UTC) Tuesday, April 16, ni.com will undergo system upgrades that may result in temporary service interruption.

We appreciate your patience as we improve our online experience.

LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

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

This should be simple.  Any ideas on how to read an Excel file with csv extension using LabVIEW?

 

Thanks!

0 Kudos
Message 1 of 4
(2,932 Views)
Use the Read From SpeadSheet File.VI which you can find on the FILE I/O pallette.

"Read From Spreadsheet File

Reads a specified number of lines or rows from a numeric text file beginning at a specified character offset and converts the data to a 2D, single-precision array of numbers. You optionally can transpose the array. The VI opens the file before reading from it and closes it afterwards. You can use this VI to read a spreadsheet file saved in text format. This VI calls the Spreadsheet String to Array function to convert the data."


The CSV file is essentially a text file which uses commas as delimiters in the files structure.
0 Kudos
Message 2 of 4
(2,920 Views)
Hi LuGo
 
What kind of data is stored in this file? If it is just numbers you can easily use the "read from Spreadsheet" vi, which is located in the files palette.
 
Thomas
Using LV8.0
--------------------------------------------------------------------
Don't be afraid to rate a good answer... 😉
--------------------------------------------------------------------
0 Kudos
Message 3 of 4
(2,918 Views)
Yes, This did it,  Thank you all! Smiley Very Happy
0 Kudos
Message 4 of 4
(2,914 Views)