

xlsx).įor Excel file format 2003 (XLS): HSSFWorkbook, HSSFSheet, HSSFRow, HSSFCell, etc.įor Excel file format 2007 (XLSX): XSSFWorkbook, XSSFSheet, XSSFRow, XSSFCell, etc. And there are specific concrete classes for specific file formats (.xls and. The basic interfaces are Workbook, Sheet, Row, Cell, CellStyle, Font, etc. Let’s see the basic interfaces and classes here: POI library provides various classes and interfaces for reading and writing Excel files. XSSF implementation is provided to read/write the XLSX file. HSSF implementation is provided by the POI to read/write the XLS file. The Apache POI library is capable to read and write both XLS and XLSX file formats of Excel.

Apache POI – API Basics to Read/Write Excel Files.
