LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

Labview - save XY-graph in excel

Solved!
Go to solution

Hello,

 

I wrote a Labview-program, which generates a XY-graph. I tried to save it in excel as xlsx. It workes, but the data are saved as a integer and not with the positions after decimal point.

How can I change this, to get the right graph in excel?

 

My VI and the excel-file are in the appendix.

 

Thanks for every help!

 

Download All
0 Kudos
Message 1 of 14
(6,732 Views)

How are you exporting the data from LabVIEW to Excel, manually or programmatically? I didn't see the data export implemented in the VI you attached. Are you right-clicking on the graph and choosing Export » Export Data to Excel?

dK
0 Kudos
Message 2 of 14
(6,715 Views)

From your filenames, it seems there might be some German in there. Make sure you define the correct decimal delimiter (period or comma). If it is wrong, you lose the decimals.

 

Do you do a right-click...export to excel on the xy graph?

Message 3 of 14
(6,696 Views)

From your filenames, it seems there might be some German in there. Make sure you define the correct decimal delimiter (period or comma). If it is wrong, you lose the decimals.

 


Good point!

dK
0 Kudos
Message 4 of 14
(6,690 Views)

I don't see where you save anything to Excel.  You don't seem to be doing this via LabVIEW, including writing the numeric data that appears in the .xlsx file.

 

I was expected to see that you were using the Report Generation Toolkit and creating a Graph in Excel.  But it's not in the code you attached.  Is there other code we need to see?

 

Bob Schor

0 Kudos
Message 5 of 14
(6,684 Views)

I am sorry! I just downloaded the Sub-Vi, which I use to generate the xy-graph. Exporting the data is a next sequence in my whole "big program", called program temcont.

 

I also tried to right-click... and export to excel.

 

What do you detailed mean with "there is some German in there"?

0 Kudos
Message 6 of 14
(6,679 Views)