To download NI software, including the products shown below, visit ni.com/downloads.
This simple program is a demonstration of how to use the LabVIEW Report Generation Toolkit to read data from Excel programmatically.
The first part of the program is a File Dialog Express.vi which asks the user to select the Excel file that he wants to read (use the read_excel_values.xls in the attached zip file). Then the correct worksheet is selected with the "Excel Get Worksheet.vi". This is done with the worksheet index number for the first two sheets and by worksheet name in the last. After each "Excel Get Worksheet.vi" there is an "Excel Get Data.vi" which will grab the data corresponding to the start and end position (or location depending on the type of array) passed into the SubVI. For the 2-D array data types you must give start and end points for the array. For non-arrays you only need to give the location of the cell.
LabVIEW 2012 (or compatible)
LabVIEW Report Generation Toolkit 2012 for Microsoft Office (or compatible)
Steps to Implement or Execute Code:
Additional Information or References:
**This document has been updated to meet the current required format for the NI Code Exchange. **
Example code from the Example Code Exchange in the NI Community is licensed with the MIT license.