ni.com is currently undergoing scheduled maintenance.

Some services may be unavailable at this time. Please contact us for help or try again later.

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,901 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,879 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,860 Views)