pdf转excel (可定制修改比网上转换准确)

最新推荐文章于 2024-04-01 10:01:08 发布

阳十三

最新推荐文章于 2024-04-01 10:01:08 发布

阅读量1.1k

点赞数 2

CC 4.0 BY-SA版权

分类专栏： java maven 文章标签： pdf excel

本文为wdful原创文章，未经wdful允许不得转载。

本文链接：https://blog.youkuaiyun.com/qq_28114645/article/details/89205917

博客内容介绍了如何借助特定依赖进行PDF到Excel的转换，强调了转换的准确性，并可以进行定制化修改。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

引入依赖:

<dependency>
			<groupId>org.apache.poi</groupId>
			<artifactId>poi</artifactId>
			<version>3.15</version>
		</dependency>
		<!-- https://mvnrepository.com/artifact/org.apache.pdfbox/pdfbox -->
		<dependency>
			<groupId>org.apache.pdfbox</groupId>
			<artifactId>pdfbox</artifactId>
			<version>2.0.3</version>
		</dependency>

		<!-- https://mvnrepository.com/artifact/org.apache.pdfbox/pdfbox-app -->
		<dependency>
			<groupId>org.apache.pdfbox</groupId>
			<artifactId>pdfbox-app</artifactId>
			<version>2.0.3</version>
		</dependency>
		<!-- https://mvnrepository.com/artifact/net.sourceforge.jexcelapi/jxl -->
		<dependency>
			<groupId>net.sourceforge.jexcelapi</groupId>
			<artifactId>jxl</artifactId>
			<version>2.6.12</version>
		</dependency>
		<!-- https://mvnrepository.com/artifact/org.apache.pdfbox/fontbox -->
		<dependency>
			<groupId>org.apache.pdfbox</groupId>
			<artifactId>fontbox</artifactId>
			<version>2.0.3</version>
		</dependency>

解析pdf为格式化文档用于读取数据


import org.apache.pdfbox.pdmodel.PDDocument;
import org.apache.pdfbox.text.PDFTextStripper;

import java.io.*;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import java.util.regex.Matcher;
import java.util.regex.Pattern;
import java.util.stream.Collectors;

public class PdfUtil {
    public static final File input = new File("pdf2excel/1");

    public static void main(String[] args) throws Exception {
        String title = "鼎和财产保险股份有限公司双流支公司手续费结算单";
        String[] rowsName = new String[]{"序号", "保/批单号", "险种", "投保人", "被保险人", "保单币种", "交费期数", "不含税保费", "销项税", "不含税手续费", "手续费进项税", "手续费价税合计","业务部门", "业务员"};
        List<Object[]> dataList = doc2Obj();
        Export2Excel ex = new Export2Excel(title, rowsName, dataList);
        ex.export();
    }


    public static void pdf2Txt(){
        PDDocument pd;
        BufferedWriter wr;
        try {
            File sourceFile = new File("1.pdf");
            File output = new File(sourceFile.getName().split("\\.")[0] + ".txt");
            pd = PDDocument.load(sourceFile);
            pd.save("CopyOf" + sourceFile.getName().split("\\.")[0] + ".pdf"); // Creates a copy called
            PDFTextStripper stripper = new PDFTextStripper();
            wr = new BufferedWriter(new OutputStreamWriter(
                    new FileOutputStream(output)));
            stripper.writeText(pd, wr);
            if (pd != null) {
                pd.close();
            }
            wr.close();
        } catch (Exception e) {
            e.printStackTrace();
        }
    }

    public static List<Object[]> doc2Obj() throws Exception{

        InputStreamReader isr = new InputStreamReader(new FileInputStream(input), "utf-8");
        BufferedReader br = new BufferedReader(isr);
        String lineTxt = null;
        List<String> doc = new ArrayList<String>();
        List<String> res = new ArrayList<String>();
        while ((lineTxt = br.readLine()) != null) {
            doc.add(lineTxt);
        }
        br.close();
        int cs = 1;
        System.out.println("文档行数:" + doc.size());
        for (int i = 0; i < doc.size(); i++) {
//            System.out.println(i);
            String line = doc.get(i).trim();
//