What is Apache POI in Selenium and what it is used for

Question

I want to know what is Apache POI and what it is used for in Selenium?

Answer 1

Hi Raj, Apache POI is the most commonly used API for Selenium data driven tests. POI is a set of library files that gives an API to manipulate Microsoft documents like .xls and .xlsx. It is used to create, modify, read and write data into Excel. In POI, Workbook is a common interface for HSSF, XSSF and SXSSF; where HSSF (Horrible Spread Sheet Format) implements Excel ’97 (.xls) file format and XSSF (XML Spread Sheet Format) implements Excel 2007 (.xlsx) file format. SXSSF is the streaming extension for XSSF which was introduced later in Apache POI 3.8. Syntax for using POI in selenium webdriver is:

Workbook wb = new HSSFWorkbook();

Apache POI Jar files can be downloaded from here: https://poi.apache.org/download.html