Hi Team,
Using the apache poi library am generating a excel sheet. I get values from
a backend sir via api calls, like 3650030. I have to format it to $3,650,030
in the Cell, but in the formula bar it should appear just a number. I am
assuming that DataFormatter.addFormat(string, Format format) is the
correct one to format the number to currency and save it in a Cell of the
generated spreadsheet.
I am setting the value 3650030 to cell using the code
cell.setCellValue((Long) cols.get(jj).getValue());
I am using the
NumberFormat numberFormat = NumberFormat.getCurrencyInstance();
numberFormat.setCurrency(Currency.getInstance(Locale.US));
dataFormatter.addFormat("($#,##0_);($#,##0)", numberFormat);
But how should i apply it to the cell object ?
Any help will be appreciated.
--
Thanks.
--
View this message in context:
http://apache-poi.1045710.n5.nabble.com/Currency-Formatting-using-POI-tp5711250.html
Sent from the POI - User mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
