网站设计师网站,p2p网站建设小微金融,暴雪战网官方网站入口,重新建设网站的请示这是一个日报导出功能的代码;图片是用JfreeChars生成好的#xff0c;话不多少 看代码 public String excelExport(HttpServletRequest request,HttpServletResponse response,CarSaledailyDTO carSaledailyDTO){//获取需要导出的报表数据 ListListList图片是用JfreeChars生成好的话不多少 看代码 public String excelExport(HttpServletRequest request,HttpServletResponse response,CarSaledailyDTO carSaledailyDTO){//获取需要导出的报表数据 ListListList list carSaledailyFacade.excelData(carSaledailyDTO,request);HSSFWorkbook workbook new HSSFWorkbook();HSSFSheet sheet workbook.createSheet(销售日报);CellRangeAddress regionnew CellRangeAddress(0, 1, 0, 30);sheet.addMergedRegion(region);HSSFRow rowsheet.createRow(0);//合并列HSSFCell cellrow.createCell(0);HSSFFont f workbook.createFont();f.setFontName(黑体);f.setFontHeightInPoints((short) 22);//字号 f.setBoldweight(HSSFFont.BOLDWEIGHT_NORMAL);//加粗
HSSFCellStyle style workbook.createCellStyle(); style.setFont(f); style.setAlignment(HSSFCellStyle.ALIGN_CENTER);//左右居中style.setVerticalAlignment(HSSFCellStyle.VERTICAL_CENTER);//上下居中cell.setCellValue(日报);cell.setCellStyle(style);int r 2;for(int i 0;ilist.size();i){rcreateRow(list.get(i), sheet,r,workbook);} //cell.setCellStyle(style);//HSSFSheet sheet1 workbook.createSheet(全国每日提报量和成交合同量);FileInputStream stream;String path request.getSession().getServletContext().getRealPath(/);System.out.println(path);try {stream new FileInputStream(pathimages\\pic\\line.png);byte[] bytesnew byte[(int)stream.getChannel().size()];stream.read(bytes);//读取图片到二进制数组int pictureIdx workbook.addPicture(bytes, HSSFWorkbook.PICTURE_TYPE_JPEG);HSSFPatriarch patriarch sheet.createDrawingPatriarch();HSSFClientAnchor anchor new HSSFClientAnchor(0, 0, 0, 0, (short)0, 33, (short)20, 60);HSSFPicture pict patriarch.createPicture(anchor, pictureIdx);//pict.resize();//自动调节图片大小,图片位置信息可能丢失} catch (Exception e1) {// TODO Auto-generated catch blocke1.printStackTrace();}ByteArrayOutputStream os new ByteArrayOutputStream();try {workbook.write(os);} catch (IOException e) {e.printStackTrace();}byte[] content os.toByteArray();InputStream is new ByteArrayInputStream(content);try {// 设置response参数可以打开下载页面response.reset();response.setContentType(application/vnd.ms-excel;charsetutf-8);//response.setHeader(Content-Disposition, attachment;filename new String(.xls).getBytes(), iso-8859-1));String filename SaleDailyReportcarSaledailyDTO.getSearchDate().xls;response.setHeader(Content-Disposition, attachment;filename URLEncoder.encode(filename, UTF-8));ServletOutputStream out response.getOutputStream();BufferedInputStream bis null;BufferedOutputStream bos null;bis new BufferedInputStream(is);bos new BufferedOutputStream(out);byte[] buff new byte[2048];int bytesRead;// Simple read/write loop.while (-1 ! (bytesRead bis.read(buff, 0, buff.length))) {bos.write(buff, 0, bytesRead);}if (bis ! null)bis.close();if (bos ! null)bos.close();} catch (final IOException e) {e.printStackTrace();} return 导出成功;} 上面这个方法是koala框架里的基于spring mvc的一个controller完全可以忽略参数*DTO; public Integer createRow(ListList list,HSSFSheet sheet,int r,HSSFWorkbook workbook){for(int k 0;klist.size();k){HSSFCellStyle style workbook.createCellStyle();//设置边框样式style.setBorderTop(HSSFCellStyle.BORDER_THIN);style.setBorderBottom(HSSFCellStyle.BORDER_THIN);style.setBorderLeft(HSSFCellStyle.BORDER_THIN);style.setBorderRight(HSSFCellStyle.BORDER_THIN);//设置边框颜色style.setTopBorderColor(HSSFColor.BLACK.index);style.setBottomBorderColor(HSSFColor.BLACK.index);style.setLeftBorderColor(HSSFColor.BLACK.index);style.setRightBorderColor(HSSFColor.BLACK.index);style.setFillPattern(HSSFCellStyle.SOLID_FOREGROUND);if(r2){style.setFillForegroundColor(HSSFColor.YELLOW.index);}else if(r7||r15||r23||r31){style.setFillForegroundColor(HSSFColor.RED.index);}else if(r9){style.setFillForegroundColor(HSSFColor.GOLD.index);}else if(r17){style.setFillForegroundColor(HSSFColor.TAN.index);}else if(r25){style.setFillForegroundColor(HSSFColor.SEA_GREEN.index);}else{style.setFillForegroundColor(HSSFColor.WHITE.index);}HSSFRow row sheet.createRow(r);if(list.get(k)!null){for(int j 0;jlist.get(k).size();j){HSSFCell cell row.createCell(j);cell.setCellValue((list.get(k).get(j)));cell.setCellStyle(style);}}r1;}if(r8||r16||r24){HSSFRow row1 sheet.createRow(r);for(int j 0;jlist.get(0).size();j){HSSFCellStyle style workbook.createCellStyle();style.setFillPattern(HSSFCellStyle.SOLID_FOREGROUND);style.setFillForegroundColor(HSSFColor.GREY_50_PERCENT.index);HSSFCell cell row1.createCell(j);cell.setCellValue();cell.setCellStyle(style);}}r1;System.out.println(r);return r;} 除去Excel的标题‘日报’部分 和 图片导入其余数据写入及单元格样式设计实在createRow方法里面实现的 需要注意的是 1.我们在页面导出excel文档时都会涉及到一个导出路径选择的问题在第一段代码中设置response参数之后就可以实现发送到出请求时在直接在页面发送超链接请求如 2.使用浏览器导出excel的文件名如果是中文可能会出现乱码问题这里火狐浏览器比较特殊所以为了不出现乱码建议统一使用英文名 response.setHeader(Content-Disposition, attachment;filename new String(.xls).getBytes(), UTF-8));// 火狐浏览器 response.setHeader(Content-Disposition, attachment;filename URLEncoder.encode(filename, UTF-8));//其他转载于:https://www.cnblogs.com/Mu-yi/p/5465029.html
