import java.io.FileInputStream; import java.io.IOException; import java.io.InputStream; import org.apache.poi.openxml4j.exceptions.InvalidFormatException; import org.apache.poi.ss.usermodel.Row; import org.apache.poi.ss.usermodel.Sheet; import org.apache.poi.ss.usermodel.Workbook; import org.apache.poi.ss.usermodel.WorkbookFactory; public class DatafromExcel { public static void main(String[] args) throws InvalidFormatException, IOException { //initilize fileInputStream and set path of excel file InputStream is=new FileInputStream("G:/Selenium Java Doc/Users/Gtpv/jp/My_Practice/src/DATA.xls"); //Create workbook and access file into Workbook Workbook wb=WorkbookFactory.create(is); //Get sheet by sending sheet id Sheet s=wb.getSheetAt(0); //Get row count int rc=s.getLastRowNum(); //Loop for every Row for(int j=0;j<rc+1;j++) { //Create object for Row and pass which row need to be accessed Row r=s.getRow(j); //Get Column count int cc=r.getLastCellNum(); //Loop to Every cell for(int k=0;k<cc;k++) { //Get Cell data String cellData =r.getCell(k).getStringCellValue(); //Print cell data System.out.print(cellData+" "); } //New Line System.out.println(); } } }