LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

Save Array Data from Labview to CSV File

Solved!
Go to solution

Hi,

 

I would like to save my measurement data in a CSV file, unfortunately this does not work properly. Does anyone know where the error is?

 

 

 

Tim970_0-1708586001725.png

It looks like that:

Tim970_1-1708586072563.png

 

But it should look like that:

Tim970_2-1708586234158.png

 

Kind regards, 

 

Tim

Download All
0 Kudos
Message 1 of 5
(808 Views)
Solution
Accepted by topic author Tim970

Hi Tim,

 


@Tim970 wrote:

It looks like that:

 

But it should look like that:


When you create "real" CSV files as "comma separated files" then you need to tell MS-Excel to read them as "real" CSV files!

The problem here is clearly on Excel side...

 

Educated guess:

Are you working on a computer located in Germany (or in the same region, as the path control is labelled "Pfad")? Then Excel likes CSV files that use the semicolon instead of the comma as separator (by default). Simply replace the delimiter char at the WriteSpreadsheetFile function!

Best regards,
GerdW


using LV2016/2019/2021 on Win10/11+cRIO, TestStand2016/2019
0 Kudos
Message 2 of 5
(798 Views)

@GerdW wrote:

Excel likes CSV files that use the semicolon instead of the comma as separator (by default). Simply replace the delimiter char at the WriteSpreadsheetFile function!


And in additional, set "Append" flag to keep header in the file:

snippet1.png

0 Kudos
Message 3 of 5
(795 Views)

Hello Tim970,

 

GerdW is probably right in pointing out this is an Excel issue.

 

I'm assuming you use the English-language version of Excel. Perhaps you could try the following to get Excel to re-arrange your data correctly:

 

(1) Select all the cells in Excel containing your data.

(2) go to Data in the top bar and

(3) select the icon Text to Columns in the ribbon. This opens the Convert Text to Columns Wizard, a 3-step guide to help you convert your data.

(4) Under the caption Choose the file type that best describes your data, select Delimited and press the button Next > .

(5) The second step gives the option to chose your delimiters under the caption Delimiters. In your case, select Comma, then press the button Next >.

(5) The last step shows a preview of your data. If it looks alright, press Finish .

 

0 Kudos
Message 4 of 5
(743 Views)

Hi GerdW,

 

thanks for your help, now it works fine.

Best regards,

Tim

0 Kudos
Message 5 of 5
(696 Views)