因为nbcio-boot项目用到了poi5.0.0，但本身我看autoPOI现在只能支持poi4.12，所以需要改造这个jar，以便使用，随便也上传一下到maven中央库里去。
主要如下：
1、POM父文件修改成自己的版本，同时根据上传maven库要求进行修改；
2、修改cell.getCellTypeEnum()为cell.getCellType(),这个很多文件都要用到；都需要修改；
3、getNumberOfFonts类型变了，由short变成int了，需要修改；
4、ExcelChartBuildService这个文件需要修改，这里修改的地方比较多，所以放在后面了，这样就可以试用poi5.0.0了
/** * */ package org.jeecgframework.poi.excel.graph.builder; import java.util.ArrayList; import java.util.List; import org.apache.commons.lang3.StringUtils; //import org.apache.poi.ss.usermodel.Chart; import org.apache.poi.ss.usermodel.ClientAnchor; import org.apache.poi.ss.usermodel.Drawing; import org.apache.poi.ss.usermodel.Sheet; import org.apache.poi.ss.usermodel.Workbook; import org.apache.poi.xddf.usermodel.chart.*; import org.apache.poi.xssf.usermodel.XSSFSheet; /*import org.apache.poi.ss.usermodel.charts.AxisCrosses; import org.apache.poi.ss.usermodel.charts.AxisPosition; import org.apache.poi.ss.usermodel.charts.ChartAxis; import org.apache.poi.ss.usermodel.charts.ChartDataSource; import org.apache.poi.ss.usermodel.charts.ChartLegend; import org.apache.poi.ss.usermodel.charts.DataSources; import org.apache.poi.ss.usermodel.charts.LegendPosition; import org.apache.poi.ss.usermodel.charts.LineChartData; import org.apache.poi.ss.usermodel.charts.ScatterChartData; import org.apache.poi.ss.usermodel.charts.ValueAxis;*/ import org.apache.poi.ss.util.CellRangeAddress; import org.jeecgframework.poi.excel.graph.constant.ExcelGraphElementType; import org.jeecgframework.poi.excel.graph.constant.ExcelGraphType; import org.jeecgframework.poi.excel.graph.entity.ExcelGraph; import org.jeecgframework.poi.excel.graph.entity.ExcelGraphElement; import org.jeecgframework.poi.excel.graph.entity.ExcelTitleCell; import org.jeecgframework.poi.util.PoiCellUtil; import org.jeecgframework.poi.util.PoiExcelGraphDataUtil; /** * @Description * @author liusq * @data 2022年1月4号 */ public class ExcelChartBuildService { /** * * @param workbook * @param graphList * @param build 通过实时数据行来重新计算图形定义 * @param append */ public static void createExcelChart(Workbook workbook, List<ExcelGraph> graphList, Boolean build, Boolean append) { if(workbook!=null&&graphList!=null){ //设定默认第一个sheet为数据项 Sheet dataSouce=workbook.getSheetAt(0); if(dataSouce!=null){ buildTitle(dataSouce,graphList); if(build){ PoiExcelGraphDataUtil.buildGraphData(dataSouce, graphList); } if(append){ buildExcelChart(dataSouce, dataSouce, graphList); }else{ Sheet sheet=workbook.createSheet("图形界面"); buildExcelChart(dataSouce, sheet, graphList); } } } } /** * 构建基础图形 * @param drawing * @param anchor * @param dataSouce * @param graph */ private static void buildExcelChart(Drawing drawing,ClientAnchor anchor,Sheet dataSouce,ExcelGraph graph){ XDDFChart chart = null; // TODO 图表没有成功 //drawing.createChart(anchor); XDDFChartLegend legend = chart.getOrAddLegend(); legend.setPosition(LegendPosition.TOP_RIGHT); XDDFChartAxis bottomAxis = chart.createCategoryAxis(AxisPosition.BOTTOM); XDDFValueAxis leftAxis = chart.createValueAxis(AxisPosition.LEFT); leftAxis.setCrosses(AxisCrosses.AUTO_ZERO); ExcelGraphElement categoryElement=graph.getCategory(); XDDFDataSource categoryChart; if(categoryElement!=null&& categoryElement.getElementType().equals(ExcelGraphElementType.STRING_TYPE)){ categoryChart=XDDFDataSourcesFactory.fromStringCellRange((XSSFSheet) dataSouce, new CellRangeAddress(categoryElement.getStartRowNum(),categoryElement.getEndRowNum(),categoryElement.getStartColNum(),categoryElement.getEndColNum())); }else{ categoryChart=XDDFDataSourcesFactory.fromNumericCellRange((XSSFSheet) dataSouce, new CellRangeAddress(categoryElement.getStartRowNum(),categoryElement.getEndRowNum(),categoryElement.getStartColNum(),categoryElement.getEndColNum())); } List<ExcelGraphElement> valueList=graph.getValueList(); List<XDDFDataSource<Double>> chartValueList= new ArrayList<>(); if(valueList!=null&&valueList.size()>0){ for(ExcelGraphElement ele:valueList){ XDDFDataSource<Double> source=XDDFDataSourcesFactory.fromNumericCellRange((XSSFSheet) dataSouce, new CellRangeAddress(ele.getStartRowNum(),ele.getEndRowNum(),ele.getStartColNum(),ele.getEndColNum())); chartValueList.add(source); } } if(graph.getGraphType().equals(ExcelGraphType.LINE_CHART)){ //buildLineChartData(data, categoryChart, chartValueList, graph.getTitle()); XDDFLineChartData data = (XDDFLineChartData) chart.createData(ChartTypes.LINE, bottomAxis, leftAxis); chart.plot(data); } else { XDDFScatterChartData data= (XDDFScatterChartData) chart.createData(ChartTypes.SCATTER, bottomAxis, leftAxis); buildScatterChartData(data, categoryChart, chartValueList,graph.getTitle()); chart.plot(data); } } /** * 构建多个图形对象 * @param dataSouce * @param dataSouce2 * @param graphList */ private static void buildExcelChart(Sheet dataSouce,Sheet dataSouce2,List<ExcelGraph> graphList){ int len=graphList.size(); if(len==1) { buildExcelChart(dataSouce, dataSouce2, (List<ExcelGraph>) graphList.get(0)); } else { int drawStart=0; int drawEnd=20; Drawing drawing = PoiExcelGraphDataUtil.getDrawingPatriarch(dataSouce2); for(int i=0;i<len;i++){ ExcelGraph graph=graphList.get(i); ClientAnchor anchor = drawing.createAnchor(0, 0, 0, 0, 0, drawStart, 15, drawEnd); buildExcelChart(drawing, anchor, dataSouce, graph); drawStart=drawStart+drawEnd; drawEnd=drawEnd+drawEnd; } } } /** * 构建图形对象 * @param dataSourceSheet * @param tragetSheet * @param graph */ private static void buildExcelChart(XSSFSheet dataSourceSheet,Sheet tragetSheet,ExcelGraph graph){ Drawing drawing = PoiExcelGraphDataUtil.getDrawingPatriarch(tragetSheet); ClientAnchor anchor = drawing.createAnchor(0, 0, 0, 0, 0, 0, 15, 20); buildExcelChart(drawing, anchor, dataSourceSheet, graph); } /** * 构建Title * @param sheet * @param graph */ private static void buildTitle(Sheet sheet,ExcelGraph graph){ int cellTitleLen=graph.getTitleCell().size(); int titleLen=graph.getTitle().size(); if(titleLen>0){ }else{ for(int i=0;i<cellTitleLen;i++){ ExcelTitleCell titleCell=graph.getTitleCell().get(i); if(titleCell!=null){ graph.getTitle().add(PoiCellUtil.getCellValue(sheet,titleCell.getRow(),titleCell.getCol())); } } } } /** * 构建Title * @param sheet * @param graphList */ private static void buildTitle(Sheet sheet,List<ExcelGraph> graphList){ if(graphList!=null&&graphList.size()>0){ for(ExcelGraph graph:graphList){ if(graph!=null) { buildTitle(sheet, graph); } } } } /** * * @param data * @param categoryChart * @param chartValueList * @param title */ private static void buildLineChartData(XDDFLineChartData data,XDDFDataSource categoryChart,List<XDDFDataSource<Number>> chartValueList,List<String> title){ if(chartValueList.size()==title.size()) { int len=title.size(); for(int i=0;i<len;i++){ //TODO 更新版本 //data.addSerie(categoryChart, chartValueList.get(i)).setTitle(title.get(i)); } } else { int i=0; for(XDDFDataSource<Number> source:chartValueList){ String temp_title=title.get(i); if(StringUtils.isNotBlank(temp_title)){ //data.addSerie(categoryChart, source).setTitle(_title); }else{ //data.addSerie(categoryChart, source); } } } } /** * * @param data * @param categoryChart * @param chartValueList * @param title */ private static void buildScatterChartData(XDDFScatterChartData data,XDDFDataSource categoryChart,List<XDDFDataSource<Double>> chartValueList,List<String> title){ if(chartValueList.size()==title.size()) { int len=title.size(); for(int i=0;i<len;i++){ data.addSeries(categoryChart, (XDDFNumericalDataSource<? extends Number>) chartValueList.get(i)).setTitle(title.get(i).toString(), null); } } else { int i=0; for(XDDFDataSource<Double> source:chartValueList){ String temp_title=title.get(i); if(StringUtils.isNotBlank(temp_title)){ data.addSeries(categoryChart, (XDDFNumericalDataSource<? extends Number>) source).setTitle(temp_title,null); }else{ data.addSeries(categoryChart, (XDDFNumericalDataSource<? extends Number>) source); } } } } }
