Poi 3.14 Excel Reading Null Pointer Exception | Selenium Forum
M
Posted on 09/09/2016
Hi,

I have faced this issue while doing the Module 20 Core Framework Excel Reading and googled up to find a solution. So, sharing for the benefit of others.

If we are using Poi 3.14 (latest release), we may get Null Pointer exception if we are using older xmlbeans. In order for the project to be without any errors when using Poi 3.14, use the below dependency in your pom.xml

xmlbeans 2.6.0
xml-apis 1.4.01
(even though xml-apis have a latest version of 2.x, we are facing some issue)

http://stackoverflow.com/questions/36063592/exception-in-thread-main-org-apache-poi-poixmlexception-exception-appearing-wh
http://stackoverflow.com/questions/10234201/appengine-error-java-lang-noclassdeffounderror-org-w3c-dom-elementtraversal

M
Replied on 14/09/2016

Please dont use jars from poi site
Download jars from
www.qtpselenium.com/downloads/poi.rar