O'Reilly logo

Selenium Essentials by Prashanth Sams

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Apache POI Data-Driven framework

Apache Poor Obfuscation Implementation (POI) is a set of Java-based libraries used to manipulate Microsoft Excel documents, such as the .xls and .xlsx file formats. It is an extensive API used to automate Selenium Data-Driven tests that lets you create, modify, read, and write Excel data. Unlike JXL API, it supports both Binary and SpreadsheetML workbooks. Configuring JXL API is easier compared to Apache POI. However, Apache POI has as many features to work with modern Microsoft products. Obviously, the test performance with the .xlsx file will be slower compared to the .xls file in Apache POI.

A dependency of Apache POI is the xmlbeans library, which has to be added in the build path before executing tests. Another ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required