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

Updated Jan 16, 2019

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 programmatically decide which worksheet to read data from?

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)