exception while reading Excel file with apache poi

Question

Problem reading Excel 2007 file .xlsx file extention, while I am trying to read with apache poi:

InputStream file = new FileInputStream(C:\\test.xlsx);

---> XSSFWorkbook workbook = new XSSFWorkbook(file);

This line giving me an exception Exception in thread "main" java.lang.NoClassDefFoundError: org/apache/xmlbeans/XmlObject please, what can be cause of this error?

you have not included a library in your class path.

Abubakkar
– Abubakkar

2012-10-24 10:04:56 +00:00
Commented Oct 24, 2012 at 10:04 — Abubakkar
– Abubakkar, Commented Oct 24, 2012 at 10:04

Abubakkar · Accepted Answer · 2012-10-24 10:08:39Z

14

you need to include a jar file named xmlbeans-x.x.x.jar that comes under folder "your_location_of_poi\poi-x.x\ooxml-lib\" in your classpath.

Note: x.x is the version of poi that you are using and x.x.x is the version number of that jar file under the above mentioned folder

answered Oct 24, 2012 at 10:08

Abubakkar

15.7k8 gold badges58 silver badges84 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Marius Over a year ago

you can download that jar file from here java2s.com/Code/Jar/x/Downloadxmlbeansjar.htm by the way. Scroll down for other versions.

iltaf khalid Over a year ago

I am using a Linux virtual machine where Office is not installed. I have created a Swing Application for Excel reading. The app works fine in Windows but giving java.lang.ClassNotFoundException: org.apache.xmlbeans.XmlException on Linux VM.

katsu · Accepted Answer · 2012-10-24 10:10:26Z

2

You download extra jar file. You can download :

http://www.findjar.com/index.x;jsessionid=D9C61BD4B98370C199118B8C53CC689F?query=org.apache.xmlbeans.XmlObject

answered Oct 24, 2012 at 10:10

katsu

5761 gold badge8 silver badges21 bronze badges

Comments

awm · Accepted Answer · 2012-10-24 10:05:09Z

1

You're missing the extra jar files that come with POI. Include them in your classpath.

answered Oct 24, 2012 at 10:05

awm

2,7682 gold badges20 silver badges26 bronze badges

Comments

Dan D. · Accepted Answer · 2012-10-24 10:04:41Z

0

You don't have XMLBeans in your classpath.

answered Oct 24, 2012 at 10:04

Dan D.

32.4k6 gold badges66 silver badges81 bronze badges

Comments

Ramesh · Accepted Answer · 2015-04-01 07:28:43Z

0

I downloaded xmlbeans.jar and added to Library as External Jar. It resolved my issue.

answered Apr 1, 2015 at 7:28

Ramesh

1

Collectives™ on Stack Overflow

exception while reading Excel file with apache poi

5 Answers 5

2 Comments

Comments

Comments

Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

2 Comments

Comments

Comments

Comments

Comments

Linked

Related