JAVA的poi实现模版导出excel

String accident_id = request.getParameter(\); String OnputimagePath = null;

/**************使用poi实现excel模版 导出excel********************/

try {

POIFSFileSystem fs = new POIFSFileSystem(new

FileInputStream(\设备异常分析报告.xls\)); HSSFWorkbook wb = new HSSFWorkbook(fs);

}

// 输出文件

OnputimagePath = \; FileOutputStream fileOut = new wb.write(fileOut); fileOut.close(); e.printStackTrace();

patri.createPicture(anchor ,wb.addPicture(byteArrayOut.toByteArra

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 String InputimagePath =

BufferedImage bufferImg = ImageIO.read(new ImageIO.write(bufferImg,\,byteArrayOut); //设置图片大小，位置

HSSFClientAnchor anchor = new

//创建

HSSFPatriarch patri = sheet.createDrawingPatriarch();

ByteArrayOutputStream();

\; File(InputimagePath));

HSSFClientAnchor(5,0,500,122,(short) 0, 5,(short)10,15);

y(), HSSFWorkbook.PICTURE_TYPE_PNG));

FileOutputStream(OnputimagePath);

} catch (Exception e) {

// 检查文件是否存在

File obj = new File(OnputimagePath); if (!obj.exists()) {

response.setContentType(\); response.getWriter().print(\指定文件不存在！\); return; }

// 读取文件名：用于设置客户端保存时指定默认文件名

int index = OnputimagePath.lastIndexOf(\); // 前提：传入的path

字符串以“\\”表示目录分隔符 String fileName = OnputimagePath.substring(index + 1);

// 写流文件到前端浏览器

ServletOutputStream out = response.getOutputStream(); response.setHeader(\, BufferedInputStream bis = null; BufferedOutputStream bos = null; try {

bis = new BufferedInputStream(new bos = new BufferedOutputStream(out); byte[] buff = new byte[2048]; int bytesRead;

while (-1 != (bytesRead = bis.read(buff, 0, buff.length))) { bos.write(buff, 0, bytesRead); }

} catch (IOException e) { throw e; } finally {

if (bis != null) bis.close(); if (bos != null) bos.close(); }

\ + fileName);

FileInputStream(OnputimagePath));

本文来源：https://www.bwwdw.com/article/r9ta.html