Apache POI Currency Formating

> This gives Java error that getFormat can only accept

> String and not int.

Then use the String mentioned in the documentation for POI.

"($#,##0.00);($#,##0.00)"

> I am using 2.0 version of POI, should I upgrade?

You might, but you haven't yet stumbled upon something which you cannot solve. In POI 2.5, there were several features added which could create a better Excel workbook. If you need some of those features, you might consider upgrading.

It's not a big deal to upgrade anyway. You need to only swap a JAR, but I should warn you that some of the API was changed incompatibly and you might need to modify your code and recompile it again to make it work after the upgrade. In any case, I would suggest that you search for the changelog of the latest version and check.

aniseeda at 2007-7-14 23:28:09 >

> But I have my last question..

> How do I display Euro symbol for currency?

> Your option worked perfect and showed the $ symbol.

The symbol for the currency would depend on the OS locale (that's the way Excel works). If your locale is set to point to somewhere in Europe, I suppose it would show up Euro instead of the Dollar.

Okay, I verified it as well. I changed from the Control Panel > Regional and Language Options to English UK and it started showing the Pound instead of the Dollar.

I hope that answers your question.

aniseeda at 2007-7-14 23:28:09 >

Well, I made the suggestion based on the code page without trying anything in the hopes that it would help. Obviously, it didn't.

So I did a little more looking around, and Microsoft has inserted the euro at index 128 in their 1252 codeset (\u0080). I can't get that to display correctly either.

The only alternative I have left, and which I don't have time for this afternoon, is to create a worksheet with one cell formatted with a euro, read it in with POI, and print out the resulting format. That will definitely give you *A* format option, but I don't know if it will translat back into a new page from POI.

cafala at 2007-7-21 11:00:08 >

After a single test, I have to say I now prefer the JExcel API as well. The following code to have a euro sign appear worked on the first try:

WritableWorkbook workbook =

Workbook.createWorkbook(new File("output.xls"));

WritableSheet sheet = workbook.createSheet("First Sheet", 0);

jxl.write.NumberFormat euros =

new jxl.write.NumberFormat("\u20AC#,##0.00");

WritableCellFormat eurosFormat = new WritableCellFormat(euros);

jxl.write.Number numberCell =

new jxl.write.Number(0, 0, 123.33, eurosFormat);

sheet.addCell(numberCell);

workbook.write();

workbook.close();

Output - cell(0,0): 123.33

As you can see, the code accepted the standard value for a euro sign (\u20AC) without any problems.

cafala at 2007-7-21 11:00:08 >

Cafal,

I appreciate your patience with me, but in Java if you format Euro by Locale the symbol appears after the number and not before the number.

Example: 4 052,60

But using Jexcel approach I specified

" jxl.write.NumberFormat("#,##0.00 \u20AC"); " did not give me the Euro symbol . I just gave the number.

Please help on this and I will close this issue.

garollousa at 2007-7-21 11:00:08 >

To get it to append the euro symbol I had to tell it not to validate the pattern:jxl.write.NumberFormat euros =

new jxl.write.NumberFormat("#,#00.00 \u20AC", jxl.write.NumberFormat.COMPLEX_FORMAT);

That worked fine for me.

cafala at 2007-7-21 11:00:08 >