forked from naveenanimation20/SeleniumJavaCourse
-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathTestUtil.java
More file actions
44 lines (27 loc) · 1.31 KB
/
TestUtil.java
File metadata and controls
44 lines (27 loc) · 1.31 KB
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
package com.test.utility;
import java.util.ArrayList;
import com.excel.utility.Xls_Reader;
public class TestUtil {
static Xls_Reader reader;
public static ArrayList<Object[]> getDataFromExcel(){
ArrayList<Object[]> myData = new ArrayList<Object[]>();
try {
reader = new Xls_Reader("/Users/naveenkhunteta/Documents/workspace/MorningSessions/src/com/testdata/HalfEbayTestData.xlsx");
} catch (Exception e) {
e.printStackTrace();
}
for (int rowNum = 2; rowNum <= reader.getRowCount("RegTestData"); rowNum++) {
String firstName = reader.getCellData("RegTestData", "firstname", rowNum);
String lastName = reader.getCellData("RegTestData", "lastname", rowNum);
String address1 = reader.getCellData("RegTestData", "address1", rowNum);
String address2 = reader.getCellData("RegTestData", "address2", rowNum);
String city = reader.getCellData("RegTestData", "city", rowNum);
String state = reader.getCellData("RegTestData", "state", rowNum);
String zipCode = reader.getCellData("RegTestData", "zipcode", rowNum);
String emailAddress = reader.getCellData("RegTestData", "emailaddress", rowNum);
Object ob[] = {firstName, lastName, address1, address2, city, state, zipCode, emailAddress};
myData.add(ob);
}
return myData;
}
}