Apache POI透视表-如何在Java中使用“介于”值筛选器

Workbook workbook = new XSSFWorkbook();
Sheet sheet = workbook.createSheet("Pivot Table");

Row row = sheet.createRow(0);
Cell cell1 = row.createCell(0);
cell1.setCellValue("Name");

Row row2 = sheet.createRow(1);
Cell cell2 = row2.createCell(0);
cell2.setCellValue("John");

// 插入更多数据...

AreaReference source = new AreaReference("A1:A10", SpreadsheetVersion.EXCEL2007);
CellReference position = new CellReference("C1");
PivotTable pivotTable = sheet.createPivotTable(source, position);

pivotTable.addRowLabel(0); // 添加行字段
pivotTable.addColumnLabel(DataConsolidateFunction.SUM, 0); // 添加值字段
pivotTable.getCTPivotTableDefinition().setRowLabelCaption("Name"); // 设置行字段的标题

// 添加筛选器
CTPivotFilters filters = pivotTable.getCTPivotTableDefinition().getFilters();
CTFilter filter = filters.addNewFilter();
filter.setVal(STFilterType.VALUES);
filter.addNewAutoFilter().setVal(STFilterOperator.BETWEEN);
filter.getAutoFilter().addNewFilterColumn().setColId(0);
filter.getAutoFilter().getFilterColumnArray(0).addNewBetween().setVal1("A");
filter.getAutoFilter().getFilterColumnArray(0).getBetween().setVal2("Z");

FileOutputStream fileOut = new FileOutputStream("pivot_table.xlsx");
workbook.write(fileOut);
fileOut.close();
workbook.close();