02-22-2024 01:20 AM
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?
It looks like that:
But it should look like that:
Kind regards,
Tim
Solved! Go to Solution.
02-22-2024 01:43 AM - edited 02-22-2024 01:45 AM
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!
02-22-2024 01:45 AM
@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:
02-22-2024 09:34 AM - edited 02-22-2024 09:35 AM
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 .
02-23-2024 12:49 AM
Hi GerdW,
thanks for your help, now it works fine.
Best regards,
Tim