XSSFWorkbook. It is a class that is used to represent both high and low level Excel file formats. It belongs to the org. apache.
How do I use XSSFWorkbook?
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 the difference between workbook and XSSFWorkbook?
Workbook is an interface, while HSSFWorkbook, SXSSFWorkbook, XSSFWorkbook are the clases that are implementing the Workbook interface. public interface Workbook High level representation of a Excel workbook. This is the first object most users will construct whether they are reading or writing a workbook.