File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes Other Open Source Projects and the fly likes Reading a .xlsx excel file using XSSF Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of EJB 3 in Action this week in the EJB and other Java EE Technologies forum!
JavaRanch » Java Forums » Products » Other Open Source Projects
Bookmark "Reading a .xlsx excel file using XSSF " Watch "Reading a .xlsx excel file using XSSF " New topic
Author

Reading a .xlsx excel file using XSSF

Christian Teixeira
Greenhorn

Joined: Jan 15, 2013
Posts: 1
Hello, I am trying to create a class which reads an xlsx excel file and counts the number of columns in the file. It uses POI-XSSF, is part of a web-app which runs using jetty, and compiles fine.


However, when it is run, I receive this error when it tries to create the new XSSFWorkbook.

java.lang.NoSuchMethodError: org.apache.poi.xssf.usermodel.XSSFWorkbook.<init>(Ljava/io/InputStream;)V

I have the following JARs on my build path and dependencies for each in my pom.xml file
dom4j-1.6.1
jsr173_1.0_api
poi3.6-20091214
poi-ooxml-3.6-20091214
poi-ooxml-schemas-3.6-20091214
xmlbeans-2.5.0


I have tried downloading many different jar files and nothing seems to get me away from this error.
Help would be much appreciated.
Thanks!
Ulf Dittmer
Marshal

Joined: Mar 22, 2005
Posts: 39547
    
  27
Sounds like you're using two different sets of of jar files for compilation and runtime, respectively. My usual advice would be to forget about Maven and make sure you can compile and run the code using a simpler build method (Ant file, or even without any build tool).


Ping & DNS - updated with new look and Ping home screen widget
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Reading a .xlsx excel file using XSSF
 
Similar Threads
java.lang.NoClassDefFoundError coming while reading .xlsx file in java project
WorkbookFactory.create Throws java.lang.IllegalArgumentException
Read a .xls,.xlsx file format using XSSF
Converting xls to xlsx and XmlValueDisconnectedException on WebLogic 9.2 (poi 3.7)
file Writing problem