Home Community Example Programs Example Code Document

Example Code

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
ASK A QUESTION

Manipulate Excel Data in LabVIEW

by:
‎09-08-2008 08:01 PM
Last Edited by: Member example_scrubber_matteo ‎09-27-2017 02:58 PM

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

Download All

Overview

The Read_Excel_Values.llb is a collection of subvis that can be used to manipulate data stored in a Excel spreadsheet.

 

Description

The Excel Reader.VI is the main example of how to use the subvis to connect with Excel using ActiveX controls. The other vis are the actual activex controls that interface with the Excel spreadsheet. This works with Excel 2003, 2007, 2016 but hasn't been tested on anything else. The code could be manipulate to allow for future Excel versions.


Requirements
LabVIEW 2012 (or Compatible)

 

Steps to Implement or Execute Code

  1. Download the "Read_Excel_Values.llb" from this website

  2.  Open the LLB and explore "Get Excel values.vi" 

Main VI Snippet:

Read_Excel_Values LV2012_NI_Verified.png

 

**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.

Comments
pflores
NI Employee (retired)
on
‎04-05-2010 03:26 PM
‎04-05-2010 03:26 PM

Check out this related example: http://decibel.ni.com/content/docs/DOC-10546

---

Peter Flores
Applications Engineer
0 Kudos
Mark20
Member
Member
on
‎12-13-2010 07:44 AM
‎12-13-2010 07:44 AM

Excellent!  Let me access test vectors stored in a spreadsheet without having to convert the spreadsheet to a another format.

0 Kudos