是否可以使用 Apache Tika 提取表信息? [英] Is it possible to extract table infomation using Apache Tika?
问题描述
我正在寻找 pdf 和 MS Office 文档格式的解析器，以从文件中提取表格信息.当我看到 Apache Tika 时，正在考虑编写单独的实现.我能够从任何这些文件格式中提取全文.但我的要求是提取表格数据，其中我期望以键值格式显示 2 列.我检查了网上可用的大部分内容以寻求解决方案，但找不到任何解决方案.对此有何指点?
好吧，我继续使用 apache poi 为 MS 格式单独实现了它.我回到 Tika 阅读 PDF.Tika 对文档所做的是将其输出为基于 SAX 的 XHTML 事件"1
所以基本上我们可以编写一个自定义的 SAX 实现来解析文件.
结构文本输出将采用以下形式(避免元细节)
<p>Key1 Value1 </p><p>Key2 Value2 </p><p>Key3 Value3</p><p/>在我们的 SAX 实现中，我们可以将第一部分视为键(对于我的问题，我已经知道键并且我正在寻找值，所以它是一个子字符串).
用逻辑覆盖 public void characters(char[] ch, int start, int length)
请注意，就我而言，内容的结构是固定的，而且我知道输入的密钥，因此这样做很容易.这不是通用的解决方案
I am looking at a parser for pdf and MS office document formats to extract tabular information from files. Was thinking of writing separate implementations when I saw Apache Tika. I am able to extract full text from any of these file formats. But my requirement is to extract tabular data where I am expecting 2 columns in a key value format. I checked most of the stuff available in the net for a solution but could not find any. Any pointers for this?
Well I went ahead and implemented it separately using apache poi for the MS formats. I came back to Tika for PDF. What Tika does with the docs is that it will output it as "SAX based XHTML events"1
So basically we can write a custom SAX implementation to parse the file.
The structure text output will be of the form (Meta details avoided)
<body><div class="page"><p/>
<p>Key1 Value1 </p>
<p>Key2 Value2 </p>
<p>Key3 Value3</p>
<p/>
</div>
</body>
In our SAX implementation we can consider the first part as key (for my problem I already know the key and I am looking for values, so it is a substring).
Override public void characters(char[] ch, int start, int length) with the logic
Please note for my case the structure of the content is fixed and I know the keys that are coming in, so it was easy doing it this way. This is not a generic solution
这篇关于是否可以使用 Apache Tika 提取表信息?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
