java poi 数据透视_java – 使用Apache POI将列标签插入数据透视表？

我使用Apache POI 3.11创建了一个数据透视表.像这样：

FileInputStream file = new FileInputStream(new File(path+fname));

XSSFWorkbook workbook = new XSSFWorkbook(file);

XSSFSheet sheet = workbook.getSheetAt(0);

//area of pivot data

AreaReference a=new AreaReference("A1:J4");

CellReference b=new CellReference("N5");

XSSFPivotTable pivotTable = sheet.createPivotTable(a,b);

//insert row

pivotTable.addRowLabel(3);

pivotTable.addRowLabel(6);

//insert column

pivotTable.addColumnLabel(DataConsolidateFunction.COUNT,5);

//export

FileOutputStream output_file =

new FileOutputStream(new File(path+"POI_XLS_Pivot_Example.xlsx"));

workbook.write(output_file);//write excel document to output stream

output_file.close(); //close the file

生成报告后,它会正确显示行.但它没有显示列标签