How to Read Data From Different Worksheets on Excel with LabVIEW ?

Updated Aug 20, 2018

Reported In

Software

  • LabVIEW Report Generation Toolkit

Issue Details

I use LabVIEW with the "Report Generation Toolkit". I want to read data from an Excel file which contains different worksheet. Is there a way to read data from these worksheets ?

Solution

On the funtions palette on LabVIEW, there is all the VIs associated to the "Report Generation Toolkit". To get data from a specific worksheet, you must go on : Report Generation -> Excel Specific -> ExcelGeneral ->Excel Get Worksheet.vi :
 

By doing this, you select the worksheet on which you want to read some values.

Additional Information

Attached you can find an example. On the zip folder, there is an Excel file which contains three worksheets with different type of value. There is also a LabVIEW program which reads the values from the different worksheets and displays them.

Software version :
- Excel 2016
- LabVIEW 2017 (32 bits)
 

WAS THIS ARTICLE HELPFUL?

Not Helpful