03-14-2018 09:39 AM
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!
Solved! Go to Solution.
03-14-2018 09:57 AM
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?
03-14-2018 10:26 AM
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?
03-14-2018 10:45 AM
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!
03-14-2018 11:11 AM
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
03-14-2018 12:14 PM
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"?