读取XLSB文件-Apache POI [英] Reading XLSB file - Apache POI

问题描述

我已经引用了与使用Apache POI读取XLSB文件有关的堆栈溢出中的所有帖子.我使用帖子中提到的可用链接/示例尝试了多种方法来读取XLSB文件.但是我最终遇到了问题.

I have referred all post in stack overflow related to reading XLSB file using apache POI. I tried many ways to read XLSB file using available links/example mentioned in post. But I am ended up in issues.

我正在使用最新的Apache POI 3.17，并使用了

I am using latest Apache POI 3.17 and used the code mentioned in

链接:异常读取XLSB文件Apache POI java.io.CharConversionException

部分:"Gagravarr"

Section: Post mentioned by "Gagravarr "

我遇到以下错误

对于XSSFBEventBasedExcelExtractor类型，未定义方法getLocale()

The method getLocale() is undefined for the type XSSFBEventBasedExcelExtractor

XSSFBEventBasedExcelExtractor类型的getFormulasNotResults()方法未定义

The method getFormulasNotResults() is undefined for the type XSSFBEventBasedExcelExtractor

构造函数XSSFEventBasedExcelExtractor.SheetTextExtractor()不可见

The constructor XSSFEventBasedExcelExtractor.SheetTextExtractor() is not visible

对于类型XSSFBEventBasedExcelExtractor，未定义方法getIncludeSheetNames()

The method getIncludeSheetNames() is undefined for the type XSSFBEventBasedExcelExtractor

..........................等

.......................... etc

我检查了基类"XSSFEventBasedExcelExtractor"，在poi-ooxml-3.17.jar(源文件)中，我可以找到所有方法的实现.

I checked the base class "XSSFEventBasedExcelExtractor" in poi-ooxml-3.17.jar (source files) and I can able to find implementation for all the method.

我想知道这是否是已知问题?这是否意味着没有可用的示例来读取Java中的XLSB文件.

I wanted to know whether this is an known issue ? Does it mean that there is no working example available to read XLSB files in Java.

我希望这个查询不会重复.

I hope this query is not duplicate.

推荐答案

最近，我研究了如何使用poi读取xlsb.如果您只想纯粹阅读xlsb，则可以使用apache测试示例代码，如下所示.https://svn.apache.org/repos/asf/poi/trunk/src/ooxml/testcases/org/apache/poi/xssf/eventusermodel/TestXSSFBReader.java

Recently, i study how to use poi to read xlsb. If you just want to read a xlsb purely, you can use the apache test example code as the following. https://svn.apache.org/repos/asf/poi/trunk/src/ooxml/testcases/org/apache/poi/xssf/eventusermodel/TestXSSFBReader.java

实际上，xlsb使用.bin文件而不是.xml文件.如果您想对xlsb文件做更多的事情，可以阅读以下文档. https://msdn.microsoft.com/en-us/library/office/cc313133(v=office.12).aspx

In fact, xlsb use .bin file instead of .xml file. If you want to do more thing to xlsb file, you can read this document as the following. https://msdn.microsoft.com/en-us/library/office/cc313133(v=office.12).aspx

这篇关于读取XLSB文件-Apache POI的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！