poi导出word表格详解 超详细了

转：非常感谢原作者

poi导出word表格详解

2018年07月20日 10:41:33 Z丶royAl 阅读数：36138

 

一、效果如下

二、js代码

function export_word(){ //导出word
    var url = "czzsca/exportWord.do";
    this.export(url);
}
function export(url){
    var currentyear = $("#mainYear").val() * 1;
    var key_columns = ['xh',"d_name","d_unit","d_number","d_estimate","d_lastyear","jnjh","d_remarks","d_depart","d_executeunit"];
    var value_columns = ['序号','项目名称','单位','数量','总概算','至'+(currentyear-1)+'年完成',currentyear+'年计划','附注','责任部门','计划执行单位'];
    window.location.href= url+"?key_columns="+key_columns+"&value_columns="+value_columns+"&title="+currentyear+"年 更新改造计划 正式计划草案";
}

 

三、controller代码（controller代码比较长，主要是格式化每一行的数据，主要是往工具类里传List<List<String>>参数，泛型的List<String>是每一行，String是每一列）

    //导出word
    @RequestMapping("/exportWord.do")
    @ResponseBody
    public ReturnMsg exportWord(String[] key_columns,String[] value_columns,String title,HttpServletResponse response){
        ReturnMsg rm = new ReturnMsg();
        try {
            response.setCharacterEncoding("UTF-8");
            response.setContentType("application/msexcle");   
            response.setHeader("content-disposition", "attachment;filename="+new String("正式计划草案".getBytes("gb2312"),"ISO8859-1")+".doc");
            List<List<String>> content = new ArrayList<List<String>>();
            List<List<String>> head = new ArrayList<List<String>>();
            String jnjhzh = new BigDecimal(this.map.get("jnjhzh")==null||"".equals(this.map.get("jnjhzh")+"")?"0":this.map.get("jnjhzh")+"").setScale(1, RoundingMode.UP)+"";
            String trimpro = new BigDecimal(this.map.get("tzjh")==null||"".equals(this.map.get("tzjh")+"")?"0":this.map.get("tzjh")+"").setScale(1, RoundingMode.UP)+"";
            String temp = new BigDecimal(trimpro).subtract(new BigDecimal(jnjhzh))+"";
            if("0".equals(temp)) {
                temp = "";
            }
            head = ExportUtil.getCzzscaList(jnjhzh, trimpro, temp);
            Map dounit = new HashMap();
            dounit.put("dwlx", 0);
            dounit.put("user_type", 1);
            List<Map> d_executeunit = unitDao.selectByPrimaryKey(dounit);
            Map zrbm = new HashMap();
            zrbm.put("dwlx", 1);
            zrbm.put("user_type", 1);
            List<Map> d_zrbm = unitDao.selectByPrimaryKey(zrbm);
            List<Map> zmtype = nd_caController.findProType("2-3-4");
            for (Map map: this.list) {
                List<String> row = new ArrayList<String>();
                for (int i = 0; i < key_columns.length; i++) {
                    System.out.print(map.get(key_columns[i])+",");
                    Object Otzjh = map.get("tzjh")!=null?map.get("tzjh"):0;
                    Object Ojnjh = map.get("jnjh")!=null?map.get("jnjh"):0;
                    BigDecimal tzjh = null;
                    BigDecimal jnjh = null;
                    if ("tzjh".equals(key_columns[i])||"jnjh".equals(key_columns[i])||"d_lnorde".equals(key_columns[i])) {
                        if(Otzjh instanceof BigDecimal) {
                            tzjh = (BigDecimal)Otzjh;
                        }else {
                            tzjh = new BigDecimal(Otzjh+"");
                        }
                        if(Ojnjh instanceof BigDecimal) {
                            jnjh = (BigDecimal)Ojnjh;
                        }else {
                            jnjh = new BigDecimal(Ojnjh+"");
                        }
                        
                    }
                    if ("d_lnorde".equals(key_columns[i])) {
                        if(map.get("flag")!=null&&"2".equals((map.get("flag")+""))) {
                            row.add("");
                        }else {
                            row.add(tzjh.subtract(jnjh).setScale(1, RoundingMode.UP)+""); //不为整数则四舍五入
                        }
                    }else if ("xh".equals(key_columns[i])&&map.get("xh")!=null) {
                        if(map.get("xh").toString().indexOf("、")>-1) {
                            row.add(map.get("xh").toString().replace("、", "").trim());
                        }else {
                            row.add(map.get("xh")+""); //不为整数则四舍五入
                        }
                    }else if("tzjh".equals(key_columns[i])&&map.get("tzjh")!=null) { 
                        if(ExportUtil.isNumeric(tzjh+"")) { //判断相减是否为整数
                            row.add(tzjh+"");
                        }else {
                            String stzjh = tzjh.setScale(1, RoundingMode.UP)+"";
                            row.add("0".equals(stzjh.charAt(stzjh.indexOf(".")+1)+"")?stzjh.replace(".0", ""):stzjh);//不为整数则四舍五入
                        }
                    }else if("d_estimate".equals(key_columns[i])&&map.get("d_estimate")!=null) { 
                        if("0".equals(map.get("d_estimate")+"")) {
                            row.add("");
                        }else {
                            row.add(map.get("d_estimate")+"");
                        }
                    }else if("d_number".equals(key_columns[i])&&map.get("d_number")!=null) { 
                        if("0".equals(map.get("d_number")+"")) {
                            row.add("");
                        }else {
                            row.add(map.get("d_number")+"");
                        }
                    }else if("jnjh".equals(key_columns[i])&&map.get("jnjh")!=null) { 
                        if(ExportUtil.isNumeric(jnjh+"")) { //判断相减是否为整数
                            row.add(jnjh+"");
                        }else {
                            String sjnjh = jnjh.setScale(1, RoundingMode.UP)+"";
                            row.add("0".equals(sjnjh.charAt(sjnjh.indexOf(".")+1)+"")?sjnjh.replace(".0", ""):sjnjh); //不为整数则四舍五入
                        }
                    }else if("d_pro_type".equals(key_columns[i])&&map.get("d_pro_type")!=null) { 
                        for (Map m : zmtype) {
                            if((map.get("d_pro_type")+"").equals(m.get("TYPE_ID")+"")){
                                row.add(m.get("NUM")+"");
                                break;
                            }
                        }
                    }else if("d_depart".equals(key_columns[i])&&map.get("d_depart")!=null) { 
                        String d_depart = map.get("d_depart")+"";
                        String depart = "";
                        for (Map m : d_zrbm) {
                            if((d_depart).indexOf(",")>-1) {
                                for (String string : d_depart.split(",")) {
                                    if((string).equals(m.get("ID")+"")) {
                                        depart += ","+m.get("UNITNAME")+"";
                                        break;
                                    }
                                }
                            }else {
                                if((d_depart).equals(m.get("ID")+"")) {
                                    depart = ","+m.get("UNITNAME")+"";
                                    break;
                                }
                            }
                        }
                        if (StringUtils.isNotBlank(depart)) {
                            depart = depart.substring(1, depart.length()).replace(",", "
 ");
                            row.add(depart);
                        }else {
                            row.add("");
                        }
                    }else if("d_executeunit".equals(key_columns[i])&&map.get("d_executeunit")!=null) { 
                        boolean flag;
                        for (Map m : d_executeunit) {
                            flag = false;
                            String executeunit = map.get("d_executeunit")+"";
                            if((executeunit).indexOf(",")>-1) {
                                for (String string : executeunit.split(",")) {
                                    if((string).equals(m.get("ID")+"")) {
                                        row.add((m.get("UNITNAME")+"").trim());
                                        flag = true;
                                        break;
                                    }
                                }
                                if (flag) {
                                    break;
                                }
                                
                            }else {
                                if((executeunit).equals(m.get("ID")+"")) {
                                    row.add((m.get("UNITNAME")+"").trim());
                                    break;
                                }
                            }
                        }
                    }else {
                        if(map.get(key_columns[i])==null) {
                            row.add("");
                        }else {
                            row.add((map.get(key_columns[i])+"").trim());
                        }
                    }
                }
                content.add(row);
            }
            head.addAll(content);
            int[] colWidths = new int[] { 600, 3000, 500, 500, 800, 800 ,800,3000,800,1500};  
            XWPFDocument document = ExportUtil.exportWord(title,value_columns, head,colWidths,1,7);
            OutputStream out =  response.getOutputStream();  
            document.write(out);
            out.close();
            rm.setCode("1");
            rm.setMsg("导出成功");
        } catch (Exception e) {
            e.printStackTrace();
            rm.setCode("0");
            rm.setMsg("导出失败，请刷新重试。");
        }
        return rm;
    }

 

四、工具类代码

    /**
     * 
     * @Date 2018年7月19日 上午11:19:04
     * @Description 导出word 
     * @Fcunction exportWord
     * @param title
     * @param value_columns
     * @param list
     * @return XWPFDocument
     *
     */
    public static XWPFDocument exportWord(String title,String[] value_columns, List<List<String>> list,int[] colWidths,int one,int two) {
        XWPFDocument doc= new XWPFDocument();
        
        CTDocument1 document = doc.getDocument(); 
        CTBody body = document.getBody(); 
        if(!body.isSetSectPr()){ 
             body.addNewSectPr(); 
        } 
        CTSectPr section = body.getSectPr(); 
 
        if(!section.isSetPgSz()){ 
            section.addNewPgSz(); 
        } 
        CTPageSz pageSize = section.getPgSz(); 
        pageSize.setW(BigInteger.valueOf(15840));
        pageSize.setH(BigInteger.valueOf(12240));
        pageSize.setOrient(STPageOrientation.LANDSCAPE);
        
        //添加标题
        XWPFParagraph titleParagraph = doc.createParagraph();
        
        //设置段落居中
        titleParagraph.setAlignment(ParagraphAlignment.CENTER);
    
        XWPFRun titleParagraphRun = titleParagraph.createRun();
        titleParagraphRun.setText(title);
        titleParagraphRun.setColor("000000");
        titleParagraphRun.setFontSize(20);
    
        //表格
        XWPFTable ComTable = doc.createTable();
        
        //设置指定宽度
        CTTbl ttbl = ComTable.getCTTbl(); 
        CTTblGrid tblGrid = ttbl.addNewTblGrid();
        for (int i : colWidths) {
            CTTblGridCol gridCol = tblGrid.addNewGridCol();  
            gridCol.setW(new BigInteger(i+""));  
        }
        
        //表头
        XWPFTableRow rowHead = ComTable.getRow(0);
        XWPFParagraph cellParagraph = rowHead.getCell(0).getParagraphs().get(0);
        cellParagraph.setAlignment(ParagraphAlignment.CENTER); //设置表头单元格居中
        XWPFRun cellParagraphRun  = cellParagraph.createRun();
        cellParagraphRun.setFontSize(10); //设置表头单元格字号
        cellParagraphRun.setBold(true); //设置表头单元格加粗
        cellParagraphRun.setText(value_columns[0]);
        for (int i = 1; i < value_columns.length; i++) {
            if(value_columns[i].indexOf("增减")>-1) {
                cellParagraph = rowHead.addNewTableCell().getParagraphs().get(0);
                cellParagraph.setAlignment(ParagraphAlignment.CENTER); //设置表头单元格居中
                cellParagraphRun  = cellParagraph.createRun();
                cellParagraphRun.setFontSize(10); //设置表头单元格居中
                cellParagraphRun.setBold(true);
                cellParagraphRun.setText("增减(+ / -)");
            }else {
                cellParagraph = rowHead.addNewTableCell().getParagraphs().get(0);
                cellParagraph.setAlignment(ParagraphAlignment.CENTER); //设置表头单元格居中
                cellParagraphRun  = cellParagraph.createRun();
                cellParagraphRun.setFontSize(10); //设置表头单元格居中
                cellParagraphRun.setBold(true); //设置表头单元格加粗
                cellParagraphRun.setText(value_columns[i]);
            }
        }
        int rows = list.size();
        //表格内容
        for (int i = 0; i < rows; i++) {
            XWPFTableRow rowsContent = ComTable.createRow();
            for (int j = 0; j < list.get(i).size(); j++) {
                XWPFParagraph cellParagraphC = rowsContent.getCell(j).getParagraphs().get(0);
                if(j!=one&&j!=two) {
                    cellParagraphC.setAlignment(ParagraphAlignment.CENTER); //设置表格内容居中
                }
                XWPFRun cellParagraphRunC  = cellParagraphC.createRun();
                cellParagraphRunC.setFontSize(10); //设置表格内容字号
                cellParagraphRunC.setText(list.get(i).get(j)+""); //单元格段落加载内容
            }
        }
        if(rows==0) {
            for (int i = 0; i < value_columns.length; i++) {
                XWPFTableCell cell = ComTable.getRow(0).getCell(i);
                cell.setVerticalAlignment(XWPFTableCell.XWPFVertAlign.CENTER); //垂直居中
            }
        }else {
            //设置居中
            for (int i = 0; i <= rows; i++) {
                for (int j = 0; j < list.get(0).size(); j++) {
                    XWPFTableCell cell = ComTable.getRow(i).getCell(j);
                    cell.setVerticalAlignment(XWPFTableCell.XWPFVertAlign.CENTER); //垂直居中
                }
            }
        }
        return doc;
    }
 
    /**
     * 
     * @Date 2018年7月19日 上午11:19:21
     * @Description 判断是否是整数 
     * @Fcunction isNumeric
     * @param str
     * @return boolean
     *
     */
    public static boolean isNumeric(String str) {
        if(str.indexOf(".")>0) {
            return false;
        }
        return true;
    }
    
    /**
     * 
     * @Date 2018年7月19日 上午11:44:48
     * @Description 正式计划草案获取前两行 
     * @Fcunction getCzzscaList
     * @param jnjhzh
     * @param trimpro
     * @param temp
     * @return List<List<String>>
     *
     */
    public static List<List<String>> getCzzscaList(String jnjhzh,String trimpro,String temp) {
        List<List<String>> list = new ArrayList<List<String>>();
        List<String> l1 = new ArrayList<String>(); //固定第一行
        l1.add(""); 
        l1.add("年度总计"); 
        l1.add(""); 
        l1.add(""); 
        l1.add(""); 
        l1.add(""); 
        l1.add(jnjhzh); 
        l1.add(""); 
        l1.add(""); 
        l1.add(""); 
        list.add(l1);
        List<String> l2 = new ArrayList<String>(); //固定第二行
        l2.add("");
        l2.add("搜索总计");
        l2.add("");
        l2.add("");
        l2.add("");
        l2.add("");
        l2.add("");
//        l2.add(trimpro+"
100%");
        l2.add("");
        l2.add("");
        l2.add("");
        list.add(l2);
        return list;
    }

 

五、详解：

1.设置纸张大小

（1）创建完XWPFDocument后，默认为A4纸张，如需调整纸张大小，这里我是要用A3大小使用如下代码

XWPFDocument doc= new XWPFDocument();
CTDocument1 document = doc.getDocument(); 
CTBody body = document.getBody(); 
if(!body.isSetSectPr()){ 
    body.addNewSectPr(); 
} 
CTSectPr section = body.getSectPr(); 
 
if(!section.isSetPgSz()){ 
    section.addNewPgSz(); 
} 
CTPageSz pageSize = section.getPgSz(); 
pageSize.setW(BigInteger.valueOf(15840));
pageSize.setH(BigInteger.valueOf(12240));
pageSize.setOrient(STPageOrientation.LANDSCAPE);

 

（2）默认A4纸张大小的话只用XWPFDocument

 

XWPFDocument doc= new XWPFDocument();

（3）使用CTPageSz类需要导入ooxml-schemas的jar包（所有需要的jar包maven依赖在底部）

 

2.单元格列宽度

 

（1）每一列宽度相等自适应，不需单独设置每一列宽度的话使用如下代码

//表格
XWPFTable ComTable = doc.createTable();
//表格自适应宽度
CTTblWidth comTableWidth = ComTable.getCTTbl().addNewTblPr().addNewTblW();
comTableWidth.setType(STTblWidth.DXA);
comTableWidth.setW(BigInteger.valueOf(9072));

（2）单独设置每列宽度

//表格
XWPFTable ComTable = doc.createTable();        
//设置指定宽度
CTTbl ttbl = ComTable.getCTTbl(); 
CTTblGrid tblGrid = ttbl.addNewTblGrid();
int[] colWidths = new int[] { 600, 3000, 500, 500, 800, 800 ,800,3000,800,1500};  
for (int i : colWidths) {
    CTTblGridCol gridCol = tblGrid.addNewGridCol();  
    gridCol.setW(new BigInteger(i+""));  
}

（3）使用CTTblGrid类需要导入poi-ooxml-schemas的jar包（所有需要的jar包maven依赖在底部）

3.单元格内字体样式

（1）不需要设置单元格字体

for (int i = 0; i < rows; i++) {
    XWPFTableRow rowsContent = ComTable.createRow();
    for (int j = 0; j < list.get(i).size(); j++) {    
        rowsContent.getCell(j).setText(list.get(i).get(j)+""); //用单元格加载内容
    }
}

（2）设置单元格内字体字号、是否加粗

for (int i = 0; i < rows; i++) {
    XWPFTableRow rowsContent = ComTable.createRow();
    for (int j = 0; j < list.get(i).size(); j++) {
        XWPFParagraph cellParagraphC = rowsContent.getCell(j).getParagraphs().get(0);
        if(j!=1&&j!=7) {
            cellParagraphC.setAlignment(ParagraphAlignment.CENTER); //设置表格内容居中
        }
        XWPFRun cellParagraphRunC  = cellParagraphC.createRun();
        cellParagraphRunC.setFontSize(10); //设置表格内容字号
        cellParagraphRun.setBold(true); //设置表头单元格加粗
        cellParagraphRunC.setText(list.get(i).get(j)+""); //单元格段落加载内容
    }
}

4.单元格居中（水平居中、垂直居中）

（1）使用单元格加载内容

for (int i = 0; i < value_columns.length; i++) {
    XWPFTableCell cell = ComTable.getRow(0).getCell(i);
    cell.setVerticalAlignment(XWPFTableCell.XWPFVertAlign.CENTER); //垂直居中
    CTTc cttc = cell.getCTTc();
    CTP ctp = cttc.getPList().get(0);
    CTPPr ctppr = ctp.getPPr();
    if (ctppr == null) {
        ctppr = ctp.addNewPPr();
    }
    CTJc ctjc = ctppr.getJc();
    if (ctjc == null) {
        ctjc = ctppr.addNewJc();
    }
    ctjc.setVal(STJc.CENTER); //水平居中
}

（2）使用单元格的段落加载内容，只用调用垂直居中的方法

for (int i = 0; i < value_columns.length; i++) {
    XWPFTableCell cell = ComTable.getRow(0).getCell(i);
    cell.setVerticalAlignment(XWPFTableCell.XWPFVertAlign.CENTER); //垂直居中
}

水平居中在3-(2)里调用了段落的方法居中过了

cellParagraphC.setAlignment(ParagraphAlignment.CENTER);

5.单元格合并

（1）跨列合并单元格

public static void mergeCellsHorizontal(XWPFTable table, int row, int fromCell, int toCell) {
        for (int cellIndex = fromCell; cellIndex <= toCell; cellIndex++) {
            XWPFTableCell cell = table.getRow(row).getCell(cellIndex);
            if ( cellIndex == fromCell ) {                
                cell.getCTTc().addNewTcPr().addNewHMerge().setVal(STMerge.RESTART);
            } else {
                cell.getCTTc().addNewTcPr().addNewHMerge().setVal(STMerge.CONTINUE);
            }
        }
    }

（2）跨行合并单元格

public static void mergeCellsVertically(XWPFTable table, int col, int fromRow, int toRow) {
        for (int rowIndex = fromRow; rowIndex <= toRow; rowIndex++) {
            XWPFTableCell cell = table.getRow(rowIndex).getCell(col);
            if ( rowIndex == fromRow ) {
                cell.getCTTc().addNewTcPr().addNewVMerge().setVal(STMerge.RESTART);
            } else {
                cell.getCTTc().addNewTcPr().addNewVMerge().setVal(STMerge.CONTINUE);
            }
        }
    }

六、使用到的Maven依赖

<dependency>
    <groupId>org.apache.xmlbeans</groupId>
    <artifactId>xmlbeans</artifactId>
    <version>2.6.0</version>
</dependency>
<dependency>
    <groupId>org.apache.poi</groupId>
    <artifactId>poi-ooxml</artifactId>
    <version>3.9</version>
</dependency>
<dependency>
    <groupId>org.apache.poi</groupId>
    <artifactId>ooxml-schemas</artifactId>
    <version>1.1</version>
</dependency>
<dependency>
    <groupId>org.apache.poi</groupId>
    <artifactId>poi-ooxml-schemas</artifactId>
    <version>3.16</version>
</dependency>

 

 

poi导出word表格详解

2018年07月20日 10:41:33 Z丶royAl 阅读数：36138

 

一、效果如下

二、js代码

1.  
   function export_word(){ //导出word
2.  
   var url = "czzsca/exportWord.do";
3.  
   this.export(url);
4.  
   }
5.  
   function export(url){
6.  
   var currentyear = $("#mainYear").val() * 1;
7.  
   var key_columns = ['xh',"d_name","d_unit","d_number","d_estimate","d_lastyear","jnjh","d_remarks","d_depart","d_executeunit"];
8.  
   var value_columns = ['序号','项目名称','单位','数量','总概算','至'+(currentyear-1)+'年完成',currentyear+'年计划','附注','责任部门','计划执行单位'];
9.  
   window.location.href= url+"?key_columns="+key_columns+"&value_columns="+value_columns+"&title="+currentyear+"年 更新改造计划 正式计划草案";
10.  
    }

三、controller代码（controller代码比较长，主要是格式化每一行的数据，主要是往工具类里传List<List<String>>参数，泛型的List<String>是每一行，String是每一列）

1.  
   //导出word
2.  
   @RequestMapping("/exportWord.do")
3.  
   @ResponseBody
4.  
   public ReturnMsg exportWord(String[] key_columns,String[] value_columns,String title,HttpServletResponse response){
5.  
   ReturnMsg rm = new ReturnMsg();
6.  
   try {
7.  
   response.setCharacterEncoding("UTF-8");
8.  
   response.setContentType("application/msexcle");
9.  
   response.setHeader("content-disposition", "attachment;filename="+new String("正式计划草案".getBytes("gb2312"),"ISO8859-1")+".doc");
10.  
    List<List<String>> content = new ArrayList<List<String>>();
11.  
    List<List<String>> head = new ArrayList<List<String>>();
12.  
    String jnjhzh = new BigDecimal(this.map.get("jnjhzh")==null||"".equals(this.map.get("jnjhzh")+"")?"0":this.map.get("jnjhzh")+"").setScale(1, RoundingMode.UP)+"";
13.  
    String trimpro = new BigDecimal(this.map.get("tzjh")==null||"".equals(this.map.get("tzjh")+"")?"0":this.map.get("tzjh")+"").setScale(1, RoundingMode.UP)+"";
14.  
    String temp = new BigDecimal(trimpro).subtract(new BigDecimal(jnjhzh))+"";
15.  
    if("0".equals(temp)) {
16.  
    temp = "";
17.  
    }
18.  
    head = ExportUtil.getCzzscaList(jnjhzh, trimpro, temp);
19.  
    Map dounit = new HashMap();
20.  
    dounit.put("dwlx", 0);
21.  
    dounit.put("user_type", 1);
22.  
    List<Map> d_executeunit = unitDao.selectByPrimaryKey(dounit);
23.  
    Map zrbm = new HashMap();
24.  
    zrbm.put("dwlx", 1);
25.  
    zrbm.put("user_type", 1);
26.  
    List<Map> d_zrbm = unitDao.selectByPrimaryKey(zrbm);
27.  
    List<Map> zmtype = nd_caController.findProType("2-3-4");
28.  
    for (Map map: this.list) {
29.  
    List<String> row = new ArrayList<String>();
30.  
    for (int i = 0; i < key_columns.length; i++) {
31.  
    System.out.print(map.get(key_columns[i])+",");
32.  
    Object Otzjh = map.get("tzjh")!=null?map.get("tzjh"):0;
33.  
    Object Ojnjh = map.get("jnjh")!=null?map.get("jnjh"):0;
34.  
    BigDecimal tzjh = null;
35.  
    BigDecimal jnjh = null;
36.  
    if ("tzjh".equals(key_columns[i])||"jnjh".equals(key_columns[i])||"d_lnorde".equals(key_columns[i])) {
37.  
    if(Otzjh instanceof BigDecimal) {
38.  
    tzjh = (BigDecimal)Otzjh;
39.  
    }else {
40.  
    tzjh = new BigDecimal(Otzjh+"");
41.  
    }
42.  
    if(Ojnjh instanceof BigDecimal) {
43.  
    jnjh = (BigDecimal)Ojnjh;
44.  
    }else {
45.  
    jnjh = new BigDecimal(Ojnjh+"");
46.  
    }
47.  
     
48.  
    }
49.  
    if ("d_lnorde".equals(key_columns[i])) {
50.  
    if(map.get("flag")!=null&&"2".equals((map.get("flag")+""))) {
51.  
    row.add("");
52.  
    }else {
53.  
    row.add(tzjh.subtract(jnjh).setScale(1, RoundingMode.UP)+""); //不为整数则四舍五入
54.  
    }
55.  
    }else if ("xh".equals(key_columns[i])&&map.get("xh")!=null) {
56.  
    if(map.get("xh").toString().indexOf("、")>-1) {
57.  
    row.add(map.get("xh").toString().replace("、", "").trim());
58.  
    }else {
59.  
    row.add(map.get("xh")+""); //不为整数则四舍五入
60.  
    }
61.  
    }else if("tzjh".equals(key_columns[i])&&map.get("tzjh")!=null) {
62.  
    if(ExportUtil.isNumeric(tzjh+"")) { //判断相减是否为整数
63.  
    row.add(tzjh+"");
64.  
    }else {
65.  
    String stzjh = tzjh.setScale(1, RoundingMode.UP)+"";
66.  
    row.add("0".equals(stzjh.charAt(stzjh.indexOf(".")+1)+"")?stzjh.replace(".0", ""):stzjh);//不为整数则四舍五入
67.  
    }
68.  
    }else if("d_estimate".equals(key_columns[i])&&map.get("d_estimate")!=null) {
69.  
    if("0".equals(map.get("d_estimate")+"")) {
70.  
    row.add("");
71.  
    }else {
72.  
    row.add(map.get("d_estimate")+"");
73.  
    }
74.  
    }else if("d_number".equals(key_columns[i])&&map.get("d_number")!=null) {
75.  
    if("0".equals(map.get("d_number")+"")) {
76.  
    row.add("");
77.  
    }else {
78.  
    row.add(map.get("d_number")+"");
79.  
    }
80.  
    }else if("jnjh".equals(key_columns[i])&&map.get("jnjh")!=null) {
81.  
    if(ExportUtil.isNumeric(jnjh+"")) { //判断相减是否为整数
82.  
    row.add(jnjh+"");
83.  
    }else {
84.  
    String sjnjh = jnjh.setScale(1, RoundingMode.UP)+"";
85.  
    row.add("0".equals(sjnjh.charAt(sjnjh.indexOf(".")+1)+"")?sjnjh.replace(".0", ""):sjnjh); //不为整数则四舍五入
86.  
    }
87.  
    }else if("d_pro_type".equals(key_columns[i])&&map.get("d_pro_type")!=null) {
88.  
    for (Map m : zmtype) {
89.  
    if((map.get("d_pro_type")+"").equals(m.get("TYPE_ID")+"")){
90.  
    row.add(m.get("NUM")+"");
91.  
    break;
92.  
    }
93.  
    }
94.  
    }else if("d_depart".equals(key_columns[i])&&map.get("d_depart")!=null) {
95.  
    String d_depart = map.get("d_depart")+"";
96.  
    String depart = "";
97.  
    for (Map m : d_zrbm) {
98.  
    if((d_depart).indexOf(",")>-1) {
99.  
    for (String string : d_depart.split(",")) {
100.  
     if((string).equals(m.get("ID")+"")) {
101.  
     depart += ","+m.get("UNITNAME")+"";
102.  
     break;
103.  
     }
104.  
     }
105.  
     }else {
106.  
     if((d_depart).equals(m.get("ID")+"")) {
107.  
     depart = ","+m.get("UNITNAME")+"";
108.  
     break;
109.  
     }
110.  
     }
111.  
     }
112.  
     if (StringUtils.isNotBlank(depart)) {
113.  
     depart = depart.substring(1, depart.length()).replace(",", " ");
114.  
     row.add(depart);
115.  
     }else {
116.  
     row.add("");
117.  
     }
118.  
     }else if("d_executeunit".equals(key_columns[i])&&map.get("d_executeunit")!=null) {
119.  
     boolean flag;
120.  
     for (Map m : d_executeunit) {
121.  
     flag = false;
122.  
     String executeunit = map.get("d_executeunit")+"";
123.  
     if((executeunit).indexOf(",")>-1) {
124.  
     for (String string : executeunit.split(",")) {
125.  
     if((string).equals(m.get("ID")+"")) {
126.  
     row.add((m.get("UNITNAME")+"").trim());
127.  
     flag = true;
128.  
     break;
129.  
     }
130.  
     }
131.  
     if (flag) {
132.  
     break;
133.  
     }
134.  
      
135.  
     }else {
136.  
     if((executeunit).equals(m.get("ID")+"")) {
137.  
     row.add((m.get("UNITNAME")+"").trim());
138.  
     break;
139.  
     }
140.  
     }
141.  
     }
142.  
     }else {
143.  
     if(map.get(key_columns[i])==null) {
144.  
     row.add("");
145.  
     }else {
146.  
     row.add((map.get(key_columns[i])+"").trim());
147.  
     }
148.  
     }
149.  
     }
150.  
     content.add(row);
151.  
     }
152.  
     head.addAll(content);
153.  
     int[] colWidths = new int[] { 600, 3000, 500, 500, 800, 800 ,800,3000,800,1500};
154.  
     XWPFDocument document = ExportUtil.exportWord(title,value_columns, head,colWidths,1,7);
155.  
     OutputStream out = response.getOutputStream();
156.  
     document.write(out);
157.  
     out.close();
158.  
     rm.setCode("1");
159.  
     rm.setMsg("导出成功");
160.  
     } catch (Exception e) {
161.  
     e.printStackTrace();
162.  
     rm.setCode("0");
163.  
     rm.setMsg("导出失败，请刷新重试。");
164.  
     }
165.  
     return rm;
166.  
     }

四、工具类代码

1.  
   /**
2.  
   *
3.  
   * @Date 2018年7月19日 上午11:19:04
4.  
   * @Description 导出word
5.  
   * @Fcunction exportWord
6.  
   * @param title
7.  
   * @param value_columns
8.  
   * @param list
9.  
   * @return XWPFDocument
10.  
    *
11.  
    */
12.  
    public static XWPFDocument exportWord(String title,String[] value_columns, List<List<String>> list,int[] colWidths,int one,int two) {
13.  
    XWPFDocument doc= new XWPFDocument();
14.  
     
15.  
    CTDocument1 document = doc.getDocument();
16.  
    CTBody body = document.getBody();
17.  
    if(!body.isSetSectPr()){
18.  
    body.addNewSectPr();
19.  
    }
20.  
    CTSectPr section = body.getSectPr();
21.  
     
22.  
    if(!section.isSetPgSz()){
23.  
    section.addNewPgSz();
24.  
    }
25.  
    CTPageSz pageSize = section.getPgSz();
26.  
    pageSize.setW(BigInteger.valueOf(15840));
27.  
    pageSize.setH(BigInteger.valueOf(12240));
28.  
    pageSize.setOrient(STPageOrientation.LANDSCAPE);
29.  
     
30.  
    //添加标题
31.  
    XWPFParagraph titleParagraph = doc.createParagraph();
32.  
     
33.  
    //设置段落居中
34.  
    titleParagraph.setAlignment(ParagraphAlignment.CENTER);
35.  
     
36.  
    XWPFRun titleParagraphRun = titleParagraph.createRun();
37.  
    titleParagraphRun.setText(title);
38.  
    titleParagraphRun.setColor("000000");
39.  
    titleParagraphRun.setFontSize(20);
40.  
     
41.  
    //表格
42.  
    XWPFTable ComTable = doc.createTable();
43.  
     
44.  
    //设置指定宽度
45.  
    CTTbl ttbl = ComTable.getCTTbl();
46.  
    CTTblGrid tblGrid = ttbl.addNewTblGrid();
47.  
    for (int i : colWidths) {
48.  
    CTTblGridCol gridCol = tblGrid.addNewGridCol();
49.  
    gridCol.setW(new BigInteger(i+""));
50.  
    }
51.  
     
52.  
    //表头
53.  
    XWPFTableRow rowHead = ComTable.getRow(0);
54.  
    XWPFParagraph cellParagraph = rowHead.getCell(0).getParagraphs().get(0);
55.  
    cellParagraph.setAlignment(ParagraphAlignment.CENTER); //设置表头单元格居中
56.  
    XWPFRun cellParagraphRun = cellParagraph.createRun();
57.  
    cellParagraphRun.setFontSize(10); //设置表头单元格字号
58.  
    cellParagraphRun.setBold(true); //设置表头单元格加粗
59.  
    cellParagraphRun.setText(value_columns[0]);
60.  
    for (int i = 1; i < value_columns.length; i++) {
61.  
    if(value_columns[i].indexOf("增减")>-1) {
62.  
    cellParagraph = rowHead.addNewTableCell().getParagraphs().get(0);
63.  
    cellParagraph.setAlignment(ParagraphAlignment.CENTER); //设置表头单元格居中
64.  
    cellParagraphRun = cellParagraph.createRun();
65.  
    cellParagraphRun.setFontSize(10); //设置表头单元格居中
66.  
    cellParagraphRun.setBold(true);
67.  
    cellParagraphRun.setText("增减(+ / -)");
68.  
    }else {
69.  
    cellParagraph = rowHead.addNewTableCell().getParagraphs().get(0);
70.  
    cellParagraph.setAlignment(ParagraphAlignment.CENTER); //设置表头单元格居中
71.  
    cellParagraphRun = cellParagraph.createRun();
72.  
    cellParagraphRun.setFontSize(10); //设置表头单元格居中
73.  
    cellParagraphRun.setBold(true); //设置表头单元格加粗
74.  
    cellParagraphRun.setText(value_columns[i]);
75.  
    }
76.  
    }
77.  
    int rows = list.size();
78.  
    //表格内容
79.  
    for (int i = 0; i < rows; i++) {
80.  
    XWPFTableRow rowsContent = ComTable.createRow();
81.  
    for (int j = 0; j < list.get(i).size(); j++) {
82.  
    XWPFParagraph cellParagraphC = rowsContent.getCell(j).getParagraphs().get(0);
83.  
    if(j!=one&&j!=two) {
84.  
    cellParagraphC.setAlignment(ParagraphAlignment.CENTER); //设置表格内容居中
85.  
    }
86.  
    XWPFRun cellParagraphRunC = cellParagraphC.createRun();
87.  
    cellParagraphRunC.setFontSize(10); //设置表格内容字号
88.  
    cellParagraphRunC.setText(list.get(i).get(j)+""); //单元格段落加载内容
89.  
    }
90.  
    }
91.  
    if(rows==0) {
92.  
    for (int i = 0; i < value_columns.length; i++) {
93.  
    XWPFTableCell cell = ComTable.getRow(0).getCell(i);
94.  
    cell.setVerticalAlignment(XWPFTableCell.XWPFVertAlign.CENTER); //垂直居中
95.  
    }
96.  
    }else {
97.  
    //设置居中
98.  
    for (int i = 0; i <= rows; i++) {
99.  
    for (int j = 0; j < list.get(0).size(); j++) {
100.  
     XWPFTableCell cell = ComTable.getRow(i).getCell(j);
101.  
     cell.setVerticalAlignment(XWPFTableCell.XWPFVertAlign.CENTER); //垂直居中
102.  
     }
103.  
     }
104.  
     }
105.  
     return doc;
106.  
     }
107.  
      
108.  
     /**
109.  
     *
110.  
     * @Date 2018年7月19日 上午11:19:21
111.  
     * @Description 判断是否是整数
112.  
     * @Fcunction isNumeric
113.  
     * @param str
114.  
     * @return boolean
115.  
     *
116.  
     */
117.  
     public static boolean isNumeric(String str) {
118.  
     if(str.indexOf(".")>0) {
119.  
     return false;
120.  
     }
121.  
     return true;
122.  
     }
123.  
      
124.  
     /**
125.  
     *
126.  
     * @Date 2018年7月19日 上午11:44:48
127.  
     * @Description 正式计划草案获取前两行
128.  
     * @Fcunction getCzzscaList
129.  
     * @param jnjhzh
130.  
     * @param trimpro
131.  
     * @param temp
132.  
     * @return List<List<String>>
133.  
     *
134.  
     */
135.  
     public static List<List<String>> getCzzscaList(String jnjhzh,String trimpro,String temp) {
136.  
     List<List<String>> list = new ArrayList<List<String>>();
137.  
     List<String> l1 = new ArrayList<String>(); //固定第一行
138.  
     l1.add("");
139.  
     l1.add("年度总计");
140.  
     l1.add("");
141.  
     l1.add("");
142.  
     l1.add("");
143.  
     l1.add("");
144.  
     l1.add(jnjhzh);
145.  
     l1.add("");
146.  
     l1.add("");
147.  
     l1.add("");
148.  
     list.add(l1);
149.  
     List<String> l2 = new ArrayList<String>(); //固定第二行
150.  
     l2.add("");
151.  
     l2.add("搜索总计");
152.  
     l2.add("");
153.  
     l2.add("");
154.  
     l2.add("");
155.  
     l2.add("");
156.  
     l2.add("");
157.  
     // l2.add(trimpro+" 100%");
158.  
     l2.add("");
159.  
     l2.add("");
160.  
     l2.add("");
161.  
     list.add(l2);
162.  
     return list;
163.  
     }

五、详解：

1.设置纸张大小

（1）创建完XWPFDocument后，默认为A4纸张，如需调整纸张大小，这里我是要用A3大小使用如下代码

1.  
   XWPFDocument doc= new XWPFDocument();
2.  
   CTDocument1 document = doc.getDocument();
3.  
   CTBody body = document.getBody();
4.  
   if(!body.isSetSectPr()){
5.  
   body.addNewSectPr();
6.  
   }
7.  
   CTSectPr section = body.getSectPr();
8.  
    
9.  
   if(!section.isSetPgSz()){
10.  
    section.addNewPgSz();
11.  
    }
12.  
    CTPageSz pageSize = section.getPgSz();
13.  
    pageSize.setW(BigInteger.valueOf(15840));
14.  
    pageSize.setH(BigInteger.valueOf(12240));
15.  
    pageSize.setOrient(STPageOrientation.LANDSCAPE);

（2）默认A4纸张大小的话只用XWPFDocument

XWPFDocument doc= new XWPFDocument();

（3）使用CTPageSz类需要导入ooxml-schemas的jar包（所有需要的jar包maven依赖在底部）

2.单元格列宽度

（1）每一列宽度相等自适应，不需单独设置每一列宽度的话使用如下代码

1.  
   //表格
2.  
   XWPFTable ComTable = doc.createTable();
3.  
   //表格自适应宽度
4.  
   CTTblWidth comTableWidth = ComTable.getCTTbl().addNewTblPr().addNewTblW();
5.  
   comTableWidth.setType(STTblWidth.DXA);
6.  
   comTableWidth.setW(BigInteger.valueOf(9072));

（2）单独设置每列宽度

1.  
   //表格
2.  
   XWPFTable ComTable = doc.createTable();
3.  
   //设置指定宽度
4.  
   CTTbl ttbl = ComTable.getCTTbl();
5.  
   CTTblGrid tblGrid = ttbl.addNewTblGrid();
6.  
   int[] colWidths = new int[] { 600, 3000, 500, 500, 800, 800 ,800,3000,800,1500};
7.  
   for (int i : colWidths) {
8.  
   CTTblGridCol gridCol = tblGrid.addNewGridCol();
9.  
   gridCol.setW(new BigInteger(i+""));
10.  
    }

（3）使用CTTblGrid类需要导入poi-ooxml-schemas的jar包（所有需要的jar包maven依赖在底部）

3.单元格内字体样式

（1）不需要设置单元格字体

1.  
   for (int i = 0; i < rows; i++) {
2.  
   XWPFTableRow rowsContent = ComTable.createRow();
3.  
   for (int j = 0; j < list.get(i).size(); j++) {
4.  
   rowsContent.getCell(j).setText(list.get(i).get(j)+""); //用单元格加载内容
5.  
   }
6.  
   }

（2）设置单元格内字体字号、是否加粗

1.  
   for (int i = 0; i < rows; i++) {
2.  
   XWPFTableRow rowsContent = ComTable.createRow();
3.  
   for (int j = 0; j < list.get(i).size(); j++) {
4.  
   XWPFParagraph cellParagraphC = rowsContent.getCell(j).getParagraphs().get(0);
5.  
   if(j!=1&&j!=7) {
6.  
   cellParagraphC.setAlignment(ParagraphAlignment.CENTER); //设置表格内容居中
7.  
   }
8.  
   XWPFRun cellParagraphRunC = cellParagraphC.createRun();
9.  
   cellParagraphRunC.setFontSize(10); //设置表格内容字号
10.  
    cellParagraphRun.setBold(true); //设置表头单元格加粗
11.  
    cellParagraphRunC.setText(list.get(i).get(j)+""); //单元格段落加载内容
12.  
    }
13.  
    }

4.单元格居中（水平居中、垂直居中）

（1）使用单元格加载内容

1.  
   for (int i = 0; i < value_columns.length; i++) {
2.  
   XWPFTableCell cell = ComTable.getRow(0).getCell(i);
3.  
   cell.setVerticalAlignment(XWPFTableCell.XWPFVertAlign.CENTER); //垂直居中
4.  
   CTTc cttc = cell.getCTTc();
5.  
   CTP ctp = cttc.getPList().get(0);
6.  
   CTPPr ctppr = ctp.getPPr();
7.  
   if (ctppr == null) {
8.  
   ctppr = ctp.addNewPPr();
9.  
   }
10.  
    CTJc ctjc = ctppr.getJc();
11.  
    if (ctjc == null) {
12.  
    ctjc = ctppr.addNewJc();
13.  
    }
14.  
    ctjc.setVal(STJc.CENTER); //水平居中
15.  
    }

（2）使用单元格的段落加载内容，只用调用垂直居中的方法

1.  
   for (int i = 0; i < value_columns.length; i++) {
2.  
   XWPFTableCell cell = ComTable.getRow(0).getCell(i);
3.  
   cell.setVerticalAlignment(XWPFTableCell.XWPFVertAlign.CENTER); //垂直居中
4.  
   }

水平居中在3-(2)里调用了段落的方法居中过了

cellParagraphC.setAlignment(ParagraphAlignment.CENTER);

5.单元格合并

（1）跨列合并单元格

1.  
   public static void mergeCellsHorizontal(XWPFTable table, int row, int fromCell, int toCell) {
2.  
   for (int cellIndex = fromCell; cellIndex <= toCell; cellIndex++) {
3.  
   XWPFTableCell cell = table.getRow(row).getCell(cellIndex);
4.  
   if ( cellIndex == fromCell ) {
5.  
   cell.getCTTc().addNewTcPr().addNewHMerge().setVal(STMerge.RESTART);
6.  
   } else {
7.  
   cell.getCTTc().addNewTcPr().addNewHMerge().setVal(STMerge.CONTINUE);
8.  
   }
9.  
   }
10.  
    }

（2）跨行合并单元格

1.  
   public static void mergeCellsVertically(XWPFTable table, int col, int fromRow, int toRow) {
2.  
   for (int rowIndex = fromRow; rowIndex <= toRow; rowIndex++) {
3.  
   XWPFTableCell cell = table.getRow(rowIndex).getCell(col);
4.  
   if ( rowIndex == fromRow ) {
5.  
   cell.getCTTc().addNewTcPr().addNewVMerge().setVal(STMerge.RESTART);
6.  
   } else {
7.  
   cell.getCTTc().addNewTcPr().addNewVMerge().setVal(STMerge.CONTINUE);
8.  
   }
9.  
   }
10.  
    }

六、使用到的Maven依赖

1.  
   <dependency>
2.  
   <groupId>org.apache.xmlbeans</groupId>
3.  
   <artifactId>xmlbeans</artifactId>
4.  
   <version>2.6.0</version>
5.  
   </dependency>
6.  
   <dependency>
7.  
   <groupId>org.apache.poi</groupId>
8.  
   <artifactId>poi-ooxml</artifactId>
9.  
   <version>3.9</version>
10.  
    </dependency>
11.  
    <dependency>
12.  
    <groupId>org.apache.poi</groupId>
13.  
    <artifactId>ooxml-schemas</artifactId>
14.  
    <version>1.1</version>
15.  
    </dependency>
16.  
    <dependency>
17.  
    <groupId>org.apache.poi</groupId>
18.  
    <artifactId>poi-ooxml-schemas</artifactId>
19.  
    <version>3.16</version>
20.  
    </dependency>