How to read data from excel cell using Apache POI in java

How to read data from excel cell using Apache POI in java

In this post I’m going to show you how to get data from single cell in spreadsheet. I build a customized method which fetch data from cell based on the Column Index number , Row Number, Sheet Number and Path of the excel sheet.

 Let’s see how to do it

Create a new project in Eclipse and name it. Create a new main Class under this project and give a suitable name to it. Add apache POI jars to the current project. If you don’t know how to include Apache POI jars the follow the below steps:

 Add Apache POI jars to project

 1) Go to the URL as http://poi.apache.org/download.html

2) Click on the “poi-bin-<version and date>..zip” or poi-bin-3.14-<Version and date>.tar.gz(Choose this only if you have gz extractor) and download the file

3) Extract the zip file

4) Go to Eclipse and select the project displayed in the Package explorer.

5) Right click the Project name and select Build path->Configure Build Path. Now you can see Java Build path dialog box

6) Go to the Libraries tab and select “Add External Jars”. Open file dialog box will be displayed

7) Navigate to the apache POI extracted folder and add all the jar files inside that folders and sub folders. Click Ok

I’ve created a method with four parameters public Cell getvalue(int colno,int rowno,int shtno,String path) throws IOException and return type as Cell.

 int colno– Give the column number where your cell is present

int rowno– Give the row number where your Cell is present

int shtno- Give the position of the sheet (0,1,2) not the sheet name

String path– Give the location of your excel workbook

Note:Be aware that apache POI indexed by zero which means first row starts with zero, first column starts with zero and first sheet starts with zero.

Example

Let see how to get the data “I’m here”(shown below) present in the sheet 1, first row, second column and exist in the path “D:testtest.xlsx”

public static void main(String[] args) throws IOException

 {

         writeexcel t1=new writeexcel();

         String path=”D:testtest.xlsx”;

         System.out.println(t1.getvalue(2,1, 0, path));

  }

Source Code

One Comment

Leave a Reply