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 Oct 24 '12 at 10:04 — Abubakkar, Oct 24 '12 at 10:04

score 14 · Accepted Answer · answered Oct 24 '12 at 10:08

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 '12 at 10:08

Abubakkar

15,488
8
55
83

you can download that jar file from here http://www.java2s.com/Code/Jar/x/Downloadxmlbeansjar.htm by the way. Scroll down for other versions. – Marius Feb 12 '15 at 10:39
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. – iltaf khalid Feb 02 '16 at 10:06

score 2 · Answer 2 · answered Oct 24 '12 at 10:10

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 '12 at 10:10

katsu

558
1
7
20

score 1 · Answer 3 · answered Oct 24 '12 at 10:05

1

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

answered Oct 24 '12 at 10:05

awm

2,723
2
18
26

score 0 · Answer 4 · answered Oct 24 '12 at 10:04

0

You don't have XMLBeans in your classpath.

answered Oct 24 '12 at 10:04

Dan D.

32,246
5
63
79

score 0 · Answer 5 · answered Apr 01 '15 at 07:28

0

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

answered Apr 01 '15 at 07:28

Ramesh

1

exception while reading Excel file with apache poi

5 Answers5

Linked