This week's giveaway is in the Spring forum.
We're giving away four copies of REST with Spring (video course) and have Eugen Paraschiv on-line!
See this thread for details.
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 REST with Spring (video course) this week in the Spring 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

Reading a .xlsx excel file using XSSF

Christian Teixeira

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

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

Joined: Mar 22, 2005
Posts: 42959
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).
I agree. Here's the link:
subject: Reading a .xlsx excel file using XSSF
It's not a secret anymore!