This project has moved and is read-only. For the latest updates, please go here.

Two questions, Numberformat for currency and wrap= true wrapping words as well

May 23, 2013 at 2:52 PM
First of all i would like to thank for wonderful library.

I am able to export data to excel in a way that i wanted except with some issues that i am sure will be answered here.

I have column name as "TOTAL ALLOCATED CHARGES". It has all numbers. Now I set wrap = true.
What it does is that it wraps it in following way

I want it to be like

There is second question
I am exporting data from datatable. It has decimal type column which is currency. It has values like 0.0000, 10.0000. I want to display it like $0.00, $10.00. Can you please suggest Numberformat for this?

Thank you in advance!