{"id":79146,"date":"2020-06-20T09:00:32","date_gmt":"2020-06-20T03:30:32","guid":{"rendered":"https:\/\/techvidvan.com\/tutorials\/?p=79146"},"modified":"2020-06-20T09:00:32","modified_gmt":"2020-06-20T03:30:32","slug":"read-write-excel-file-in-java","status":"publish","type":"post","link":"https:\/\/techvidvan.com\/tutorials\/read-write-excel-file-in-java\/","title":{"rendered":"How to Read Excel File in Java Using POI"},"content":{"rendered":"

In this TechVidvan Java Tutorial<\/strong>, we are going to learn how we can read excel file in java<\/strong>. In Java, reading excel files is not similar to reading word files because of cells in excel files.<\/p>\n

JDK does not provide a direct API to read or write Microsoft Excel or Word documents. We have to rely on the third-party library that is Apache POI. In this article, we will learn how to create and write to an excel file using Apache POI.<\/p>\n

Reading and writing Excel Files in Java<\/h3>\n

The people all over the world use excel files (spreadsheets) for various tasks related to organization, analysis, and storage of tabular data. Since these excel files are so common, the developers often face some use-cases when we need to read data from an excel file or generate a report in excel format.<\/p>\n

Apache POI (Poor Obfuscation Implementation) is a Java API for reading and writing Microsoft Documents in both formats .xls and .xlsx. It contains classes and interfaces.<\/p>\n

Apache POI Library<\/h3>\n

The Apache POI library provides two implementations for reading excel files:<\/p>\n

1. HSSF (Horrible SpreadSheet Format) Implementation<\/h4>\n

It denotes an API that is working with Excel 2003 or earlier versions. There are interfaces of HSSF implementations which are HSSFWorkbook, HSSFSheet, HSSFRow, and HSSFCell. We use these interfaces work with excel files of the older binary file format – .xls<\/p>\n

2. XSSF (XML SpreadSheet Format) Implementation<\/h4>\n

It denotes an API that is working with Excel 2007 or later versions. We can use the XSSF implementation to work with the newer XML based file format – .xlsx.<\/p>\n

\"Apache<\/a><\/p>\n

Interfaces and Classes in Apache POI<\/h3>\n

Below are various interfaces in POI:<\/p>\n

1. Workbook:<\/strong> It represents an Excel Workbook<\/strong>. It is an interface implemented by HSSFWorkbook and XSSFWorkbook.<\/strong><\/p>\n

2. Sheet:<\/strong> It is an interface that represents an Excel worksheet<\/strong>. A sheet is a central structure of a workbook, which represents a grid of cells. The Sheet interface extends java.lang.Iterable.<\/strong><\/p>\n

3. Row:<\/strong> It is also an interface that represents the row of the spreadsheet. The Row interface extends java.lang.Iterable<\/strong>. There are two concrete classes: HSSFRow<\/strong> and XSSFRow<\/strong>.<\/p>\n

4. Cell:<\/strong> It is an interface. It is a high-level representation of a cell in a row of the spreadsheet. HSSFCell<\/strong> and XSSFCell<\/strong> implement the Cell interface<\/p>\n

Steps to Read Data from XLS file<\/h3>\n

1.<\/strong>\u00a0Create a simple Java project in eclipse.<\/p>\n

2.<\/strong>\u00a0Now, create a lib folder in the project.<\/p>\n

3.<\/strong>\u00a0Download and add the following jar files in the lib folder:<\/p>\n