How to Read data into Excel using Apache POI API?
In this tutorial we are going to understand how to Read data into an excel sheet.
Program to Read data into Excel using Apache POI API
Step 1 : Importing of necessary packages
// package from Fileinput
import java.io.FileInputStream;
// packages from apache POI
import org.apache.poi.xssf.usermodel.XSSFCell;
import org.apache.poi.xssf.usermodel.XSSFRow;
import org.apache.poi.xssf.usermodel.XSSFSheet;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;
Step 2 : To read the data from Excel, we are using FileInputStream
Path refers to location of the excelsheet.
FileInputStream ExcelFile = new FileInputStream(path);
Step 3 : Open the existing workbook instance of xlxs file
XSSFWorkbook ExcelWBook = new XSSFWorkbook(ExcelFile);
Step 4 : Access the existing worksheet of xlsx file, in this instance it is “Sheet1”
XSSFSheet ExcelWSheet = ExcelWBook.getSheet(“Sheet1”);
Step 5 : Setting the Row Number as 2 and Column number as 1
int RowNum = 2;
int ColNum = 1;
Step 6 : Passing the RowNumber and ColumnNumber in the below method.
XSSFCell Cell= ExcelWSheet.getRow(RowNum).getCell(ColNum);
Step 7 : This will return the data from the particular cell and stored in String variable CellData.
String CellData = Cell.getStringCellValue();
Step 8 : Printing the value of CellData
System.out.println(“Get Cell value:::”+CellData);
Program :
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 |
package excel; //list of packages imported import java.io.FileInputStream; import org.apache.poi.xssf.usermodel.XSSFCell; import org.apache.poi.xssf.usermodel.XSSFRow; import org.apache.poi.xssf.usermodel.XSSFSheet; import org.apache.poi.xssf.usermodel.XSSFWorkbook; public class ExcelRows { public static void main(String args[]) throws Exception { String path = “C:\sampleData.xlsx”; // Open the Excel file FileInputStream ExcelFile = new FileInputStream(path); // Access the required test data sheet XSSFWorkbook ExcelWBook = new XSSFWorkbook(ExcelFile); XSSFSheet ExcelWSheet = ExcelWBook.getSheet(“Sheet1”); int RowNum = 2; int ColNum = 1; XSSFCell Cell= ExcelWSheet.getRow(RowNum).getCell(ColNum); String CellData = Cell.getStringCellValue(); System.out.println(“Get Cell value:::”+CellData); } } |