Read data from Excel:
public String
readExcel(int row, int col, int sno) throws Exception {
File file = new File(
"D:\\TestData\\Test
cases.xls");
Workbook wb = Workbook.getWorkbook(file);
Sheet st = wb.getSheet(sno);
Cell cl = st.getCell(row, col);
String sr = cl.getContents();
return sr;
}
Contributed by Ch. Suma
Contributed by Ch. Suma