Reading excel using Apache POI

Question

I am reading .xls and .xlsx using Apache POI through Java.

I have included below jars to my classpath:

 1. poi-3.7-20101029.jar
 2. poi-examples-3.7-20101029.jar
 3. poi-ooxml-3.7-20101029.jar
 4. poi-ooxml-schemas-3.7-20101029.jar
 5. poi-scratchpad-3.7-20101029.jar

Are all jars required to read/write data from/to xls/xlsx files? I think I can exclude poi-examples-3.7-20101029.jar as the name suggests it contains examples. I tried that and it works (I am able read from xls/xlsx). What is the minimal set of jars required to read/write data from/to xls/xlsx files?

I want to keep my project size as small as possible, so appreciate if anyone can focus on this.

According to the component overview at the POI site, the poi-version jar does not have another other POI dependancies. poi.apache.org/overview.html — John B
– John B, Commented Oct 21, 2011 at 10:08

Gagravarr · Accepted Answer · 2011-10-21 10:28:28Z

1

If you just want to read/write XLS files, then all you need is the main POI jar. If you want to read/write XLSX files, then you also need the two OOXML jars (plus appropriate XML parser dependencies)

You wouldn't normally need to include the examples Jar. The scratchpad jar is needed for PPT, DOC, VSD etc, along with a small number of experimental XLS features (such as charts).

answered Oct 21, 2011 at 10:28

Gagravarr

48.5k11 gold badges114 silver badges158 bronze badges

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

2 Comments

berto77 Over a year ago

Thank you. I've included every jar mentioned, but I'm still getting the exception: java.lang.reflect.InvocationTargetException

Gagravarr Over a year ago

You should ask a new question then, and post the whole stacktrace

Konstantin Yovkov · Accepted Answer · 2011-10-21 09:59:42Z

1

I think poi-3.7-20101029.jar is enough. :)

answered Oct 21, 2011 at 9:59

Konstantin Yovkov

63k9 gold badges107 silver badges152 bronze badges

Collectives™ on Stack Overflow

Reading excel using Apache POI

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related