JAVA的poi实现模版导出excel(带图片)

《JAVA的poi实现模版导出excel(带图片)》由会员上传分享，免费在线阅读，更多相关内容在教育资源-天天文库。

1、下面是本人使用java的poi实现使用模板到处excel，内容包含图片，使用两种不同的方式实现其到处excel。但是使用jxl实现到处excel只能到处png格式。packagecom.rxc.servlet;importjava.awt.image.BufferedImage;importjava.io.BufferedInputStream;importjava.io.BufferedOutputStream;importjava.io.ByteArrayOutputStream;importjava.io.File;importjava.io.FileInput

2、Stream;importjava.io.FileOutputStream;importjava.io.IOException;importjavax.imageio.ImageIO;importjavax.servlet.ServletException;importjavax.servlet.ServletOutputStream;importjavax.servlet.http.HttpServlet;importjavax.servlet.http.HttpServletRequest;importjavax.servlet.http.HttpServletR

3、esponse;importorg.apache.poi.hssf.usermodel.HSSFCell;importorg.apache.poi.hssf.usermodel.HSSFClientAnchor;importorg.apache.poi.hssf.usermodel.HSSFPatriarch;importorg.apache.poi.hssf.usermodel.HSSFRow;importorg.apache.poi.hssf.usermodel.HSSFSheet;importorg.apache.poi.hssf.usermodel.HSSFW

4、orkbook;importorg.apache.poi.poifs.filesystem.POIFSFileSystem;publicclassOutExcelServletextendsHttpServlet{privatestaticfinallongserialVersionUID=1L;publicvoiddoGet(HttpServletRequestrequest,HttpServletResponseresponse)throwsServletException,IOException{this.doPost(request,response);}pu

5、blicvoiddoPost(HttpServletRequestrequest,HttpServletResponseresponse)throwsServletException,IOException{Stringaccident_id=request.getParameter("accident_id");StringOnputimagePath=null;/***********************************************使用poi实现excel模版导出excel********************/try{POIFSFile

6、Systemfs=newPOIFSFileSystem(newFileInputStream("d:\设备异常分析报告.xls"));HSSFWorkbookwb=newHSSFWorkbook(fs);HSSFSheetsheet=wb.getSheet("设备异常分析报告");HSSFRowrow=sheet.getRow(2);HSSFCellcell=row.getCell((short)2);if(cell==null){cell=row.createCell((short)2);}cell.setCellType(HSSFCell.CELL_TYPE_S

7、TRING);cell.setCellValue("12321212");ByteArrayOutputStreambyteArrayOut=newByteArrayOutputStream();StringInputimagePath="d:\1012051443548604211337adf6.jpg";BufferedImagebufferImg=ImageIO.read(newFile(InputimagePath));ImageIO.write(bufferImg,"JPG",byteArrayOut);//设置图片大小，位置HSSFCl