Write Data to Excel Spreadsheet File in LabVIEW NXG

Updated Oct 25, 2020

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.