NI Home
Cart Cart | Help
Company Events Academic NI Developer Zone Support Solutions Products & Services Contact NI MyNI

Currently Being Moderated

Reading Excel Data Using the Report Generation Toolkit

VERSION 1

Created on: Jan 6, 2009 11:54 AM by Justin_P - Last Modified:  Jan 6, 2009 12:39 PM by Justin_P

REQUIREMENTS:
Application Software: LabVIEW Base Development System 8.6
Driver Software: NI-RIO 3.0
Hardware Family: Reconfigurable I/O (RIO)
Add-on Software: LabVIEW Report Generation Toolkit for Microsoft Office 1.1.3
Product Category: LabVIEW
Development Topic: File I/O
Industry: Education
Application Type: Sound and Audio
Technology: Bluetooth

This simple program is a demonstration of how to use the LabVIEW Report Generation Toolkit to read data from Excel.  The first part of the program is a File Dialog Express.vi that selects the Excel file that you want to read (use the read_eecel_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".  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.

 

 

read_excel_values.PNG

 

Downloads:
Average User Rating
(0 ratings)




Todd Sierer Todd Sierer  says:

Great code!  Thanks for sharing this!

More Like This

  • Retrieving data ...