| | |
|---|
| | | protected void service(HttpServletRequest req, HttpServletResponse resp)
|
|---|
| | | throws ServletException, IOException {
|
|---|
| | | String pageName = req.getParameter("pageName");
|
|---|
| | | String eName = req.getParameter("excelName");
|
|---|
| | | if(eName != null && eName.length()>0){
|
|---|
| | | excelName = eName;
|
|---|
| | | }
|
|---|
| | | |
|---|
| | | if (ServletUtils.isNotNull(pageName)) {
|
|---|
| | | if ("charge-test".equalsIgnoreCase(pageName)) {
|
|---|
| | | chargeExcelExprot(req, resp); //导出单个图表
|
|---|
| | |
|---|
| | | sheet1.createRow(rownum);
|
|---|
| | | sheet1.getRow(rownum).createCell(0).setCellValue(i>=picName.length?"":picName[i]);
|
|---|
| | | rownum++;
|
|---|
| | | HSSFClientAnchor anchor = new HSSFClientAnchor(0, 0, 512, 255,(short) 0, rownum, (short) 10, 25 * (i + 1));
|
|---|
| | | //anchor.setAnchorType(3);
|
|---|
| | | HSSFClientAnchor anchor = new HSSFClientAnchor(0, 0, 512, 255,(short) 0, rownum, (short) 10, 25 + rownum-1);
|
|---|
| | | anchor.setAnchorType(3);
|
|---|
| | | patriarch.createPicture(anchor,wb.addPicture(bytes.get(i),HSSFWorkbook.PICTURE_TYPE_PNG));
|
|---|
| | | rownum+=26;
|
|---|
| | | }
|
|---|
