From Friday, April 19th (11:00 PM CDT) through Saturday, April 20th (2:00 PM CDT), 2024, ni.com will undergo system upgrades that may result in temporary service interruption.

We appreciate your patience as we improve our online experience.

Example Code

Extract All Data from Excel Worksheet

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

Code and Documents

Attachment

Overview
The example is to demonstrate how to extract the excel file and present it into the front panel of the VI

Description:
Extracting the excel file of the data with a VI could be achieved by open up the directory of the file located and leverage the property and invoke node of the elements inside the VI itself. With this, we could then present the data.
    
Steps to Implement or Execute Code:
To implement this example:

  1. Run the VI
  2. Determine the directory of the excel file
  3. (Optional) Turn on the Highlight Execution to see the flow of the VI

To execute this example:

  1. Install the required software.

Open the VI and refer the Implement Steps
 
Requirements
Software
LabVIEW 2012 or compatible


Hardware
-

 

fp.PNG

 

bd.PNG

**This document has been updated to meet the current required format for the NI Code Exchange.**

Justin D.

Applications Engineer
National Instruments

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

Comments
ctailor
Member
Member
on

Very nice..! It truly will save me some development time.  Thanks!

tecnico.bcn@gmail.com
Member
Member
on

Is it possible this example in to LV 8.2.1?. Thanks

Not applicable
on

I've uploaded an 8.0 version that can be opened with 8.2.1.