From Friday, April 19th (11:00 PM CDT) through Saturday, April 20th (2:00 PM CDT), 2024, ni.com will undergo system upgrades that may result in temporary service interruption.
We appreciate your patience as we improve our online experience.
From Friday, April 19th (11:00 PM CDT) through Saturday, April 20th (2:00 PM CDT), 2024, ni.com will undergo system upgrades that may result in temporary service interruption.
We appreciate your patience as we improve our online experience.
12-17-2015 02:42 PM
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!
Solved! Go to Solution.
12-17-2015 03:00 PM - edited 12-17-2015 03:01 PM
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 ?
12-18-2015 01:06 AM
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.
12-18-2015 04:40 AM
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.
12-18-2015 04:51 AM - edited 12-18-2015 05:18 AM
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.
12-18-2015 05:41 AM