This project has moved. For the latest updates, please go here.

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

May 23, 2013 at 1: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
TOTAL
ALLOCAT
ED
CHARGES

I want it to be like
TOTAL
ALLOCATED
CHARGES.

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!