java 导出带格式的 excel 数据到 word 表格-人生就是博尊龙凯时

    
        com.e-iceblue
        e-iceblue
        https://repo.e-iceblue.cn/repository/maven-public/
    


    
        e-iceblue
        spire.office
        8.9.7
    

import com.spire.doc.*;
import com.spire.doc.fileformat;
import com.spire.doc.documents.horizontalalignment;
import com.spire.doc.documents.pageorientation;
import com.spire.doc.documents.verticalalignment;
import com.spire.doc.fields.textrange;
import com.spire.xls.*;
public class exportexceltoword {
    public static void main(string[] args) {
        //下载一个excel文件
        workbook workbook = new workbook();
        workbook.loadfromfile("c:/users/administrator/desktop/sample.xlsx");
        //得到第一张工作表
        worksheet sheet = workbook.getworksheets().get(0);
        //创建一个word文档
        document doc = new document();
        section section = doc.addsection();
        section.getpagesetup().setorientation(pageorientation.landscape);
        //添加一个表格
        table table = section.addtable(true);
        table.resetcells(sheet.getlastrow(), sheet.getlastcolumn());
        //合并单元格
        mergecells(sheet, table);
        for (int r = 1; r <= sheet.getlastrow(); r  ) {
            //设置行高
            table.getrows().get(r - 1).setheight((float) sheet.getrowheight(r));
            for (int c = 1; c <= sheet.getlastcolumn(); c  ) {
                cellrange xcell = sheet.getcellrange(r, c);
                tablecell wcell = table.get(r - 1, c - 1);
                //获得特定excel单元格的值并将其添加到word表格单元格
                textrange textrange = wcell.addparagraph().appendtext(xcell.getvalue());
                // 从excel复制字体和单元格样式到word
                copystyle(textrange, xcell, wcell);
            }
        }
        //保存文档为word文件
        doc.savetofile("exporttoword.docx", fileformat.docx);
    }
    //如果有合并的区域，则合并单元格
    private static void mergecells(worksheet sheet, table table) {
        if (sheet.hasmergedcells()) {
            //从excel中获取合并的单元格范围
            cellrange[] ranges = sheet.getmergedcells();
            for (int i = 0; i < ranges.length; i  ) {
                int startrow = ranges[i].getrow();
                int startcolumn = ranges[i].getcolumn();
                int rowcount = ranges[i].getrowcount();
                int columncount = ranges[i].getcolumncount();
                //合并word表格中的对应单元格
                if (rowcount > 1 && columncount > 1) {
                    for (int j = startrow; j <= startrow   rowcount ; j  ) {
                        table.applyhorizontalmerge(j - 1, startcolumn - 1, startcolumn - 1   columncount - 1);
                    }
                    table.applyverticalmerge(startcolumn - 1, startrow - 1, startrow - 1   rowcount - 1 );
                }
                if (rowcount > 1 && columncount == 1 ) {
                     table.applyverticalmerge(startcolumn - 1, startrow - 1, startrow - 1   rowcount - 1);
                }
                if (columncount > 1 && rowcount == 1 ) {
                    table.applyhorizontalmerge(startrow - 1, startcolumn - 1,  startcolumn - 1   columncount-1);
                }
            }
        }
    }
    //复制excel单元格样式到word表格
    private static void copystyle(textrange wtextrange, cellrange xcell, tablecell wcell) {
        //复制字体样式
        wtextrange.getcharacterformat().settextcolor(xcell.getstyle().getfont().getcolor());
        wtextrange.getcharacterformat().setfontsize((float) xcell.getstyle().getfont().getsize());
        wtextrange.getcharacterformat().setfontname(xcell.getstyle().getfont().getfontname());
        wtextrange.getcharacterformat().setbold(xcell.getstyle().getfont().isbold());
        wtextrange.getcharacterformat().setitalic(xcell.getstyle().getfont().isitalic());
        //复制背景色
        wcell.getcellformat().setbackcolor(xcell.getstyle().getcolor());
        //复制水平对齐方式
        switch (xcell.gethorizontalalignment()) {
            case left:
                wtextrange.getownerparagraph().getformat().sethorizontalalignment(horizontalalignment.left);
                break;
            case center:
                wtextrange.getownerparagraph().getformat().sethorizontalalignment(horizontalalignment.center);
                break;
            case right:
                wtextrange.getownerparagraph().getformat().sethorizontalalignment(horizontalalignment.right);
                break;
        }
        
        //复制垂直对齐方式
        switch (xcell.getverticalalignment()) {
            case bottom:
                wcell.getcellformat().setverticalalignment(verticalalignment.bottom);
                break;
            case center:
                wcell.getcellformat().setverticalalignment(verticalalignment.middle);
                break;
            case top:
                wcell.getcellformat().setverticalalignment(verticalalignment.top);
                break;
        }
    }
}