Company Events Academic Community Support Solutions Products & Services Contact NI MyNI

Excel Files

LabVIEW 2013 Help

Edition Date: June 2013

Part Number: 371361K-01

»View Product Info

In LabVIEW, you can use the Write To Measurement File Express VI to save the dynamic data you acquire to a Microsoft Excel file (.xlsx). This Express VI uses the Office Open XML file format, which conforms to the international standard ISO/IEC 29500:2008, to create the Excel file. Refer to the International Organization for Standardization website at www.iso.org for information about the ISO/IEC 29500:2008 standard.

Note  If your application uses the Excel file format, you cannot save the application for a previous version of LabVIEW, such as 12.0 or earlier. You must modify the application to use another file format before saving it for a previous version.

To write data to an Excel file, you do not need to install Microsoft Excel. To view the data in the Excel file, you must have one of the following spreadsheet viewers installed:

  • Microsoft Excel 2007 or later
  • OpenOffice 3.0.0 or later
  • LibreOffice 3.4.5 or later
  • Lotus Symphony Spreadsheets 8.5.2FP2 or later

Each spreadsheet viewer has a maximum value for the number of rows and columns of data you can view. Errors might occur if the amount of data you write to an Excel file exceeds the maximum value. Refer to the documentation for each spreadsheet viewer for information about the maximum value you can view in an Excel file.

After you write data to an Excel file, you can import the Excel file to other National Instruments software applications, such as DIAdem 2010 or later. Refer to the documentation for DIAdem for information about importing Excel files.

Refer to the Write Excel File VI in the labview\examples\File IO\Spreadsheet\Excel folder for an example of using the Write To Measurement File Express VI to write data to an Excel file.


 

Your Feedback! poor Poor  |  Excellent excellent   Yes No
 Document Quality? 
 Answered Your Question? 
Add Comments 1 2 3 4 5 submit