Report generation toolkit excel, decimal?

[Johan1300]

Hello!

I have problem with the report generation toolkit excel!

I only gets 3 decimals in excel?

Ex. In labview = 0.0458943 when i send it to excel = 0.046.

I use Excel easy table.vi to transfer my array, should I use someting else?

Ive already tryid to increase the decimal in excel but i doesent work.

Labview 8.6

Report generation toolkit ev 113 

[Mathan]

Solution

[Johan1300]

That solution does work, to use Array to spreadsheet string. Ive already tryed that but then I get a new problem, I get the whole array in one cell?

[Wayne.C]

Johan1300,

It sounds like you are writing a 2-D Array of doubles to excel.  The Excel Easy Table.vi converts numerics to strings before writing data to excel.  It is written to always use 3 decimal places.  You need to convert your 2-D array of doubles to strings before writing the info to excel.  Here are a couple of ways to make the conversion.  The top method is based on how the Excel Easy Table.vi makes the conversion.  Note that in both examples the format string constant sets the number of decimal places to 8.

Message Edited by Wayne.C on 04-08-2009 09:12 AM