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

一、效果如下

二、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(",", "\r ");
                            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+"\r100%");
        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代码

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

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

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

四、工具类代码

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

五、详解：

1.设置纸张大小

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

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

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

XWPFDocument doc= new XWPFDocument();

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

2.单元格列宽度

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

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

（2）单独设置每列宽度

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

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

3.单元格内字体样式

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

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

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

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

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

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

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

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

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

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

cellParagraphC.setAlignment(ParagraphAlignment.CENTER);

5.单元格合并

（1）跨列合并单元格

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

（2）跨行合并单元格

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

六、使用到的Maven依赖

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