java excel添加图片

private void drawLine1(Sheet sheetAt0,String title,List<ContractSpotInfoVo> list,List<ContractVO> contractVOList){
if(list == null || list.size() == 0)return;
    //这里绘制散点图
XSSFDrawing drawing = (XSSFDrawing) sheetAt0.createDrawingPatriarch();
    //前偏移量四个默认0
XSSFClientAnchor anchor = drawing.createAnchor(0, 0, 0, 0, 0, 48, 12, 67);
    //创建一个chart对象
XSSFChart chart = drawing.createChart(anchor);
    //标题
chart.setTitleText(title);
    //标题是否覆盖图表
chart.setTitleOverlay(false);

    // X轴
XDDFCategoryAxis xAxis =  chart.createCategoryAxis(AxisPosition.BOTTOM);
    xAxis.setMajorTickMark(AxisTickMark.NONE);// x轴刻度线
// Y轴
XDDFValueAxis yAxis = chart.createValueAxis(AxisPosition.LEFT);
    yAxis.setMajorTickMark(AxisTickMark.NONE);// y轴刻度线
yAxis.setTitle("MWh");

    xAxis.crossAxis(yAxis);
    yAxis.crossAxis(xAxis);

    XDDFLineChartData line = (XDDFLineChartData) chart.createData(ChartTypes.LINE, xAxis, yAxis);

    Map<String, List<ContractSpotInfoVo>> collect = list.stream().collect(Collectors.groupingBy(ContractSpotInfoVo::getInfoTime));

    List<String> xArray = new ArrayList<>();
    List<BigDecimal> yArray1 = new ArrayList<>();
    List<BigDecimal> yArray2 = new ArrayList<>();
    List<BigDecimal> yArray3 = new ArrayList<>();

    collect.entrySet().stream().sorted((o1,o2)->{
return o1.getKey().compareTo(o2.getKey());
    }).forEach(item->{
MxContractAnalyse2TableVo convert = convert(item.getValue(),contractVOList);
        if(convert == null)return;
        xArray.add(item.getKey()!=null?item.getKey().substring(0,5):"");
        yArray1.add(Optional.ofNullable(convert.getContractPower()).orElse(BigDecimal.ZERO));//合约电量
yArray2.add(Optional.ofNullable(convert.getContractPrice()).orElse(BigDecimal.ZERO));//合约电价
yArray3.add(Optional.ofNullable(convert.getSpotPrice()).orElse(BigDecimal.ZERO));//现货电价
});


    XDDFCategoryDataSource x = XDDFDataSourcesFactory.fromArray(xArray.toArray(new String[]{}));
    XDDFLineChartData.Series series1 = (XDDFLineChartData.Series) line.addSeries(x, XDDFDataSourcesFactory.fromArray(yArray1.toArray(new BigDecimal[]{})));
    series1.setTitle("合约电量",null);
    series1.setSmooth(false);
    series1.setMarkerSize((short)2);

    chart.plot(line);


    XDDFValueAxis yAxis2 = chart.createValueAxis(AxisPosition.RIGHT);
    yAxis2.setMajorTickMark(AxisTickMark.NONE);// y轴刻度线

xAxis.crossAxis(yAxis2);
    yAxis2.crossAxis(xAxis);
    yAxis2.setCrosses(AxisCrosses.MAX);
    yAxis2.setTitle("元/MWh");

    XDDFLineChartData line2 = (XDDFLineChartData) chart.createData(ChartTypes.LINE, xAxis, yAxis2);

    XDDFLineChartData.Series series2 = (XDDFLineChartData.Series) line2.addSeries(x, XDDFDataSourcesFactory.fromArray(yArray2.toArray(new BigDecimal[]{})));
    series2.setTitle("合约电价",null);
    series2.setSmooth(false);
    series2.setMarkerSize((short)2);

    XDDFLineChartData.Series series3 = (XDDFLineChartData.Series) line2.addSeries(x, XDDFDataSourcesFactory.fromArray(yArray3.toArray(new BigDecimal[]{})));
    series3.setTitle("现货电价",null);
    series3.setSmooth(false);
    series3.setMarkerSize((short)2);

    //图例位置
XDDFChartLegend legend = chart.getOrAddLegend();
    legend.setPosition(LegendPosition.BOTTOM);

    // 样式线
XDDFLineProperties line123  =  new XDDFLineProperties();
    line123.setFillProperties(new XDDFSolidFillProperties(XDDFColor.from(new byte[] {(byte)228,(byte)231,(byte)237})));
    line123.setWidth(0.5);
    XDDFShapeProperties yGridProperties = yAxis.getOrAddMajorGridProperties();
    yGridProperties.setLineProperties(line123);

    chart.plot(line2);
}