1.下载 jxl.jar 复制到测试项目的 lib 下,在项目中新建数据驱动类
ExcelData.java
package com.annie;
import java.io.File;
import java.util.Iterator;
import java.util.Map;
import java.util.TreeMap;
import java.util.regex.Matcher;
import jxl.*;
public class ExcelData implements Iterator<Object[]> {
private Workbook book = null;
private Sheet sheet = null;
private int rowNum = 0;//行数
private int curRowNo = 0;//当前行数
private int columnNum = 0;//列数
private String[] columnnName;//列名
/*在TestNG中,由@Dat