Exporting Graph Data to Excel After VI Has Run

Updated Dec 27, 2017

Reported In

Software

  • LabVIEW Professional
  • LabVIEW Base
  • LabVIEW Full

Issue Details

I have already run my VI and I want to export the data from my graph or chart to Excel. How can I do this?

Solution

In LabVIEW 2010 and later, there is built-in functionality to export your graph data to Excel.
  1. Right click on the graph or chart.
  2. Choose Export»Export Data to Excel. (This will automatically open and populate an Excel worksheet with the exported data)
  3. Save the Excel workbook to your desired location.

In LabVIEW 2009 and earlier, there is no option to directly export your data to Excel. To export your data, follow these steps:
  1. Right click on the graph or chart.
  2. Choose Data Operations»Copy Data.
  3. Open a new VI by selecting File»New VI.
  4. Paste the data into the new VI by selecting Edit»Paste. A copy of your graph or chart should appear on the front panel of the new VI.
  5. On the block diagram of your new VI, change the graph or chart to a control by right clicking on it and selecting Change to Control.
  6. Now you can wire this control to any VI that will write to Excel. For example, you can use the Write to Spreadsheet File VI.
  7. Run the VI and your data will be exported to an Excel file.

WAS THIS ARTICLE HELPFUL?

Not Helpful