POI 生成word 文档 一般有两种方法:

① word模板 生成word 文档 ;

② 写代码直接生成 word 文档;

我这里演示的是第二种方法,即写代码生成 word文档,不多说废话,直接代码;

/**
* 镇街日报导出word
*/
@RequestMapping(params = "exportWordForTownDaily")
public void exportWordForTownDaily(HttpServletResponse response ,String selectDate){
if(StringUtils.isNullOrEmpty(selectDate)){
return;
}
SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
try{
sdf.parse(selectDate);
}catch (Exception e){
e.printStackTrace();
return;
}
CaseEntity entity = new CaseEntity();
entity.setRepotingTime_begin(selectDate + " 00:00:00");
entity.setRepotingTime_end(selectDate + " 23:59:59");
//获取镇街实际扣分
List<CaseEntity> caseEntityList = statisticsService.getTownActualScore(entity);
//获取各镇街情况
List<Map<String, Object>> townDaily = statisticsService.townDaily(entity);
//格式化查询日期(年月日)
SimpleDateFormat sdf2 = new SimpleDateFormat("yyyy年MM月dd日");
try {
selectDate = sdf2.format(sdf.parse(selectDate));
} catch (ParseException e) {
e.printStackTrace();
} //------------------------------------生成word文档------------------------------------------------
//创建document对象
XWPFDocumentUtil document = new XWPFDocumentUtil();
//创建标题段落
XWPFParagraph titleParag = document.createParagraph();
XWPFRun titleRun = titleParag.createRun();
titleRun.setText("镇街日报");
titleRun.setFontSize(20);
titleRun.setBold(true);//字体是否加粗
titleParag.setAlignment(ParagraphAlignment.LEFT);//段落居左 //换行
//XWPFParagraph brParagraph1 = document.createParagraph();
//XWPFRun brRun = brParagraph1.createRun();
//brRun.setText("\n");
//创建一个段落
XWPFParagraph p = document.createParagraph();
int rows = caseEntityList.size()+1;
int cols = 3;
//创建一个表格
XWPFTable table= document.createTable(rows, cols);
//表格属性
CTTblPr tablePr = table.getCTTbl().addNewTblPr();
//表格宽度
CTTblWidth width = tablePr.addNewTblW();
width.setW(BigInteger.valueOf(5000));
//设置表格宽度为非自动
width.setType(STTblWidth.DXA); //表头行
XWPFTableRow headRow = table.getRow(0);
XWPFTableCell headCell0 = headRow.getCell(0);
XWPFTableCell headCell1 = headRow.getCell(1);
XWPFTableCell headCell2 = headRow.getCell(2); p = headCell0.addParagraph();
XWPFRun headRun0 = p.createRun();
headRun0.setText("序号");
headRun0.setFontSize(12);
headRun0.setBold(true);//是否粗体
headCell0.setColor("DEDEDE");
//垂直居中
p.setVerticalAlignment(TextAlignment.CENTER);
//水平居中
p.setAlignment(ParagraphAlignment.CENTER); p = headCell1.addParagraph();
XWPFRun headRun1 = p.createRun();
headRun1.setText("镇街");
headRun1.setFontSize(12);
headRun1.setBold(true);
headCell1.setColor("DEDEDE");
//垂直居中
p.setVerticalAlignment(TextAlignment.CENTER);
//水平居中
p.setAlignment(ParagraphAlignment.CENTER); p = headCell2.addParagraph();
XWPFRun headRun2 = p.createRun();
headRun2.setFontSize(12);
headRun2.setText("总扣分");
headRun2.setBold(true);
headCell2.setColor("DEDEDE");
//垂直居中
p.setVerticalAlignment(TextAlignment.CENTER);
//水平居中
p.setAlignment(ParagraphAlignment.CENTER); //表主体行
for(int i=0 ;i<caseEntityList.size();i++){
CaseEntity caseEntity = caseEntityList.get(i);
XWPFTableRow contentRow = table.getRow(i+1);
XWPFTableCell cell0 = contentRow.getCell(0);
XWPFTableCell cell1 = contentRow.getCell(1);
XWPFTableCell cell2 = contentRow.getCell(2); p = cell0.addParagraph();
XWPFRun pRun0=p.createRun();
pRun0.setText(i+1+"");
//垂直居中
cell0.setVerticalAlignment(XWPFTableCell.XWPFVertAlign.CENTER);
//水平居中
p.setAlignment(ParagraphAlignment.CENTER); p = cell1.addParagraph();
XWPFRun pRun1=p.createRun();
pRun1.setText(caseEntity.getTownName());
//垂直居中
cell1.setVerticalAlignment(XWPFTableCell.XWPFVertAlign.CENTER);
//水平居中
p.setAlignment(ParagraphAlignment.CENTER); p = cell2.addParagraph();
XWPFRun pRun2=p.createRun();
pRun2.setText(caseEntity.getTownActualScore().toString());
//垂直居中
cell2.setVerticalAlignment(XWPFTableCell.XWPFVertAlign.CENTER);
//水平居中
p.setAlignment(ParagraphAlignment.CENTER);
}
//-----------------------------各镇街情况------------------------------
//创建标题段落
XWPFParagraph title1 = document.createParagraph();
XWPFRun title1Run = title1.createRun();
title1Run.setText("\r各镇街比较严重的问题");
title1Run.setFontSize(20);
title1Run.setBold(true); try {
for(Map<String,Object> townMap:townDaily){
CaseEntity townCase = (CaseEntity)townMap.get("townCase");
XWPFParagraph xwpfParagraph = document.createParagraph();
XWPFRun xwpfRun_town = xwpfParagraph.createRun();
XWPFRun xwpfRun = xwpfParagraph.createRun();
xwpfRun_town.setText(townCase.getTownName());
xwpfRun_town.setFontSize(14);
xwpfRun_town.setBold(true);
xwpfRun_town.setColor("00cc44");
xwpfRun.setText(","+selectDate+"当天扣分较多的问题有:");
xwpfRun.setFontSize(14);
xwpfRun.setBold(true);
List<Map<String,Object>> caseInfoList = (List<Map<String,Object>>)townMap.get("caseInfoList");
Integer no = 0;
for(Map<String,Object> map:caseInfoList){
CaseEntity caseInfo = (CaseEntity)map.get("caseInfo");
XWPFParagraph xwpfParagraph1 = document.createParagraph();
XWPFRun xwpfRun1 =xwpfParagraph1.createRun();
XWPFRun xwpfRun2 = xwpfParagraph1.createRun();
XWPFRun xwpfRun3 = xwpfParagraph1.createRun();
xwpfRun1.setText((++no)+"、");
xwpfRun2.setText(caseInfo.getProblemStreet());
xwpfRun3.setText(","+caseInfo.getProblemNotes());
xwpfRun1.setFontSize(14);
xwpfRun2.setFontSize(14);
xwpfRun2.setColor("4747d1");
xwpfRun3.setFontSize(14);
List<AttachmentEntity> fileList = (List<AttachmentEntity>)map.get("fileList");
for(AttachmentEntity at:fileList){
String mainPath = at.getMainPath();
String path = at.getPath();
if(!StringUtils.isNullOrEmpty(mainPath) && !StringUtils.isNullOrEmpty(path)){
//第一张图片
document.addPictureData(new FileInputStream(mainPath+path), XWPFDocumentUtil.PICTURE_TYPE_JPEG);
document.createPicture(document.getAllPictures().size() - 1, 300, 400, document.createParagraph());
}
}
}
} OutputStream output = response.getOutputStream();
//生成word文件的文件名
String fileName= new String(("镇街日报.docx").getBytes("UTF-8"),"iso-8859-1");
response.setHeader("Content-disposition", "attachment; filename=" + fileName);
//把word文档写到输出流
document.write(output);
} catch (InvalidFormatException e) {
e.printStackTrace();
} catch (FileNotFoundException e) {
e.printStackTrace();
} catch (IOException e) {
e.printStackTrace();
}
//--------------------------------word文档结束-----------------------------------------------------
}

  

   效果如下图所示:

 

最新文章

  1. Boot from Volume - 每天5分钟玩转 OpenStack(61)
  2. html基础01
  3. JavaScript学习笔记——流程控制
  4. android四大组件之ContentProvider(二)
  5. hibernate执行sql的三种方式
  6. Android假退出不是流氓行为
  7. Orchard 源码探索(Log)
  8. 剖析Asp.Net Web API路由系统---WebHost部署方式
  9. iOS-工程和工作空间、静态库和框架之间的关系
  10. G++与C++的区别
  11. Java 过一下基础
  12. linux系统,服务器与服务器拷贝文件
  13. 学习CSS布局 - dispaly属性
  14. POJ3280--Cheapest Palindrome(动态规划)
  15. 排序算法(8)--Merge Sorting--归并排序--Merge sort--归并排序
  16. spark-submit的参数名称解析
  17. 【转】 编写C#调用的C++DLL
  18. 【CF865C】Gotta Go Fast 二分+期望DP
  19. ROS知识(2)----理解ROS系统结构
  20. 静默安装oracle后,启动oem报错,解决方法!

热门文章

  1. windows如何利用计划任务自动关机?
  2. 002-python函数、高级特性
  3. JAVA的List接口的remove重载方法调用原理
  4. 设计模式----创建型模式之工厂模式(FactoryPattern)
  5. Tomcat源码分析二:先看看Tomcat的整体架构
  6. orm加强版
  7. Oracle 编写存储过程并设置定时执行
  8. Vue-cli父子组件之间传参
  9. 代码审计之create_function()函数
  10. SpringBootSecurity学习(26)前后端分离版之github单点登录