调整导出图片数据格式

whyclj

2019-06-29 f52dca61bb2dea08458e47d8112428152793b71a

调整导出图片数据格式

 sensor/src/com/fgkj/servlets/EchartPictureDowloadServlet.java

@@ -120,12 +120,12 @@
            HSSFPatriarch patriarch = sheet1.createDrawingPatriarch();

            for(int i=0;i<bytes.size();i++){

                sheet1.createRow(rownum);

                sheet1.getRow(rownum).createCell(1).setCellValue(i>=picName.length?"":picName[i]);

                sheet1.getRow(rownum).createCell(0).setCellValue(i>=picName.length?"":picName[i]);

                rownum++;

                HSSFClientAnchor anchor = new HSSFClientAnchor(0, 0, 512, 255,(short) 1, rownum, (short) 10, 25 * (i + 1));

                anchor.setAnchorType(3);

                patriarch.createPicture(anchor,wb.addPicture(bytes.get(i),HSSFWorkbook.PICTURE_TYPE_PNG)).resize(1);

                rownum+=25;

                HSSFClientAnchor anchor = new HSSFClientAnchor(0, 0, 512, 255,(short) 0, rownum, (short) 10, 25 * (i + 1));

                //anchor.setAnchorType(3);

                patriarch.createPicture(anchor,wb.addPicture(bytes.get(i),HSSFWorkbook.PICTURE_TYPE_PNG));

                rownum+=26;

            }

        }

    }