package test;
import java.io.FileInputStream;
import java.io.IOException;
import org.apache.poi.xssf.usermodel.XSSFRow;
import org.apache.poi.xssf.usermodel.XSSFSheet;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;
public class DatadrivenRegisTtest {
public static void main(String[] args) throws IOException {
FileInputStream file=new FileInputStream("D:\\test.xlsx");
XSSFWorkbook wb= new XSSFWorkbook(file);
XSSFSheet sheet=wb.getSheet("Sheet1");
int noofrow=sheet.getLastRowNum();
System.out.println("no of rows in the xl sheet:" + noofrow);
for(int row=0; row<=noofrow; row++) {
XSSFRow currentrow=sheet.getRow(row);
String Fis_name=currentrow.getCell(0).toString();
// String Last_nam=currentrow.getCell(1).getStringCellValue();
System.out.print(Fis_name);
}
}
}