08-02-2012 09:51 AM - edited 08-02-2012 09:53 AM
Today I tried to write 2D array to a file with the "write to spreadsheet file" function with the newest LabVIEW 2011(f2).
But it generates the following results - all data in one column (supposed to be 2 column) .
LV2011
WT
Solved! Go to Solution.
08-02-2012 09:54 AM - edited 08-02-2012 09:59 AM
Edit: Nevermind - I saw you added the VIs while I was posting..
I just looked at your code. It is writing both columns.
08-02-2012 09:58 AM - edited 08-02-2012 09:59 AM
Hi weitong,
Excel defaults to expect semicolon as delimiter in csv files. Change your tab constant to a semicolon and all is fine...
Or open to file using the import dialog of Excel and set tabs as delimiter in step 1 of that wizard.
08-02-2012 09:59 AM
What do you mean?
08-02-2012 10:04 AM
I got it.
Thank you very much!
08-02-2012 10:19 AM - edited 08-02-2012 10:20 AM
You are not saying what extension you gave to the file. Excel can handle tab delimited tables easily, just give them a *.txt extension.
(using comma delimited (*.csv) is a can of worms, because the comma is also used a decimal seperator in some countries where other delimiters need to be used.)
Also note that if you build the array inside the loop, you don't need to transpose.