Fetch the given excel using FileInputStream. Get the workbook using XSSFWorkbook and fetch the required sheet as XSSFSheet object. Iterator the row with XSSFSheet. rowIterator() and then iterate the corresponding cells with Row.

What is selenium XSSFWorkbook?

XSSFWorkbook: Is a class representation of XLSX file. HSSFWorkbook: Is a class representation of XLS file. Sheet: XSSFSheet and HSSFSheet classes implement this interface. XSSFSheet: Is a class representing a sheet in an XLSX file.

What is XSSFWorkbook class?

public class XSSFWorkbook extends POIXMLDocument implements Workbook, Date1904Support. High level representation of a SpreadsheetML workbook. This is the first object most users will construct whether they are reading or writing a workbook. It is also the top level object for creating new sheets/etc.