Using JExcelApi to write BigInteger to xls with $ and , formatting

Question

I am trying to write values stored as BigDecimals e.g. 6789456123 to an xls file but I require the xls file to display $6,789,456,123 (As a currency with 0dp. I can do it as a string with this formatting however this ins't ideal). I am using JExcelApi and I am unable to figure out how to do this. Any help would be appreciated.

Thanks

Answer 1

Edit: You can convert a BigDecimal to double with the method .doubleValue(). Changed example to meet your needs.

---

Try to create a custom NumberFormat like this:

NumberFormat dollarCurrency = new NumberFormat(NumberFormat.CURRENCY_DOLLAR + " ###,###,###.00", NumberFormat.COMPLEX_FORMAT);
WritableCellFormat dollarFormat = new WritableCellFormat(dollarCurrency);
n = new Number(column, row, myBigDecimal.doubleValue(), dollarFormat);
s.addCell(n);

You can also read up on many other example here: jxl demo