Archived:Write Data to Excel Spreadsheet File in LabVIEW NXG

Updated Apr 29, 2023

NI does not actively maintain this document.

This content provides support for older products and technology, so you may notice outdated links or obsolete information about operating systems or other relevant products.

Environment

Software

  • LabVIEW NXG

I would like to write data to an Excel file using LabVIEW NXG's report generation capabilities. How can I do this?

With the release of LabVIEW NXG 2.1, Excel logging capabilities have been added. In the Diagram Editor, select Storage >> Excel Report to view NXG's Excel functions. To write to a new or existing Excel file in LabVIEW NXG:
  1. Open an .xlsx file using the New Excel Report node.
  2. Write data using Create Excel Data Sheet. It can write different data types, e.g. DBL, I32, string.
  3. Use the Close Excel Report node to close the Excel file again.

Additional Information

It is also possible to insert charts into an Excel file using the Insert Excel Chart node.