I'm fairly new to Selenium WebDriver. I wrote code to read the login credentials and values from the excel sheet by using Data Provider. It runs through the first set up data(login functionality) perfectly giving me the green status bar.
import java.io.File;
import jxl.Sheet;
import jxl.Workbook;
import org.testng.annotations.BeforeSuite;
import org.testng.annotations.DataProvider;
import org.testng.annotations.Test;
import org.junit.AfterClass;
import org.openqa.selenium.WebDriver;
import org.openqa.selenium.firefox.FirefoxDriver;
//import org.testng.annotations.BeforeClass;
public class TestCase {
String[][] tabArray = null;
Workbook workbk;
Sheet sheet;
int rowCount, colCount;
String sheetPath = "test/Resources/Data/Auto_Increment.xls";
WebDriver login;
//int eRow, eCol, sRow = 0, sCol = 0;
@BeforeSuite
public void setUp(){
login = new FirefoxDriver();
login.get("http://etazo.tangosoftware.com");
System.out.println("select the etazo web link..");
}
@DataProvider
public Object[][] getLoginData() throws Exception {
Object[][] retObjArr = getExcelData(sheetPath, "Sheet1");
System.out.println("getData function executed!!");
return retObjArr;
}
// Excel API to read test data from excel workbook
public String[][] getExcelData(String xlPath, String shtName)
throws Exception {
Workbook workbk = Workbook.getWorkbook(new File(xlPath));
Sheet sht = workbk.getSheet(shtName);
rowCount = sht.getRows();
colCount = sht.getColumns();
tabArray = new String[rowCount][colCount - 2];
System.out.println("erow: " + rowCount);
System.out.println("ecol: " + colCount);
for (int i = 0; i < rowCount; i++) {
for (int j = 0; j < 3; j++) {
tabArray[i][j] = sht.getCell(j, i).getContents();
}
}
return (tabArray);
}
@Test(dataProvider = "getLoginData")
public void LoginData(String distID, String asmtId, String studID)
throws InterruptedException, BiffException, IOException {
Administartion(distID, asmtId, studID);
}
public void Administartion(String distID, String asmtId, String studID)
throws BiffException, IOException {
Workbook workbk = Workbook.getWorkbook(new File(sheetPath));
Sheet sht = workbk.getSheet("Sheet1");
int currRow = sht.findCell(studID).getRow();
//login.findElement(By.xpath("//*[@id='question-"+sIndex+"']/bubbles/circle["+sValue+"]")).click();
System.out.println(sht.getCell(3, currRow).getContents() + " Index ");
System.out.println(sht.getCell(4, currRow).getContents() + " Answer selection");
}
}