Reading Microsoft Excel Numeric Data Into LabVIEW
Primary Software: LabVIEW Development Systems>>LabVIEW Professional Development System
Primary Software Version: 8.2.1
Primary Software Fixed Version: N/A
Secondary Software: N/A
How can I read numeric data from my Microsoft Excel spreadsheet into LabVIEW?
There are two VIs that help with reading from a Microsoft Excel spreadsheet in LabVIEW:
Read From Measurement File Express VI:You may read numeric data in an Excel spreadsheet into LabVIEW using the Read From Measurement File Express VI through a two step process. First, save your Excel spreadsheet as a tab delimited text file. Then, rename the *.txt file as a *.lvm file. The Read From Measurement File Express VI can now read the numeric data into LabVIEW. The following steps will walk you through the procedure.
Read From Spreadsheet File VI (Read Delimited Spreadsheet VI):The LabVIEW VI
If you created your Excel spreadsheet by manually entering the data in (not using LabVIEW and
Note: Microsoft Word and Microsoft Excel are powerful standard software packages for creating reports. Because of their popularity, some LabVIEW users programmed LabVIEW ActiveX applications to dynamically control these document packages for generating reports from LabVIEW. The complexity of the ActiveX interface of those packages, however, makes the development of custom applications difficult. With the LabVIEW Report Generation Toolkit for Microsoft Office, you no longer have to learn the complex object models of Microsoft Word and Excel to generate a report. The Report Generation Toolkit is a library of flexible, easy-to-use VIs for programmatically creating and editing Microsoft Word and Excel reports from LabVIEW.
KnowledgeBase: 39RGHMZH: How do I Read or Write to Named Cells or Named Ranges in Excel Using the LabVIEW Report Generation Toolkit?
KnowledgeBase: 2FC9DK2L: Read From Spreadsheet File Does Not Return All Digits Of Precision
LabVIEW Report Generation Toolkit for Microsoft Office
LabVIEW 2011 Help: Read From Spreadsheet File VI
KnowledgeBase: 2FC9DK2L: Read From Spreadsheet File Does Not Return All Digits of Precision
Report Date: 08/29/2007
Last Updated: 08/28/2017
Document ID: 4CSI7PQ7