参照博文echart图导出到pdf,将前台传到后台的二十四位字节编码生成图片,然后将图片导出到excel中。
public static void exportEchartsImg(HttpServletResponse response,List<String> pngName,String fileName,String path,Map<String, Object> map,String staticServer){
XSSFWorkbook book = new XSSFWorkbook();// 创建Excel文件
XSSFSheet sheet = book.createSheet(fileName); // 创建一个工作薄
BufferedImage bufferImg = null;
try{
XSSFDrawing patri = sheet.createDrawingPatriarch();//一个sheet只能一个
int rowBegin = 2;//起始行
int rowEnd = 20;//终止行
int rowBefore = 0;//起始列
int rowAfter = 3;//终止列
for(int i=0;i<pngName.size();i++){
ByteArrayOutputStream outputStream = new ByteArrayOutputStream();//一定要重新定义,不然输出始终是第一张
bufferImg = ImageIO.read(new File(path+pngName.get(i)));
ImageIO.write(bufferImg,"png",outputStream);
XSSFClientAnchor anchor = new XSSFClientAn