Everything you need to talk and write about us

Salesforce MVPs, Ninja series Blogs

Read Excel data from .xls and .xlsx file using POI

Posted by Shashikant Pandey

We all know the importance of a file and how frequently we use it, for example, either we create a new file, update or delete something from it. Selenium helps to automate file manipulation, so in this blog, we will learn how to install the POI jar file and how to perform the read operation on excel with the help of JAVA IO package and APACHE POI library. Note : For .XLS file read write, we can use .JXL jar file. However, it will not support .xlsx file. Step 1. If you do not use Eclipse, then the first and

Read More