Excel Formatting in Java

Question

I am using Apache POI jars to write excel in Java.

For the below code(referred from other websites), it uses HSSFCellUtil.java class from poi-contrib.jar. This jar doesn't come in the latest release of poi-3.14.jar.

I am getting compile time error at HSSFCellUtil.DATA_FORMAT. Can anyone suggest me the alternative for Excel Formatting.

HSSFCellUtil.setCellStyleProperty(cell, workbook,
                    HSSFCellUtil.DATA_FORMAT,
                    format.getFormat("($#,##0.00);($#,##0.00)"));

Vicky Thakor · Accepted Answer · 2016-06-01 05:55:25Z

1

Try using org.apache.poi.ss.util.CellUtil

DataFormat dataFormat = workbook.createDataFormat();
CellUtil.setCellStyleProperty(cell, workbook, CellUtil.DATA_FORMAT, dataFormat.getFormat("$#,##0.00;$#,##0.00"));

answered Jun 1, 2016 at 5:55

Vicky Thakor

3,9389 gold badges45 silver badges72 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Ico · Accepted Answer · 2021-04-28 11:18:43Z

0

I use org.apache.poi.ss.util.CellUtil and it works

Replace

CellUtil.setCellStyleProperty(cell, workbook, HSSFCellUtil.DATA_FORMAT, dataFormat.getFormat("$#,##0.00;$#,##0.00"));

with this

CellUtil.setCellStyleProperty(cell, workbook, CellUtil.DATA_FORMAT, dataFormat.getFormat("$#,##0.00;$#,##0.00"));

answered Apr 28, 2021 at 11:18

Ico

11 bronze badge

Collectives™ on Stack Overflow

Excel Formatting in Java

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related