Read Data From Different Worksheets on Excel with LabVIEW

Updated Oct 3, 2023

Reported In

Software

  • LabVIEW Report Generation Toolkit
  • LabVIEW

Issue Details

  • I use LabVIEW with the Report Generation Toolkit. I want to read data from an Excel file which contains different worksheets. Is there a way to programmatically decide which worksheet to read data from?
  • I see that some examples for the Report Generation Toolkit to write Excel worksheets are included in LabVIEW. Is there a way to use these VIs to read from worksheets?

Solution

In order to read data from an specific excel worksheet you can use the Excel Get Worksheet.vi and the Excel Get Data.vi. You will see these VIs located at the following palette: Report Generation>>Excel Specific>>ExcelGeneral:

The Excel Get Worksheet.vi worksheet index input will let you configure the specific worksheet you would like to read from. Use the following code as a reference. A 2017 32 LabVIEW example is attached. The zip folder contains the program and an Excel file with three worksheets and different types of values. 

Attachments

Excel_read_data_with_worksheets.zip

Related Links

Other Support Options

Ask the NI Community

Collaborate with other users in our discussion forums



Request Support from an Engineer

A valid service agreement or active software subscription may be required, and support options vary by country.