package gabrieljones.poi;

import org.apache.poi.ss.usermodel.DataConsolidateFunction;
import org.apache.poi.ss.util.AreaReference;
import org.apache.poi.ss.util.CellReference;
import org.apache.poi.xssf.usermodel.XSSFPivotTable;
import org.apache.poi.xssf.usermodel.XSSFRow;
import org.apache.poi.xssf.usermodel.XSSFSheet;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;

import java.io.FileOutputStream;

public class Main {

    public static void main(String[] args) throws Exception {
        XSSFWorkbook wb = new XSSFWorkbook();
        XSSFSheet sheet = (XSSFSheet) wb.createSheet();

        XSSFRow row1 = sheet.createRow(0);
        row1.createCell(0).setCellValue("Names");
        row1.createCell(1).setCellValue("#");
        row1.createCell(2).setCellValue("Data");
        row1.createCell(3).setCellValue("Value");
        XSSFRow row2 = sheet.createRow(1);
        row2.createCell(0).setCellValue("Jan");
        row2.createCell(1).setCellValue(10);
        row2.createCell(2).setCellValue("Apa");
        row2.createCell(3).setCellValue(11.11);
        XSSFRow row3 = sheet.createRow(2);
        row3.createCell(0).setCellValue("Ben");
        row3.createCell(1).setCellValue(9);
        row3.createCell(2).setCellValue("Bepa");
        row3.createCell(3).setCellValue(12.12);

        XSSFPivotTable pivotTable = sheet.createPivotTable(new AreaReference("A1:D3"), new CellReference(0,5));

        pivotTable.addRowLabel(2);
        pivotTable.addColumnLabel(DataConsolidateFunction.COUNT, 1);
        pivotTable.addReportFilter(0); //This line renders the resulting xlsx file unreadable

        wb.write(new FileOutputStream("reportFilter.xlsx"));
    }
}