Read Data From Different Worksheets on Excel with LabVIEW

Updated Dec 4, 2025

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-bit LabVIEW example and a 2020 32-bit LabVIEW 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
Excel_read_data_with_worksheets_LV2020.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.