Required maven dependencies for Apache POI to work

Question

I want to use Apache POI library to parse excel files  old versions and newer versions of excel   So I was wondering what jars do i need to include from the Apache POI because in following link   http   mvnrepository com artifact org apache poi  I found lots of jars to be included  do I need to include them all   If so  what is the latest stable version to be included  and does it work with Microsoft s Office 2010

User · Answer

Add this dependency to work with Apache POI   lt dependency gt       lt groupId gt org apache poi lt  groupId gt       lt artifactId gt poi lt  artifactId gt       lt version gt 3 16-beta1 lt  version gt    lt  dependency gt

User · Answer

No  you don t have to include all of POI s dependencies   Maven s transitive dependency mechanism will take care of that   As noted you just have to express a dependency on the appropriate POI artifact   For example   lt dependency gt       lt groupId gt org apache poi lt  groupId gt       lt artifactId gt poi-ooxml lt  artifactId gt       lt version gt 3 8-beta4 lt  version gt   lt  dependency gt   Edit UPDATE   I don t know about previous versions but to resolve imports to XSSFWorkbook and other classes in org apache poi package you need to add dependency for poi-ooxml too  The dependencies will be   lt dependency gt       lt groupId gt org apache poi lt  groupId gt       lt artifactId gt poi lt  artifactId gt       lt version gt 4 1 2 lt  version gt   lt  dependency gt   lt dependency gt       lt groupId gt org apache poi lt  groupId gt       lt artifactId gt poi-ooxml lt  artifactId gt       lt version gt 4 1 2 lt  version gt   lt  dependency gt

User · Answer

The following works for me    lt  -- https   mvnrepository com artifact org apache poi poi -- gt       lt dependency gt           lt groupId gt org apache poi lt  groupId gt           lt artifactId gt poi lt  artifactId gt           lt version gt 3 16 lt  version gt       lt  dependency gt       lt  -- https   mvnrepository com artifact org apache poi poi-ooxml -- gt       lt dependency gt           lt groupId gt org apache poi lt  groupId gt           lt artifactId gt poi-ooxml lt  artifactId gt           lt version gt 3 16 lt  version gt       lt  dependency gt

User · Answer

ooxml for dealing the  xlsx files and the ooxml refers to the xml  hence we will be needed to refer the below three dependedncies in the pom xml for the    lt dependency gt      lt groupId gt org apache poi lt  groupId gt      lt artifactId gt poi lt  artifactId gt      lt version gt 3 9 lt  version gt   lt  dependency gt   lt dependency gt      lt groupId gt xml-apis lt  groupId gt      lt artifactId gt xml-apis lt  artifactId gt      lt version gt 1 4 01 lt  version gt   lt  dependency gt   lt dependency gt      lt groupId gt org apache poi lt  groupId gt      lt artifactId gt poi-ooxml lt  artifactId gt      lt version gt 3 9 lt  version gt      lt exclusions gt        lt exclusion gt          lt artifactId gt xml-apis lt  artifactId gt          lt groupId gt xml-apis lt  groupId gt        lt  exclusion gt             lt  exclusions gt   lt  dependency gt

User · Answer

lt dependency gt           lt groupId gt org apache poi lt  groupId gt           lt artifactId gt poi-ooxml lt  artifactId gt           lt version gt 3 10-FINAL lt  version gt       lt  dependency gt

User · Answer

For an excel writer you might need the following                lt dependency gt                 lt groupId gt org apache poi lt  groupId gt                 lt artifactId gt poi lt  artifactId gt                 lt version gt 3 10-FINAL lt  version gt              lt  dependency gt             lt dependency gt                lt groupId gt org apache poi lt  groupId gt               lt artifactId gt poi-ooxml lt  artifactId gt               lt version gt   apache poi version  lt  version gt          lt  dependency gt

User · Answer

this is the list of maven artifact id for all poi component  in this link http   poi apache org overview html components

User · Answer

I used the below dependency  If you are using Selenium then it s good to use all of them as below  Else you will see some errors and then do the reserch and add some more dependencies    lt dependency gt                    lt groupId gt org apache poi lt  groupId gt                    lt artifactId gt poi lt  artifactId gt                    lt version gt 3 9 lt  version gt             lt  dependency gt             lt dependency gt                    lt groupId gt org apache poi lt  groupId gt                    lt artifactId gt poi-ooxml lt  artifactId gt                    lt version gt 3 9 lt  version gt             lt  dependency gt             lt dependency gt                    lt groupId gt org apache poi lt  groupId gt                    lt artifactId gt poi-ooxml-schemas lt  artifactId gt                    lt version gt 3 9 lt  version gt             lt  dependency gt             lt dependency gt                    lt groupId gt org apache poi lt  groupId gt                    lt artifactId gt poi-scratchpad lt  artifactId gt                    lt version gt 3 9 lt  version gt             lt  dependency gt             lt dependency gt                    lt groupId gt org apache poi lt  groupId gt                    lt artifactId gt ooxml-schemas lt  artifactId gt                    lt version gt 1 1 lt  version gt             lt  dependency gt              lt dependency gt                    lt groupId gt org apache poi lt  groupId gt                    lt artifactId gt openxml4j lt  artifactId gt                    lt version gt 1 0-beta lt  version gt             lt  dependency gt

User · Answer

There are multiple jars which are required for your APACHE POI to work with your application   List of JAR file -   poi-4 1 0 poi-ooxml-4 1 0 commons-collections4-4 3 commons-compress-1 18 xmlbeans-3 1 0 poi-ooxml-schemas-3 9 dom4j-1 6 1

User · Answer

If you are not using maven  then you will need      poi poi-ooxml xmlbeans dom4j poi-ooxml-schemas stax-api ooxml-schemas

User · Answer

Add these dependencies to your maven pom xml   It will take care of all of the imports including OPCpackage  lt dependency gt       lt groupId gt org apache poi lt  groupId gt       lt artifactId gt poi lt  artifactId gt       lt version gt 4 1 2 lt  version gt   lt  dependency gt   lt dependency gt       lt groupId gt org apache poi lt  groupId gt       lt artifactId gt poi-ooxml lt  artifactId gt       lt version gt 4 1 2 lt  version gt   lt  dependency gt

[java] Required maven dependencies for Apache POI to work

Examples related to java

Examples related to maven

Examples related to apache-poi