Example Code

Reading Data From Excel Using The Report Generation Toolkit

Products and Environment

This section reflects the products and operating system used to create the example.

To download NI software, including the products shown below, visit ni.com/downloads.

    Software

  • LabVIEW Report Generation Toolkit
  • LabVIEW

Code and Documents

Attachment

Overview

The example demonstrates how to use the LabVIEW Report Generator Toolkit to read information from an Excel file.

 

Description

The Report Generation Toolkit uses the ActiveX interface to Microsoft Excel to interface with Excel spreadsheets. Using the pre-implemented functions from the Report Generation Toolkit also makes it possible to read data from an Excel spreadsheet.

 

Requirements

 Software

  • LabVIEW 2012 Base Development System (or compatible)
  • LabVIEW 2012 Report Generation Toolkit (or compatible)
  • Microsoft Excel (see Knowledgebase KB 3EJEC9NS)

 Hardware

  • No hardware is necessary to use this example VI

 

Steps to Implement or Execute Code

  1. Open the attached file
  2. Run the VI 

 

Additional Information or References

Read Data From Excel - Front Panel.png

 

Read Data From Excel - Block Diagram.png

 

 

Knowledgebase: KB 3EJEC9NS: Report Generation Toolkit Compatibility with Microsoft Office and LabVIEW

http://digital.ni.com/public.nsf/allkb/C9408B9F08D711E786256F3300701D01

 

**The code for this example has been edited to meet the new Community Example Style Guidelines. The edited copy is marked with the text 'NIVerified'. Read here for more information about the new Example Guidelines and Community Platform.**

Arturo Gómez | Applications Engineering
Certified LabVIEW Associated Developer

National Instruments Latin America
01-800-010-0793
ni.com/support

Example code from the Example Code Exchange in the NI Community is licensed with the MIT license.

Comments
K.Nishihara
Member
Member
on