Academic Company Events Community Support Solutions Products & Services Contact NI MyNI
15 ratings:
 2.53 out of 5     Rate this Document

Exporting Graph Data to Excel After VI Has Run



Primary Software:
Primary Software Version: 2010
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 2012, 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.  

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 should appear on the front panel of the new VI.
  5. On the block diagram of your new VI, change the graph 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:
KnowledgeBase 2W0GOMW0 : How to Send A Multiple Plot XY Graph from LabVIEW to Microsoft Excel
LabVIEW 2012 Help: Exporting Data and Images

Attachments:





Report Date: 10/27/2010
Last Updated: 09/15/2012
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