FilesExpand file tree

 master

/

TestUtil.java

Copy path

Blame

More file actions

Blame

More file actions

Latest commit

 

History

History

History

44 lines (27 loc) · 1.31 KB

 master

/

TestUtil.java

Copy path

Top

File metadata and controls

• Code
• Blame

44 lines (27 loc) · 1.31 KB

Raw

Copy raw file

Download raw file

Open symbols panel

Edit and raw actions

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;

}

}