![Poi-Scratchpad-3.7.Jar Poi-Scratchpad-3.7.Jar](http://images2015.cnblogs.com/blog/665662/201704/665662-20170420093736868-1825652236.png)
I'm working on program that make Excel data via POI API 3.9. But there are many Jar files in directory as follows. Poi-3.9-20121203 poi-excelant-3.9-20121203 poi-ooxml-3.9-20121203 poi-ooxml-schemas-3.9-20121203 poi-scratchpad-3.9-20121203 ooxml-lib/xmlbeans-2.3.0 lib/commons-logging-1.1.etc. I just need creating, reading and writing excel files.
![Poi-Scratchpad-3.7.Jar Download Poi-Scratchpad-3.7.Jar Download](/uploads/1/2/5/4/125418289/508760434.png)
Download apache-poi-3.7 JAR files with dependency. Search JAR files by class name. Apache-poi from group com.walterjwhite.infrastructure.dependencies (version 0.0.15). Download poi-scratchpad.jar (3.17.0.wso2v1) Add to Project. 86 downloads. Artifact poi-scratchpad Group org.wso2.orbit.org.apache.poi Version 3.17.0.wso2v1 Last update 02.
I'm confused what jar files is need. Please tell me what files i got to import. I have read many domcuments on website. But i'can find it about that. You probably have to import all of them.
As many frameworks, Apache POI is splitted in different libraries. Apache POI also uses external libraries like XML Beans.
On the, you will find the list of components and for which goal there are needed, look at the section. Typically if you are handling only old Excel files, you don't need the poi-ooxml dependency. Note that your list of external dependencies is listed in the Prerequisites column of the second table of the Component Map section, as described there you also need additional libraries: commons-logging, commons-codec, log4j. Finally, to avoid headaches with dependency management, you could use a tool like Maven which cares of this for you. If you use Maven for project build, then you can simply add the following two dependencies on your project -
Is a demo project that I've developed demonstrating the excel reading approach. The above lines are taken from my project pom. This approach works just fine for me.