Write Data to Excel Spreadsheet File in LabVIEW NXG

Updated Jan 9, 2019

Reported In

Software

  • LabVIEW NXG

Issue Details

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

Solution

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.

WAS THIS ARTICLE HELPFUL?

Not Helpful