LAE

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: Nithya Priya

I am trying to output the data in excel. One of the column should be formatted as e.g 246.00
When I use double() function, i get 246 whereas I expect it to display as 246.00.
If I use format("%.02f",columnName), it displays as 246.00 but it appears as text which will be tough incase we need to do a sum on that column.
I also tried using the Template where I have set that particular column as Number format with "2" decimal places.But still it doesn't work.
Kindly help me with it.

Thanks

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: prasmussen

Nithya,

Please try the attached nodes after you save your Excel file using the Output Excel node. It will allow you to format an existing excel spreadsheet using a variety of number formats. For example, the "Format Excel Sheet Columns" node will format worksheet number 1 starting on row number 2 using the input specification to the node. E.g.
-Column 1 will format 2 decimal places using Excels 0.00 format
-Column 3 will format 5 decimal places using Excels 0.00000 format

The number of columns is variable and can be changed. Feel free to play around with the other MS excel number formats such as #.##, etc...

Paul
Attachments:
FormatExcelDoubleColumns.brn

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: Nithya Priya

Hi Paul,

Thank you very much for the quick reply. It works!!

Thanks,
Nithya