Labview 2011 write2D array to spreadsheet file

[weitong]

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

[SteveChandler]

Edit: Nevermind - I saw you added the VIs while I was posting..

I just looked at your code. It is writing both columns.

[GerdW · Accepted solution]

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.

[weitong]

What do you mean?

[weitong]

I got it.

Thank you very much!

[altenbach]

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.