Example usage for org.apache.poi.xssf.usermodel XSSFPivotTable getCTPivotTableDefinition

Introduction

In this page you can find the example usage for org.apache.poi.xssf.usermodel XSSFPivotTable getCTPivotTableDefinition.

Prototype

@Beta
    @Internal
    public CTPivotTableDefinition getCTPivotTableDefinition() 

Source Link

Usage

From source file:ru.inkontext.poi.CreatePivotTableSimple.java

License:Apache License

private static void setFormatDataField(XSSFPivotTable pivotTable, long fieldIndex, long numFmtId) {
    Optional.ofNullable(pivotTable.getCTPivotTableDefinition().getDataFields())
            .map(CTDataFields::getDataFieldList).map(List::stream)
            .ifPresent(stream -> stream.filter(dataField -> dataField.getFld() == fieldIndex).findFirst()
                    .ifPresent(dataField -> dataField.setNumFmtId(numFmtId)));
}

---

From source file:ru.inkontext.poi.CreatePivotTableSimple.java

License:Apache License

private static void setFormatPivotField(XSSFPivotTable pivotTable, long fieldIndex, Integer numFmtId) {
    Optional.ofNullable(pivotTable.getCTPivotTableDefinition().getPivotFields())
            .map(pivotFields -> pivotFields.getPivotFieldArray((int) fieldIndex))
            .ifPresent(pivotField -> pivotField.setNumFmtId(numFmtId));
}

---

From source file:ru.inkontext.poi.CustomPivotTable.java

License:Apache License

public CustomPivotTable safeExcludeSubTotal(XSSFPivotTable pivotTable, int fieldIndex) {
    Optional.ofNullable(pivotTable.getCTPivotTableDefinition().getPivotFields())
            .map(pivotFields -> pivotFields.getPivotFieldArray(fieldIndex))
            .ifPresent(pivotField -> Optional.ofNullable(pivotField.getItems()).ifPresent(items -> {
                for (int i = 0; i < 2; i++) {
                    items.getItemArray(i).unsetT();
                    items.getItemArray(i).setX((long) i);
                }// ww  w .j  av  a  2s . c  om
                for (int i = items.sizeOfItemArray() - 1; i > 1; i--)
                    items.removeItem(i);
                items.setCount(2);

                Optional.ofNullable(
                        pivotTable.getPivotCacheDefinition().getCTPivotCacheDefinition().getCacheFields())
                        .map(CTCacheFields::getCacheFieldArray)
                        .ifPresent(ctCacheFields -> Optional.ofNullable(ctCacheFields[fieldIndex])
                                .map(CTCacheField::getSharedItems).ifPresent(ctSharedItems -> {
                                    ctSharedItems.addNewS().setV(" ");
                                    ctSharedItems.addNewS().setV("  ");
                                }));

                pivotField.setDefaultSubtotal(false);
            }));
    return this;
}

---