JXL generate excel sheet with decimal value in Brazilian standard

Question

JXL generate excel sheet with decimal value in Brazilian standard

Navigation

#1 by (0 votes)

0

I'm using Java and Jsf on my system and there's a screen where you have the option to generate an excel spreadsheet. The generation of the worksheet is ok. The problem I'm encountering is in columns that have numeric values of type Double. For example:

NoticethatthevaluesofthetwocolumnsaregeneratedintheAmericanstandardwithadecimalpointinsteadofacomma.Thiswaywhentheuserisgoingtotakeadvantageoftheworksheettocreateaformulaandaddthevaluesexceldoesnotaccept,sincethisnumberformattingpatternisnottheBR.

ItriedtoformatthevaluesfortheBRstandardusingtheNumberFormatclasssee:

Ijustdonotknowwhytheheckwhenprintingthenumberthejxlputs'beforethenumber.Thiscontinuestopreventtheuserfromcreatingaformulatoaddthecells,becauseasithas'beforethenumberexcelseesitasStringandnotsum.Seeintheimagebelowthe'whichisprintedbeforethenumber:

Has anyone ever gone through this? How can I print the value in the BR standard so that the user who generated the worksheet can create formulas to add the cells? Thanks!

java excel jsf

asked by anonymous 26.10.2018 / 19:16

1 answer

Scroll hides Bootstrap Popover Aligning twiter bootstrap buttons inside a Table

score 0 · Answer 1

I managed to resolve. I'll post the solution in case someone encounters the same problem:

NumberFormat decimalNo = new NumberFormat("#,##0.00");
WritableCellFormat numberFormat = new WritableCellFormat(decimalNo);

planilha.addCell(new Number(col++, row, ((Double) item).doubleValue(), numberFormat));