About POI in Java

55 views
Skip to first unread message

atma...@gmail.com

unread,
May 4, 2016, 2:07:10 AM5/4/16
to Java Posse
What is the abbreviation of POI in Java and how it works? can I get help from anybody? 

Venkatesh Nagilla

unread,
Apr 25, 2017, 6:30:08 PM4/25/17
to Java Posse
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>
Reply all
Reply to author
Forward
0 new messages