Read Data From Different Worksheets on Excel with LabVIEW

Updated Oct 3, 2023

Reported In


  • 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?


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

The Excel Get 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.