java poi生成excel折线图、柱状图、饼图、动态列表

实现效果

测试类

public class ChartTest {    // 开始行    public static int chartRowStart = 3;    // 结束行    public static int chartRowEnd = 20;    public static ChartPosition chartPosition;    public static void main(String[] args) throws IOException {        // 填充数据        XSSFWorkbook workbook = createExcel();        FileOutputStream fileOut = null;        try {            // 将输出写入excel文件            String filename = UUID.randomUUID() + ".xlsx";            fileOut = new FileOutputStream(filename);            workbook.write(fileOut);            DesktopHelpers.openFile(filename);        } catch (Exception e) {            e.printStackTrace();        } finally {            workbook.close();            if (fileOut != null) {                fileOut.close();            }        }    }    public static XSSFWorkbook createExcel() {        XSSFWorkbook workbook = new XSSFWorkbook();        XSSFSheet sheet = workbook.createSheet();        //-------------------------折线图--------------------------        List lineCharts = initLineChart();        for (LineChart lineChart : lineCharts) {            // 图表位置（左上角坐标，右下角坐标） 左上角坐标的（列，行），（右下角坐标）列，行,偏移量均为0            chartPosition = new ChartPosition()                    .setRow1(chartRowStart)                    .setCol1(0)                    .setRow2(chartRowEnd)                    .setCol2(lineChart.getXAxisList().size() + 3);            ChartUtils.createLine(sheet, chartPosition, lineChart);        }        chartRowStart = chartRowEnd + 2;        chartRowEnd = chartRowStart + 20;        //-------------------------柱状图--------------------------        XSSFRow row = sheet.createRow(chartRowStart);        row.setHeight((short) 500);        XSSFCell cell0 = row.createCell(0);        cell0.setCellValue("测试柱状图");        cell0.setCellStyle(ChartUtils.tableNameCellStyle(workbook));        sheet.addMergedRegion(new CellRangeAddress(chartRowStart, chartRowStart, 0, 2));        // 获取数据        List pieCharts = initPieChart();        for (PieChart pieChart : pieCharts) {            // 图表位置（左上角坐标，右下角坐标） 左上角坐标的（列，行），（右下角坐标）列，行,偏移量均为0            chartPosition = new ChartPosition()                    .setRow1(chartRowStart + 1)                    .setCol1(0)                    .setRow2(chartRowEnd)                    .setCol2(8);            ChartUtils.createBar(sheet, chartPosition, pieChart);        }        chartRowStart = chartRowEnd + 2;        chartRowEnd = chartRowStart + 15;        //-------------------------饼图--------------------------        XSSFRow row1 = sheet.createRow(chartRowStart);        row1.setHeight((short) 500);        XSSFCell cell1 = row1.createCell(0);        cell1.setCellValue("测试饼图");        cell1.setCellStyle(ChartUtils.tableNameCellStyle(workbook));        sheet.addMergedRegion(new CellRangeAddress(chartRowStart, chartRowStart, 0, 2));        // 获取数据        for (PieChart pieChart : pieCharts) {            // 图表位置（左上角坐标，右下角坐标） 左上角坐标的（列，行），（右下角坐标）列，行,偏移量均为0            chartPosition = new ChartPosition()                    .setRow1(chartRowStart + 1)                    .setCol1(0)                    .setRow2(chartRowEnd)                    .setCol2(8);            ChartUtils.createPie(sheet, chartPosition, pieChart);        }        chartRowStart = chartRowEnd + 2;        chartRowEnd = chartRowStart + 15;        //-------------------------Excel--------------------------        // 获取列表数据        ChartUtils.createTable(chartRowStart, workbook, sheet);        // 去除网格线        // sheet.setDisplayGridlines(false);        return workbook;    }        public static List initLineChart() {        List lineCharts = new ArrayList<>();        lineCharts.add(new LineChart()                .setChartTitle("折线图")                .setTitleList(Arrays.asList("2020年", "2021年"))                .setDataList(Arrays.asList(Arrays.asList(1, 2, 3, 3, 1, 6, 3, 7, 12, 11, null, null), Arrays.asList(5, 4, 0, null, 12, 3, 8, 9, 11, 9, 2, 1)))                .setXAxisList(Arrays.