LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

extracting data from Excel file

Hi, 

i want a programme  that is able to extract occured value from Excel file .

thank you.

0 Kudos
Message 1 of 3
(2,145 Views)

Hi Emna,

 

open the LabVIEW example finder and look for RGT (Report generation) examples on reading Excel files…

Best regards,
GerdW


using LV2016/2019/2021 on Win10/11+cRIO, TestStand2016/2019
0 Kudos
Message 2 of 3
(2,123 Views)

By "Excel file", do you mean a file with the extension .xls or .xlsx, a proprietary file format for Microsoft Excel, or a file with the extension .csv, a plain text file divided into "rows" and "columns" by lines of text (rows), with the lines separated into fields by commas (columns) (or, in some cases, by another "separator character -- LabVIEW uses a <tab> by default, as does Excel, which has the ability to read .csv files)?

 

For true Excel files, NI's Report Generation Toolkit (which may be an "extra-cost item" depending on your License) will do the trick, as will some third party addons.  For .csv files, LabVIEW provides Delimited Spreadsheet functions (Read and Write) which will return a 2D array of Strings or numerics.

 

Bob Schor

0 Kudos
Message 3 of 3
(2,104 Views)