Example Code

Reading Data from Excel

Code and Documents

Attachment

This vi will give you access to Data in EXCEL sheet (row and column).

Select open Excel file, select range of row and column from which data is to be read, and then click open.

You will get respetive row and column data.
Press open only once.

The array and string on the right are simply to get the correct data types, and don't need any inputs.

Chris Van Horn
Applications Engineer

Example code from the Example Code Exchange in the NI Community is licensed with the MIT license.

Comments
mwatkins
Member
Member
on

excellent work Chris_VH. I just successfully tested in LV2019 reading a Office 360 ProPlus Version 1908 (Build 11929.20606) excel file.

Sr Test Engineer at American Innovations - LabVIEW CLA - Kudo's are appreciated!!
Brzhou123
Member
Member
on

Hi Sir, 

 

Could you add a portion for write data to txt ?

Thanks.

Keep moving
Contributors