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) {// 图表位置（左上角坐标，右下角坐标） 左上角坐标的（列，行），（右下角坐标）列，行,偏移量均为0chartPosition = 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) {// 图表位置（左上角坐标，右下角坐标） 左上角坐标的（列，行），（右下角坐标）列，行,偏移量均为0chartPosition = 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) {// 图表位置（左上角坐标，右下角坐标） 左上角坐标的（列，行），（右下角坐标）列，行,偏移量均为0chartPosition = 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;}/** * 折线图 * @return */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.