Weird format behavior when writing numbers in Excel cells

[joptimus]

Hi guys,

I'm trying to wrap my head around a weird problem:

I write a 2D array of double (decimal delimiter is a comma, so 1/100 is 0,01) into an Excel Workbook. I created this file "Test.xlsx" by hand and did not change anything regarding formatting of the cells.

But what I get in Excel is this:

Why

1. is cell A1 different in formatting from all other cells (format and justification)

2. are the values of those other cells wrong? There seems to be a problem with the decimal delimiter.

Thanks for your input!

[zou]

The problem is on Excel side.

Has nothing to do with LabVIEW.

You can fix it in Excel manually.

Does Excel say number saved as text ?

Can you format the cell to number ?

[joptimus]

Thanks for your reply.

But regardless of how I format the cells in Excel, the outcome is still wrong.

From 0.01 (1/100) in LabView it goes to 1000 in Excel in all cells but A1.

[perhult · Accepted solution]

zou>> I do not think so, I think it is yet another situation where NI has not thought about countries that do not have the same decimal separator as the US.

joptimus>> The solution is to feed the array through "Number to Fractional String" with the setting "use system decimal point" = false and then feed it to Excel Easy Table.

Then it will work.

[joptimus]

Perfect, you saved my day! Thank you!

One follow up question remains though:

Can I somehow write an 1D array into existing Excel cells? The "easy table" VI seems to accept only 2D arrays.

[perhult]

You can simply feed the 1D array into "Build array", then it will become a 2D array.