blocks|key|784014|text|需要包含poi-ooxml+jar才能获得XSSF库。poi+jar只有HSSF库。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|784015|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

You need to include the poi-ooxml jars to get the XSSF library. The poi jar only has the HSSF libraries.

blocks|key|998465|text|你需要包括poi-ooxml罐子。可以将其添加到pom.xml文件中|type|unstyled|depth|inlineStyleRanges|entityRanges|data|998466|<dependency>
++++<groupId>org.apache.poi</groupId>
++++<artifactId>poi-ooxml</artifactId>
++++<version>3.10-FINAL</version>
</dependency>|code-block|syntax|javascript|998467|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

You need to include poi-ooxml jars. You can add it to pom.xml file

<pre><code>&lt;dependency&gt;
 &lt;groupId&gt;org.apache.poi&lt;/groupId&gt;
 &lt;artifactId&gt;poi-ooxml&lt;/artifactId&gt;
 &lt;version&gt;3.10-FINAL&lt;/version&gt;
&lt;/dependency&gt;
</code></pre>

blocks|key|784077|text|首先，您需要将正确的jar文件包含到您的库中，poi-ooxml-schemas-3.8-20120326.jar。你可以在http://poi.apache.org/download.html上找到这些。并且您需要将以下链接添加到java文件中。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|784078|import+org.apache.poi.xssf.usermodel.XSSFWorkbook;|code-block|syntax|javascript|784079|entityMap|0|LINK|mutability|MUTABLE|url|http://poi.apache.org/download.html^0|1Q|Z|0|0|0^^$0|@$1|2|3|4|5|6|7|Q|8|@]|9|@$A|R|B|S|1|T]]|C|$]]|$1|D|3|E|5|F|7|U|8|@]|9|@]|C|$G|H]]|$1|I|3|-4|5|6|7|V|8|@]|9|@]|C|$]]]|J|$K|$5|L|M|N|C|$O|P]]]]

First you need to include the proper jar files into your libraries, poi-ooxml-schemas-3.8-20120326.jar. You can find these at <a href="http://poi.apache.org/download.html" rel="nofollow">http://poi.apache.org/download.html</a>.
And you need to add the following link to your java file.

<pre><code>import org.apache.poi.xssf.usermodel.XSSFWorkbook;
</code></pre>

blocks|key|998503|text|如果您创建了maven项目，请在pom.xml文件中使用下面依赖项|type|unstyled|depth|inlineStyleRanges|entityRanges|data|998504|<dependency>
++++<groupId>org.apache.poi</groupId>
++++<artifactId>poi-ooxml</artifactId>
++++<version>3.9</version>
</dependency>|code-block|syntax|javascript|998505|否则，将其导入到java文件中。|998506|导入org.apache.poi.ss.usermodel.Workbook；|998507|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|N|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|O|8|@]|9|@]|A|$]]|$1|I|3|J|5|6|7|P|8|@]|9|@]|A|$]]|$1|K|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|L|$]]

if you created maven project use below dependency in pom.xml file

<pre><code>&lt;dependency&gt;
 &lt;groupId&gt;org.apache.poi&lt;/groupId&gt;
 &lt;artifactId&gt;poi-ooxml&lt;/artifactId&gt;
 &lt;version&gt;3.9&lt;/version&gt;
&lt;/dependency&gt;
</code></pre>

otherwise import this in your java file

import org.apache.poi.ss.usermodel.Workbook;

blocks|key|998511|text|早些时候，当我使用maven+dependency时，它给出了如下错误，但在使用下载的二进制jar文件后，即:最新版本poi的"https://poi.apache.org/download.html“，它对我来说工作得很好。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|998512|Getting+error+saying+:+"IncompatibleClassChangeError:+Found+interface+org.apache.poi.util.POILogger,+but+class+was+expected
++++at+org.apache.poi.openxml4j.opc.PackageRelationshipCollection.parseRelationshipsPart(PackageRelationshipCollection.java:303)
++++at+org.apache.poi.openxml4j.opc.PackageRelationshipCollection.<init>(PackageRelationshipCollection.java:163)
++++at+org.apache.poi.openxml4j.opc.PackageRelationshipCollection.<init>(PackageRelationshipCollection.java:133)
++++at+org.apache.poi.openxml4j.opc.PackagePart.loadRelationships(PackagePart.java:570)
++++at+org.apache.poi.openxml4j.opc.OPCPackage.getParts(OPCPackage.java:723)
++++at+org.apache.poi.openxml4j.opc.OPCPackage.open(OPCPackage.java:302)
++++at+org.apache.poi.ooxml.util.PackageHelper.open(PackageHelper.java:37)
++++at+org.apache.poi.xssf.usermodel.XSSFWorkbook.<init>(XSSFWorkbook.java:307)
++++at+com.glide.platform_ml.regressionTests.classification.ExcelCallTest.readData(ExcelCallTest.java:40)
++++at+com.glide.platform_ml.regressionTests.classification.ExcelCallTest.main(ExcelCallTest.java:29)
"|code-block|syntax|javascript|998513|entityMap|0|LINK|mutability|MUTABLE|url|https://poi.apache.org/download.html^0|1S|10|0|0|0^^$0|@$1|2|3|4|5|6|7|Q|8|@]|9|@$A|R|B|S|1|T]]|C|$]]|$1|D|3|E|5|F|7|U|8|@]|9|@]|C|$G|H]]|$1|I|3|-4|5|6|7|V|8|@]|9|@]|C|$]]]|J|$K|$5|L|M|N|C|$O|P]]]]

Earlier It was giving error like below when I was using maven dependency , but after using downloaded binary jar files i.e. : &quot;https://poi.apache.org/download.html&quot; of poi of latest version its working fine for me .
<pre><code>Getting error saying : &quot;IncompatibleClassChangeError: Found interface org.apache.poi.util.POILogger, but class was expected
 at org.apache.poi.openxml4j.opc.PackageRelationshipCollection.parseRelationshipsPart(PackageRelationshipCollection.java:303)
 at org.apache.poi.openxml4j.opc.PackageRelationshipCollection.&lt;init&gt;(PackageRelationshipCollection.java:163)
 at org.apache.poi.openxml4j.opc.PackageRelationshipCollection.&lt;init&gt;(PackageRelationshipCollection.java:133)
 at org.apache.poi.openxml4j.opc.PackagePart.loadRelationships(PackagePart.java:570)
 at org.apache.poi.openxml4j.opc.OPCPackage.getParts(OPCPackage.java:723)
 at org.apache.poi.openxml4j.opc.OPCPackage.open(OPCPackage.java:302)
 at org.apache.poi.ooxml.util.PackageHelper.open(PackageHelper.java:37)
 at org.apache.poi.xssf.usermodel.XSSFWorkbook.&lt;init&gt;(XSSFWorkbook.java:307)
 at com.glide.platform_ml.regressionTests.classification.ExcelCallTest.readData(ExcelCallTest.java:40)
 at com.glide.platform_ml.regressionTests.classification.ExcelCallTest.main(ExcelCallTest.java:29)
&quot;
</code></pre>

blocks|key|998515|text|https://stackoverflow.com/a/65141876/5886712|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|998516|早些时候，当我使用maven+dependency时，它给出了如下错误，但在使用下载的二进制jar文件后，即:最新版本poi的"https://poi.apache.org/download.html“，它对我来说工作得很好。|998517|Getting+error+saying+:+"IncompatibleClassChangeError:+Found+interface+org.apache.poi.util.POILogger,+but+class+was+expected
++++at+org.apache.poi.openxml4j.opc.PackageRelationshipCollection.parseRelationshipsPart(PackageRelationshipCollection.java:303)
++++at+org.apache.poi.openxml4j.opc.PackageRelationshipCollection.<init>(PackageRelationshipCollection.java:163)
++++at+org.apache.poi.openxml4j.opc.PackageRelationshipCollection.<init>(PackageRelationshipCollection.java:133)
++++at+org.apache.poi.openxml4j.opc.PackagePart.loadRelationships(PackagePart.java:570)
++++at+org.apache.poi.openxml4j.opc.OPCPackage.getParts(OPCPackage.java:723)
++++at+org.apache.poi.openxml4j.opc.OPCPackage.open(OPCPackage.java:302)
++++at+org.apache.poi.ooxml.util.PackageHelper.open(PackageHelper.java:37)
++++at+org.apache.poi.xssf.usermodel.XSSFWorkbook.<init>(XSSFWorkbook.java:307)
++++at+com.glide.platform_ml.regressionTests.classification.ExcelCallTest.readData(ExcelCallTest.java:40)
++++at+com.glide.platform_ml.regressionTests.classification.ExcelCallTest.main(ExcelCallTest.java:29)
"|code-block|syntax|javascript|998518|entityMap|0|LINK|mutability|MUTABLE|url|1|https://poi.apache.org/download.html^0|0|18|0|0|1S|10|1|0|0^^$0|@$1|2|3|4|5|6|7|T|8|@]|9|@$A|U|B|V|1|W]]|C|$]]|$1|D|3|E|5|6|7|X|8|@]|9|@$A|Y|B|Z|1|10]]|C|$]]|$1|F|3|G|5|H|7|11|8|@]|9|@]|C|$I|J]]|$1|K|3|-4|5|6|7|12|8|@]|9|@]|C|$]]]|L|$M|$5|N|O|P|C|$Q|4]]|R|$5|N|O|P|C|$Q|S]]]]

<a href="https://stackoverflow.com/a/65141876/5886712">https://stackoverflow.com/a/65141876/5886712</a>
Earlier It was giving error like below when I was using maven dependency , but after using downloaded binary jar files i.e. : &quot;https://poi.apache.org/download.html&quot; of poi of latest version its working fine for me .
<pre><code>Getting error saying : &quot;IncompatibleClassChangeError: Found interface org.apache.poi.util.POILogger, but class was expected
 at org.apache.poi.openxml4j.opc.PackageRelationshipCollection.parseRelationshipsPart(PackageRelationshipCollection.java:303)
 at org.apache.poi.openxml4j.opc.PackageRelationshipCollection.&lt;init&gt;(PackageRelationshipCollection.java:163)
 at org.apache.poi.openxml4j.opc.PackageRelationshipCollection.&lt;init&gt;(PackageRelationshipCollection.java:133)
 at org.apache.poi.openxml4j.opc.PackagePart.loadRelationships(PackagePart.java:570)
 at org.apache.poi.openxml4j.opc.OPCPackage.getParts(OPCPackage.java:723)
 at org.apache.poi.openxml4j.opc.OPCPackage.open(OPCPackage.java:302)
 at org.apache.poi.ooxml.util.PackageHelper.open(PackageHelper.java:37)
 at org.apache.poi.xssf.usermodel.XSSFWorkbook.&lt;init&gt;(XSSFWorkbook.java:307)
 at com.glide.platform_ml.regressionTests.classification.ExcelCallTest.readData(ExcelCallTest.java:40)
 at com.glide.platform_ml.regressionTests.classification.ExcelCallTest.main(ExcelCallTest.java:29)
&quot;
</code></pre>

I'm trying to do work upgrading a Java application to handle .xlsx, using a newer POI library than our existing one. I'm having issues similar to those mentioned in the comments to the answer here: <a href="https://stackoverflow.com/questions/4266888/apache-poi-both-xssf-and-hssf-using">Apache POI, using both XSSF and HSSF</a>

I'm pointing the new ss.usermodel, but it keeps telling me it can't resolve the XSSF workbook declaration:

<pre><code>Workbook xlsImport = new XSSFWorkbook();
</code></pre>

I dug through some of their documentation and saw that XSSFWorkbook isn't a part of org.apache.poi.ss.usermodel. It's a part of org.apache.poi.xssf.usermodel.XSSFWorkbook. But there's no poi.xssf for me to import. Am I pointing to the wrong thing? I'm using POI 3.7 Thanks for any help you can provide.

Issues resolving XSSFWorkbook - Java - POI .jar

Java

我正在尝试升级一个Java应用程序来处理.xlsx，使用一个比我们现有的POI库更新的POI库。我遇到了与这里的答案评论中提到的问题类似的问题：我指向了新的ss.usermodel，但它一直告诉我它无法解析XSSF工作簿声明：Workbook xlsImport = new XSSFWorkbook();我深入研究了他们的一些文档，发现XSSFWorkbook不是org.apache.poi.ss

问问题解决XSSFWorkbook - Java - POI .jar
EN

回答 6

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问问题解决XSSFWorkbook - Java - POI .jarEN

回答 6

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问问题解决XSSFWorkbook - Java - POI .jar
EN