How to read data from Excel in Selenium tests using Apache POI? скачать в хорошем качестве

How to read data from Excel in Selenium tests using Apache POI?

While reading the Excel file, Apache POI can read data in two ways: You want to read the value of a particular cell, for instance, you want to get the address of the student present in the second row. You can read the entire excel in one go. It is based upon the need for your test script and the data needed for test execution. The first step is to obtain the Excel Workbook based upon its location on the computer. You can create an object of the workbook by referring to the FileInputStream object that points to the excel file. We can do it as shown below using the HSSFWorkbook Class. If you are using MS-Office versions 97–2003 or XSSFWorkbook Class if MS-Office versions 2007 or later. In the below line, we use HSSFWorkbook as an Excel version is 97-2003.