blocks|key|1980054|text|要使OOXML正常工作，您需要POI-OOXML+jar，它是与POI+jar分开打包的。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1980055|从以下位置下载POI-OOXML+jar+-|1980056|http://repo1.maven.org/maven2/org/apache/poi/poi-ooxml/3.11/poi-ooxml-3.11.jar|offset|length|1980057|对于Maven2，添加以下依赖项-|1980058|<dependency>
++++<groupId>org.apache.poi</groupId>
++++<artifactId>poi-ooxml</artifactId>
++++<version>3.11</version>
</dependency>|code-block|syntax|javascript|1980059|entityMap|0|LINK|mutability|MUTABLE|url^0|0|0|0|26|0|0|0|0^^$0|@$1|2|3|4|5|6|7|V|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|W|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|X|8|@]|9|@$F|Y|G|Z|1|10]]|A|$]]|$1|H|3|I|5|6|7|11|8|@]|9|@]|A|$]]|$1|J|3|K|5|L|7|12|8|@]|9|@]|A|$M|N]]|$1|O|3|-4|5|6|7|13|8|@]|9|@]|A|$]]]|P|$Q|$5|R|S|T|A|$U|E]]]]

For OOXML to work you need the POI-OOXML jar which is separately packaged from the POI jar.

Download the POI-OOXML jar from the following location -

<a href="http://repo1.maven.org/maven2/org/apache/poi/poi-ooxml/3.11/poi-ooxml-3.11.jar" rel="noreferrer">http://repo1.maven.org/maven2/org/apache/poi/poi-ooxml/3.11/poi-ooxml-3.11.jar</a>

For Maven2 add the below dependency -

<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.11&lt;/version&gt;
&lt;/dependency&gt;
</code></pre>

blocks|key|1980164|text|OOXML文件格式(比如.xlsx的XSSF+)的类在不同的Jar文件中。您需要在项目中包含poi-ooxml+jar，以及它的依赖项。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1980165|您可以在POI网站here上获取所有组件及其依赖项的列表。|offset|length|1980166|您可能想要做的是下载3.11+binary+package，从中获取poi-ooxml+jar，以及ooxml-lib目录中的依赖项。将它们导入到您的项目中，您就可以进行排序了。|style|CODE|1980167|或者，如果您使用Maven，您可以使用see+here获取您想要依赖的工件列表，但它可能如下所示：|1980168|<dependency>
+++<groupId>org.apache.poi</groupId>
+++<artifactId>poi-ooxml</artifactId>
+++<version>3.11</version>
</dependency>|code-block|syntax|javascript|1980169|poi-ooxml+maven依赖项将自动为您拉入主POI+jar和依赖项。如果希望使用非电子表格格式，还需要依赖于POI+components+page中详细介绍的poi-scratchpad工件|1980170|entityMap|0|LINK|mutability|MUTABLE|url|http://poi.apache.org/overview.html#components|1|http://poi.apache.org/download.html|2|3^0|0|9|4|0|0|Y|9|1E|9|A|J|1|0|J|8|2|0|0|2B|E|1M|J|3|0^^$0|@$1|2|3|4|5|6|7|14|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|15|8|@]|9|@$D|16|E|17|1|18]]|A|$]]|$1|F|3|G|5|6|7|19|8|@$D|1A|E|1B|H|I]|$D|1C|E|1D|H|I]]|9|@$D|1E|E|1F|1|1G]]|A|$]]|$1|J|3|K|5|6|7|1H|8|@]|9|@$D|1I|E|1J|1|1K]]|A|$]]|$1|L|3|M|5|N|7|1L|8|@]|9|@]|A|$O|P]]|$1|Q|3|R|5|6|7|1M|8|@$D|1N|E|1O|H|I]]|9|@$D|1P|E|1Q|1|1R]]|A|$]]|$1|S|3|-4|5|6|7|1S|8|@]|9|@]|A|$]]]|T|$U|$5|V|W|X|A|$Y|Z]]|10|$5|V|W|X|A|$Y|11]]|12|$5|V|W|X|A|$Y|Z]]|13|$5|V|W|X|A|$Y|Z]]]]

The classes for the OOXML file formats (such as XSSF for .xlsx) are in a different Jar file. You need to include the poi-ooxml jar in your project, along with the dependencies for it

You can get a list of all the components and their dependencies on the POI website <a href="http://poi.apache.org/overview.html#components" rel="noreferrer">here</a>.

What you probably want to do is download the <a href="http://poi.apache.org/download.html" rel="noreferrer">3.11 binary package</a>, grab the <code>poi-ooxml</code> jar from it, and the dependencies in the <code>ooxml-lib</code> directory. Import these into your project and you'll be sorted. 

Alternately, if you use Maven, you can <a href="http://poi.apache.org/overview.html#components" rel="noreferrer">see here</a> for the list of the artificats you'll want to depend on, but it'd want to be something like:

<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.11&lt;/version&gt;
&lt;/dependency&gt;
</code></pre>

The poi-ooxml maven dependency will pull in the main POI jar and the dependencies for you automatically. If you want to work with the non-spreadsheet formats, you'd also want to depend on the <code>poi-scratchpad</code> artifact too, as detailed on the <a href="http://poi.apache.org/overview.html#components" rel="noreferrer">POI components page</a>

blocks|key|1766785|text|1)从POI文件夹导入所有JARS+2)从POI文件夹的子目录ooxml文件夹导入所有JARS+3)从POI文件夹的子目录lib文件夹导入所有JARS|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1766786|String+fileName+=+"C:/File+raw.xlsx";
File+file+=+new+File(fileName);
FileInputStream+fileInputStream;
Workbook+workbook+=+null;
Sheet+sheet;
Iterator<Row>+rowIterator;
try+{
++++++++fileInputStream+=+new+FileInputStream(file);
++++++++String+fileExtension+=+fileName.substring(fileName.indexOf("."));
++++++++System.out.println(fileExtension);
++++++++if(fileExtension.equals(".xls")){
++++++++workbook++=+new+HSSFWorkbook(new+POIFSFileSystem(fileInputStream));
++++++++}
++++++++else+if(fileExtension.equals(".xlsx")){
++++++++workbook++=+new+XSSFWorkbook(fileInputStream);
++++++++}
++++++++else+{
++++++++System.out.println("Wrong+File+Type");
++++++++}+
++++++++FormulaEvaluator+evaluator+workbook.getCreationHelper().createFormulaEvaluator();
++++++++sheet+=+workbook.getSheetAt(0);
++++++++rowIterator+=+sheet.iterator();
++++++++while(rowIterator.hasNext()){
++++++++Row+row+=+rowIterator.next();
++++++++Iterator<Cell>+cellIterator+=+row.cellIterator();
++++++++while+(cellIterator.hasNext()){
++++++++Cell+cell+=+cellIterator.next();
++++++++//Check+the+cell+type+after+evaluating+formulae
+++++++//If+it+is+formula+cell,+it+will+be+evaluated+otherwise+no+change+will+happen
++++++++switch+(evaluator.evaluateInCell(cell).getCellType()){
++++++++case+Cell.CELL_TYPE_NUMERIC:
++++++++System.out.print(cell.getNumericCellValue()+%2B+"+");
++++++++break;
++++++++case+Cell.CELL_TYPE_STRING:
++++++++System.out.print(cell.getStringCellValue()+%2B+"+");
++++++++break;
++++++++case+Cell.CELL_TYPE_FORMULA:
++++++++Not+again
++++++++break;
++++++++case+Cell.CELL_TYPE_BLANK:
++++++++break;
++++++++}
}
+System.out.println("\n");
}
//System.out.println(sheet);
}+catch+(FileNotFoundException+e)+{
//+TODO+Auto-generated+catch+block
e.printStackTrace();
}+catch+(IOException+e){
e.printStackTrace();
}​|code-block|syntax|javascript|1766787|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|$]]

1) imported all the JARS from POI folder
2) Imported all the JARS from ooxml folder which a subdirectory of POI folder
3) Imported all the JARS from lib folder which is a subdirectory of POI folder

<pre><code>String fileName = "C:/File raw.xlsx";
File file = new File(fileName);
FileInputStream fileInputStream;
Workbook workbook = null;
Sheet sheet;
Iterator&lt;Row&gt; rowIterator;
try {
 fileInputStream = new FileInputStream(file);
 String fileExtension = fileName.substring(fileName.indexOf("."));
 System.out.println(fileExtension);
 if(fileExtension.equals(".xls")){
 workbook = new HSSFWorkbook(new POIFSFileSystem(fileInputStream));
 }
 else if(fileExtension.equals(".xlsx")){
 workbook = new XSSFWorkbook(fileInputStream);
 }
 else {
 System.out.println("Wrong File Type");
 } 
 FormulaEvaluator evaluator workbook.getCreationHelper().createFormulaEvaluator();
 sheet = workbook.getSheetAt(0);
 rowIterator = sheet.iterator();
 while(rowIterator.hasNext()){
 Row row = rowIterator.next();
 Iterator&lt;Cell&gt; cellIterator = row.cellIterator();
 while (cellIterator.hasNext()){
 Cell cell = cellIterator.next();
 //Check the cell type after evaluating formulae
 //If it is formula cell, it will be evaluated otherwise no change will happen
 switch (evaluator.evaluateInCell(cell).getCellType()){
 case Cell.CELL_TYPE_NUMERIC:
 System.out.print(cell.getNumericCellValue() + " ");
 break;
 case Cell.CELL_TYPE_STRING:
 System.out.print(cell.getStringCellValue() + " ");
 break;
 case Cell.CELL_TYPE_FORMULA:
 Not again
 break;
 case Cell.CELL_TYPE_BLANK:
 break;
 }
}
 System.out.println("\n");
}
//System.out.println(sheet);
} catch (FileNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (IOException e){
e.printStackTrace();
}​
</code></pre>

blocks|key|1766813|text|您没有描述环境，不管怎样，您应该下载apache+poi库。如果你正在使用eclipse，右击你的根项目，那么properties和在java+build+path中添加外部jar，并将这些库导入到你的项目中：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1766814|xmlbeans-2.6.0；poi-ooxml-schemas-+...；poi-ooxml-+...；poi-+....；|1766815|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|F|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|G|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|H|8|@]|9|@]|A|$]]]|E|$]]

You did not described the environment, anyway, you should download apache poi libraries. If you are using eclipse , right click on your root project , so properties and in java build path add external jar and import in your project those libraries : 

xmlbeans-2.6.0 ; poi-ooxml-schemas- ... ; poi-ooxml- ... ; poi- .... ;

blocks|key|1980401|text|问题:导入“org.apache.poi.xssf.usermodel.XSSFWorkbook"class在eclipse中显示错误。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1980402|解决方案:使用这个maven依赖来解决这个问题：|1980403|<dependency>
+++<groupId>org.apache.poi</groupId>
+++<artifactId>poi-ooxml</artifactId>
+++<version>3.15</version>
</dependency>|code-block|syntax|javascript|1980404|-Hari+Krishna+Neela|1980405|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|N|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|O|8|@]|9|@]|A|$G|H]]|$1|I|3|J|5|6|7|P|8|@]|9|@]|A|$]]|$1|K|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|L|$]]

Problem: While importing the " org.apache.poi.xssf.usermodel.XSSFWorkbook"class showing an error in eclipse.

Solution: Use This maven dependency to resolve this problem:

<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.15&lt;/version&gt;
&lt;/dependency&gt;
</code></pre>

-Hari Krishna Neela

blocks|key|1766965|text|我也遇到了同样的问题，所以我翻遍了poi-3.17.jar文件，里面没有xssf包。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1766966|然后，我查看了其他文件，在poi-ooxml-3.17.jar中找到了xssf|1766967|所以看起来解决方案是添加|1766968|poi-ooxml-3.17.jar|code-block|syntax|javascript|1766969|你的项目，因为这似乎使它工作(至少对我)|1766970|entityMap^0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|O|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|P|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|Q|8|@]|9|@]|A|$]]|$1|F|3|G|5|H|7|R|8|@]|9|@]|A|$I|J]]|$1|K|3|L|5|6|7|S|8|@]|9|@]|A|$]]|$1|M|3|-4|5|6|7|T|8|@]|9|@]|A|$]]]|N|$]]

I had the same problem, so I dug through the poi-3.17.jar file and there was no xssf package inside.

I then went through the other files and found xssf int the poi-ooxml-3.17.jar

So it seems the solutions is to add

<pre><code>poi-ooxml-3.17.jar
</code></pre>

to your project, as that seems to make it work (for me at least)

blocks|key|1980500|text|我在app+"build.gradle“中添加了以下内容|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1980501|implementation+'org.apache.poi:poi:4.0.0'
implementation+'org.apache.poi:poi-ooxml:4.0.0'|code-block|syntax|javascript|1980502|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|$]]

I added below contents in app "build.gradle"

<pre><code>implementation 'org.apache.poi:poi:4.0.0'
implementation 'org.apache.poi:poi-ooxml:4.0.0'
</code></pre>

blocks|key|1767093|text|经过多次尝试之后，真正起作用的是:+1.手动下载"poi“和"poi-ooxml”2.将这些d/w+jar添加到"Maven+Dependencies“中|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1767094|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|$]]

After trying multiple things,what really worked was:
1. downloading "poi" and "poi-ooxml" manually
2.Adding these d/w jars into "Maven Dependencies"

blocks|key|1767161|text|06.11.2021天的实际：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1767162|<dependency>
++++<groupId>org.apache.poi</groupId>
++++<artifactId>poi</artifactId>
++++<version>5.1.0</version>
</dependency>

<dependency>
++++<groupId>org.apache.poi</groupId>
++++<artifactId>poi-ooxml</artifactId>
++++<version>5.1.0</version>
</dependency>|code-block|syntax|javascript|1767163|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|$]]

Actual for 06.11.2021 days:
<pre><code>&lt;dependency&gt;
 &lt;groupId&gt;org.apache.poi&lt;/groupId&gt;
 &lt;artifactId&gt;poi&lt;/artifactId&gt;
 &lt;version&gt;5.1.0&lt;/version&gt;
&lt;/dependency&gt;

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

I am referencing the version 3.7 of the Apache POI and I am getting a "cannot be resolved" error when I do:

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

Other import statements that reference POI DO NOT give me errors, such as:

<pre><code>import org.apache.poi.ss.usermodel.*;
</code></pre>

Any ideas??

Cannot import XSSF in Apache POI

我引用了Apache POI的3.7版本，当我这样做时，我得到了一个"cannot be resolved“错误：import org.apache.poi.xssf.usermodel.XSSFWorkbook;引用POI的其他导入语句不会显示错误，例如：import org.apache.poi.ss.usermo...

问无法在Apache POI中导入XSSF
EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问无法在Apache POI中导入XSSFEN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问无法在Apache POI中导入XSSF
EN