selenium3.141+java数据驱动

webui自动化测试的时候，可以把输入的数据放到Excel里面，这样就不用改代码了，直接改Excel里面的数据就好了。

package framework;

import java.io.File;
import java.io.IOException;
import java.util.ArrayList;

import jxl.Sheet;
import jxl.Workbook;
import jxl.read.biff.BiffException;

public class suibian {
	 //取第row行第column列的数据
		public static String GetExcelColumn(String filepath,int column,int row,String sheetname) throws BiffException, IOException{
			ArrayList list = null;
			Workbook book = Workbook.getWorkbook(new File(filepath));
			Sheet sheet = book.getSheet(sheetname);
			int rows = sheet.getRows();
			list = new ArrayList();
			for(int i=0;i<rows;i++){
				list.add(sheet.getCell(column-1, i).getContents());
			}
			return (String) list.get(row-1);
		}


public static void main(String[] args) throws BiffException, IOException {
	 //取第1行第2列数据
	String key = GetExcelColumn(".\\1.xls",2,1,"Cookie");
	//取第1行第3列数据
	String value = GetExcelColumn(".\\1.xls",3,1,"Cookie");
	System.out.println(key);
	System.out.println(value);
}

}