java 将表格数据从 pdf 导出到 excel-ag凯发旗舰厅

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


    
        e-iceblue
        spire.office
        4.12.2
    

import com.spire.pdf.pdfdocument;
import com.spire.pdf.utilities.pdftable;
import com.spire.pdf.utilities.pdftableextractor;
import com.spire.xls.excelversion;
import com.spire.xls.workbook;
import com.spire.xls.worksheet;
public class extracttabledataandsaveinexcel {
    public static void main(string[] args) {
        //加载示例pdf文档
        pdfdocument pdf = new pdfdocument("c:\\users\\administrator\\desktop\\tables.pdf");
        //创建一个pdftableextractor实例
        pdftableextractor extractor = new pdftableextractor(pdf);
        //从第一页提取表格
        pdftable[] pdftables  = extractor.extracttable(0);
        //创建一个工作簿对象
        workbook wb = new workbook();
        //删除默认工作表
        wb.getworksheets().clear();
        //如果找到任何表格
        if (pdftables != null && pdftables.length > 0) {
            //循环遍历表格
            for (int tablenum = 0; tablenum < pdftables.length; tablenum  ) {
                //将工作表添加到工作簿
                string sheetname = string.format("table - %d", tablenum   1);
                worksheet sheet = wb.getworksheets().add(sheetname);
                //循环遍历当前表格中的行
                for (int rownum = 0; rownum < pdftables[tablenum].getrowcount(); rownum  ) {
                    //循环遍历当前表格中的列
                    for (int colnum = 0; colnum < pdftables[tablenum].getcolumncount(); colnum  ) {
                        //从当前表格单元格中提取数据
                        string text = pdftables[tablenum].gettext(rownum, colnum);
                        //将数据插入特定单元格
                        sheet.get(rownum   1, colnum   1).settext(text);
                    }
                }
                //自动调整列宽
                for (int sheetcolnum = 0; sheetcolnum < sheet.getcolumns().length; sheetcolnum  ) {
                    sheet.autofitcolumn(sheetcolnum   1);
                }
            }
        }
        //将工作簿保存为 excel 文件
        wb.savetofile("output/exporttabletoexcel.xlsx", excelversion.version2016);
    }
}