About POI in Java

[atma...@gmail.com]

What is the abbreviation of POI in Java and how it works? can I get help from anybody? 

[Venkatesh Nagilla]

Apache POI library is used to read and write into an excel sheet. 

classes used during Excel Read and Write.

1. HSSF is prefixed before the class name to indicate operations related to a Microsoft Excel 2003 file.
2. XSSF is prefixed before the class name to indicate operations related to a Microsoft Excel 2007 file or later.
3. XSSFWorkbook and HSSFWorkbook are classes which act as an Excel Workbook
4. HSSFSheet and XSSFSheet are classes which act as an Excel Worksheet
5. Row defines an Excel row
6. Cell defines an Excel cell addressed in reference to a row.
   

  Apache POI library is easily available using Maven Dependencies.

<dependency>
  <groupId>org.apache.poi</groupId>
  <artifactId>poi-ooxml</artifactId>
  <version>3.15</version>
</dependency>