How to set the number format of pivot data fields using Apache POI?

Question

I am currently setting the number format using the below code

pivotTable.getCTPivotTableDefinition().getDataFields().getDataFieldArray(0).setNumFmtId(2)

But i want to set the number format which is not there in format codes of setNumFmtId function Ex: 0.0 which is not there in formats

I can only see 0.00 but not 0.0 format in format codes.

Axel Richter · Accepted Answer · 2019-06-19 14:56:06Z

4

The NumFmtId is either one of the BuiltinFormats Ids. The Id 2 is 0.00 and, as you see, there is no 0.0 built in format.

Or it is the Id of a custom data format. A such must be created using Workbook.createDataFormat. The Id can be got using DataFormat.getFormat.

Example:

...
DataFormat dataformat = workbook.createDataFormat();
short numFmtId = dataformat.getFormat("0.0");

pivotTable.getCTPivotTableDefinition().getDataFields().getDataFieldArray(0).setNumFmtId(numFmtId);
...

answered Jun 19, 2019 at 14:56

Axel Richter

62.5k7 gold badges70 silver badges95 bronze badges

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

Collectives™ on Stack Overflow

How to set the number format of pivot data fields using Apache POI?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related