java 将 word 转为 excel-凯发线上登陆下载网址

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


    
        e-iceblue
        spire.office
        8.5.6
    

import com.spire.doc.*;
import com.spire.doc.documents.paragraph;
import com.spire.doc.fields.docpicture;
import com.spire.doc.fields.textrange;
import com.spire.xls.*;
import java.awt.*;
public class convertwordtoexcel {
    public static void main(string[] args) {
        //创建一个 document 对象
        document doc = new document();
        //加载 word 文件
        doc.loadfromfile("xxx公司采购单.docx");
        //创建一个 workbook 对象
        workbook wb = new workbook();
        //删除默认工作表
        wb.getworksheets().clear();
        //创建一个名为“wordtoexcel”的工作表
        worksheet worksheet = wb.createemptysheet("wordtoexcel");
        int row = 1;
        int column = 1;
        //循环遍历 word 文档中的各个节
        for (int i = 0; i < doc.getsections().getcount(); i  ) {
            //获取特定节
            section section = doc.getsections().get(i);
            //遍历某个节下的所有文档对象
            for (int j = 0; j < section.getbody().getchildobjects().getcount(); j  ) {
                //获取特定的文档对象
                documentobject documentobject = section.getbody().getchildobjects().get(j);
                //判断对象是否为段落
                if (documentobject instanceof paragraph) {
                    cellrange cell = worksheet.getcellrange(row, column);
                    paragraph paragraph = (paragraph) documentobject;
                    //将段落从 word 复制到特定单元格
                    copytextandstyle(cell, paragraph);
                    row  ;
                }
                //判断对象是否为表格
                if (documentobject instanceof table) {
                    table table = (table) documentobject;
                    //将表格数据从 word 导出到 excel
                    int currentrow = exporttableinexcel(worksheet, row, table);
                    row = currentrow;
                }
            }
        }
        //在单元格中换行文本
        worksheet.getallocatedrange().iswraptext(true);
        //自动调整行高和列宽
        worksheet.getallocatedrange().autofitrows();
        worksheet.getallocatedrange().autofitcolumns();
        //将工作簿保存到 excel 文件
        wb.savetofile("output.xlsx", excelversion.version2013);
    }
    //将数据从 word 表格导出到 excel 单元格
    private static int exporttableinexcel(worksheet worksheet, int row, table table) {
        cellrange cell;
        int column;
        for (int i = 0; i < table.getrows().getcount(); i  ) {
            column = 1;
            tablerow tbrow = table.getrows().get(i);
            for (int j = 0; j < tbrow.getcells().getcount(); j  ) {
                tablecell tbcell = tbrow.getcells().get(j);
                cell = worksheet.getcellrange(row, column);
                cell.borderaround(linestyletype.thin, color.black);
                copycontentintable(tbcell, cell);
                column  ;
            }
            row  ;
        }
        return row;
    }
    //将内容从 word 表格单元格复制到 excel 单元格
    private static void copycontentintable(tablecell tbcell, cellrange cell) {
        paragraph newpara = new paragraph(tbcell.getdocument());
        for (int i = 0; i < tbcell.getchildobjects().getcount(); i  ) {
            documentobject documentobject = tbcell.getchildobjects().get(i);
            if (documentobject instanceof paragraph) {
                paragraph paragraph = (paragraph) documentobject;
                for (int j = 0; j < paragraph.getchildobjects().getcount(); j  ) {
                    documentobject cobj = paragraph.getchildobjects().get(j);
                    newpara.getchildobjects().add(cobj.deepclone());
                }
                if (i < tbcell.getchildobjects().getcount() - 1) {
                    newpara.appendtext("\n");
                }
            }
        }
        copytextandstyle(cell, newpara);
    }
    //将段落的文本和样式复制到单元格
    private static void copytextandstyle(cellrange cell, paragraph paragraph) {
        richtext richtext = cell.getrichtext();
        richtext.settext(paragraph.gettext());
        int startindex = 0;
        for (int i = 0; i < paragraph.getchildobjects().getcount(); i  ) {
            documentobject documentobject = paragraph.getchildobjects().get(i);
            if (documentobject instanceof textrange) {
                textrange textrange = (textrange) documentobject;
                string fontname = textrange.getcharacterformat().getfontname();
                boolean isbold = textrange.getcharacterformat().getbold();
                color textcolor = textrange.getcharacterformat().gettextcolor();
                float fontsize = textrange.getcharacterformat().getfontsize();
                string textrangetext = textrange.gettext();
                int strlength = textrangetext.length();
                excelfont font = new excelfont(cell.getworksheet().getworkbook().createfont());
                font.setcolor(textcolor);
                font.isbold(isbold);
                font.setsize(fontsize);
                font.setfontname(fontname);
                int endindex = startindex   strlength;
                richtext.setfont(startindex, endindex, font);
                startindex  = strlength;
            }
            if (documentobject instanceof docpicture) {
                docpicture picture = (docpicture) documentobject;
                cell.getworksheet().getpictures().add(cell.getrow(), cell.getcolumn(), picture.getimage());
                cell.getworksheet().setrowheightinpixels(cell.getrow(), 1, picture.getimage().getheight());
            }
        }
        switch (paragraph.getformat().gethorizontalalignment()) {
            case left:
                cell.sethorizontalalignment(horizontalaligntype.left);
                break;
            case center:
                cell.sethorizontalalignment(horizontalaligntype.center);
                break;
            case right:
                cell.sethorizontalalignment(horizontalaligntype.right);
                break;
        }
    }
}