Excel currency format using Apache POI

Question

I am using Apache POI to write Excel worksheets. I am very pleased with this, but I have the following problem: my program is multicurrency and internationalized. On the excel sheet I write, I want my currency cells to be formatted correctly. For this

I need a procedure that would build the correct Excel currency format (for example: "[$$ - 409] #, ## 0.00; - [$$ - 409] #, ## 0.00") from java.util. Currency and java..util. Local parameters.

Sort of: public String getExcelCurrencyFormat(Currency currency, Locale locale);

Does anyone know about such a library?

Answer 1

Excel ? Excel , ""?

java.text.NumberFormat.getCurrencyInstance(), , , , ( tostring() ).

.