java excel 模板 替换_替换WORD/EXCEL模板文档中的内容并下载java

/** 案件模板下载

*

**/

public static voidgenerateFile(HttpServletRequest request,HttpServletResponse response){Map map =FastMap.newInstance();String calendarYear= request.getParameter("calendarYear");map.put("201X", calendarYear); //需要替换的内容 key为被替换者String engFileTemplateName= "C:\Users\NUH-25\Desktop\ENG20160131.xlsx"; //被替换模板路径

String fileType= engFileTemplateName.substring(engFileTemplateName.lastIndexOf(".") + 1, engFileTemplateName.length());if("xls".equals(fileType)||"xlsx".equals(fileType))

readwriteExcel(request,response,map,engFileTemplateName);else if("doc".equals(fileType)||"docx".equals(fileType))

readwriteWord(request,response,map,engFileTemplateName);

}public static void readwriteWord(HttpServletRequest request,HttpServletResponse response,Mapmap,String engFileTemplateName){FileInputStream in;

HWPFDocument hdt= null;try{

in= new FileInputStream(newFile(engFileTemplateName));

hdt= newHWPFDocument(in);

}catch(Exception e1) {

e1.printStackTrace();

}

Fields fields=hdt.getFields();

Iterator it =fields.getFields(FieldsDocumentPart.MAIN).iterator();/*while(it.hasNext()){

System.out.println(it.next().getType());

}*/

//替换读取到的word模板内容的指定字段

Range range =hdt.getRange();for (Map.Entryentry:map.entrySet()) {

range.replaceText(entry.getKey(),entry.getValue());

}//输出word内容文件流，提供下载

response.reset();

response.setContentType("application/x-msdownload");

response.setCharacterEncoding("gbk");

String fileType= engFileTemplateName.substring(engFileTemplateName.lastIndexOf(".") + 1, engFileTemplateName.length());

String fileName= ""+System.currentTimeMillis()+"."+fileType;

response.addHeader("Content-Disposition", "attachment; filename="+fileName);

ByteArrayOutputStream ostream= newByteArrayOutputStream();

OutputStream servletOS= null;try{

servletOS=response.getOutputStream();

hdt.write(ostream);

servletOS.write(ostream.toByteArray());

servletOS.flush();

servletOS.close();

}catch(Exception e) {

e.printStackTrace();

}

}/***

* 案件附件模板excel修改下载

*

*@paramrequest

*

*@paramresponse

*

*@throwsIOException*/

public static void readwriteExcel(HttpServletRequest request,HttpServletResponse response,Mapmap,String engFileTemplateName){try{String fileType= engFileTemplateName.substring(engFileTemplateName.lastIndexOf(".") + 1, engFileTemplateName.length());

FileInputStream in= new FileInputStream(newFile(engFileTemplateName));;

InputStream inputStream= newBufferedInputStream(in);

Workbook workbook= null;if (fileType.equals("xls")) {

workbook= newHSSFWorkbook(inputStream);

}else if (fileType.equals("xlsx")) {//workbook = new XSSFWorkbook(inputStream);

workbook =WorkbookFactory.create(inputStream);

}else{

System.out.println("您输入的excel格式不正确");

}

Iterator iterator =workbook.sheetIterator();while(iterator.hasNext()){

Sheet sheet=iterator.next();for(Row row:sheet){for(Cell cell:row){if(1==cell.getCellType()){

String cellString=cell.getStringCellValue();for (Map.Entryentry:map.entrySet()) {if(cellString.contains(entry.getKey())){

String newString=cellString.replace(entry.getKey(), entry.getValue());

cell.setCellValue(newString);

}

}

}

}

}

}//输出excel内容文件流，提供下载

response.reset();

response.setContentType("application/x-msdownload");

response.setCharacterEncoding("gbk");

String fileName= ""+System.currentTimeMillis()+"."+fileType;

response.addHeader("Content-Disposition", "attachment; filename="+fileName);

ByteArrayOutputStream ostream= newByteArrayOutputStream();

OutputStream servletOS= null;try{

servletOS=response.getOutputStream();

workbook.write(ostream);

servletOS.write(ostream.toByteArray());

servletOS.flush();

servletOS.close();

}catch(Exception e) {

e.printStackTrace();

}

}catch(Exception e)

{

e.printStackTrace();

Debug.logError(e, module);

}

}