Writing Data from LabVIEW to Different Worksheets of Excel

Updated Dec 22, 2023

Reported In

Software

  • LabVIEW
  • LabVIEW Report Generation Toolkit

Issue Details

I want to log data from LabVIEW to different worksheets of an Excel file. How can I do this?

Solution

One way to save data coming from LabVIEW to different worksheets of an Excel file is to use the Excel Add Worksheet.vi that is part to the Report Generation Toolkit and to save the data into this Worksheet. In the image below it is exemplified and explained this approach:



Note that the amount of worksheets, the data in each worksheet and the name of the worksheet can be defined programmatically for each one. 

Additional Information

There are also several ways to export LabVIEW data to Excel without the Report Generation Toolkit.