将PDF转换为Excel文件 [英] Convert a PDF into an Excel file

问题描述

我已经通过电子邮件发送了一个PDF文件，该文件是一组表格.
我该如何操作和分析此数据集，但是...

我可以复制和粘贴，但它会在Excel工作表上变成图像.
或
我可以复制数据，并且数据变得不可读(无法读取，即看起来像二进制文件字符.)

我的第三个选择是将它们打印出来，然后找人重新输入.

我很确定还有第四种选择...


有人可以帮忙吗?

I have been emailed a PDF file which is a set of tables.
I what to manipulate and analyse this data set, but...

I can copy and paste, but it becomes an image on the Excel worksheet.
Or
I can copy the data and it becomes unreadable (non human readable that is, looks like a binary file characters.)

My third option is to print them out and get someone to retype them in.

I am pretty sure there is a fourth option...


Can someone help?

推荐答案

Dalek，可以选择用Java或C#(或其他.NET语言)编写的代码读取PDF.然后，您可以将PDF数据显示为可以在Excel中导入的某些文本，也可以使用 Microsoft Office interop 直接创建excel文件，在这种情况下，最好使用.NET(当然，在所有情况下，最好使用.NET，只有某些人更喜欢Java :-)).显然，另一个输入应该是在生成输出时要应用的一些映射规则.

为什么只提到Java和.NET?由于最推荐的产品叫iText for Java，因此请参见 http://en.wikipedia.org/wiki/IText [ ^ ]，http://itextpdf.com/ [ ^ ].

还有一个名为iTextSharp的.NET端口，请参见 http://sourceforge.net/projects/itextsharp/ [ ^ ].

我相信您可以从MSDN中了解如何在.NET中使用Excel.那呢?

—SA

Dalek, the option is to read PDF in your code written in Java or C# (or some other .NET language). Then you can present the PDF data as some text you can import in Excel or directly create an excel file using Microsoft Office interop, in this case its better to use .NET (well, in all cases it''s better to use .NET, just some people would prefer Java :-)). Apparently, another input should be some mapping rules you want to apply when generating output.

Why did I mentioned just Java and .NET? Because of the most recommended product called iText for Java, see http://en.wikipedia.org/wiki/IText[^], http://itextpdf.com/[^].

There is also a .NET port called iTextSharp, see http://sourceforge.net/projects/itextsharp/[^].

I believe you can find out from MSDN how to work with Excel in .NET. How about that?

—SA

这篇关于将PDF转换为Excel文件的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！