Academic Company Events Community Support Solutions Products & Services Contact NI MyNI
17 ratings:
 2.76 out of 5   

Exporting Graph Data to Excel After VI Has Run



Primary Software: LabVIEW Development Systems>>LabVIEW Base Development System
Primary Software Version: N/A
Primary Software Fixed Version: N/A
Secondary Software: N/A

Problem:
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.


Related Links:
LabVIEW 2012 Help: Exporting Data and Images
KnowledgeBase 0HLH2GTA:  What is the Difference Between Graphs and Charts in LabVIEW?
KnowledgeBase 77FHM9K8: Why Is My Data Incorrect When Using the Export to Excel Method in LabVIEW?

Attachments:





Report Date: 10/27/2010
Last Updated: 08/29/2017
Document ID: 5EQEP2OG

Your Feedback! poor Poor  |  Excellent excellent   Yes No
 Document Quality? 
 Answered Your Question? 
  1 2 3 4 5
Please Contact NI for all product and support inquiries.submit