JAVA的poi实现模版导出excel(带图片).doc
文本预览下载声明
下面是本人使用java的poi实现使用模板到处excel，内容包含图片，使用两种不同的方式实现其到处excel。但是使用jxl实现到处excel只能到处png格式。
package com.rxc.servlet;
import java.awt.image.BufferedImage;
import java.io.BufferedInputStream;
import java.io.BufferedOutputStream;
import java.io.ByteArrayOutputStream;
import java.io.File;
import java.io.FileInputStream;
import java.io.FileOutputStream;
import java.io.IOException;
import javax.imageio.ImageIO;
import javax.servlet.ServletException;
import javax.servlet.ServletOutputStream;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import org.apache.poi.hssf.usermodel.HSSFCell;
import org.apache.poi.hssf.usermodel.HSSFClientAnchor;
import org.apache.poi.hssf.usermodel.HSSFPatriarch;
import org.apache.poi.hssf.usermodel.HSSFRow;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.poifs.filesystem.POIFSFileSystem;
public class OutExcelServlet extends HttpServlet {
private static final long serialVersionUID = 1L;
public void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
this.doPost(request, response);
}
public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
String accident_id = request.getParameter(accident_id);
String OnputimagePath = null;
/***********************************************使用poi实现excel模版 导出excel********************/
try {
POIFSFileSystem fs = new POIFSFileSystem(new FileInputStream(d:\\设备异常分析报告.xls));
HSSFWorkbook wb = new HSSFWorkbook(fs);
HSSFSheet sheet = wb.getSheet(设备异常分析报告);
HSSFRow row = sheet.getRow(2);
HSSFCell cell = row.getCell((short) 2);
if (cell == null){
cell = row.createCell((short) 2);
}
cell.setCellType(HSSFCell.CELL_TYPE_STRING);
cell.setCellValue;
ByteArrayOutputStream byteArrayOut = new ByteArrayOutputStream()
显示全部