/**
   * @param fileName  excel文件名
   * @param caseName  sheet名
   */
  public ExcelData(String fileName, String caseName) {
    super();
    this.fileName = fileName;
    this.caseName = caseName;
  }
   /**
   * 獲得excel表中的數(shù)據(jù)
   */
  public Object[][] getExcelData() throws BiffException, IOException {
 
    workbook = Workbook.getWorkbook(new File(getPath()));
    sheet = workbook.getSheet(caseName);
    rows = sheet.getRows();
    columns = sheet.getColumns();
    // 為了返回值是Object[][],定義一個多行單列的二維數(shù)組
    @SuppressWarnings("unchecked")
		HashMap<String, String>[][] arrmap = new HashMap[rows - 1][1];
    // 對數(shù)組中所有元素hashmap進(jìn)行初始化
    if (rows > 1) {
      for (int i = 0; i < rows - 1; i++) {
        arrmap[i][0] = new HashMap<String, String>();
      }
    } else {
      System.out.println("excel中沒有數(shù)據(jù)");
    }
 
    // 獲得首行的列名，作為hashmap的key值
    for (int c = 0; c < columns; c++) {
      String cellvalue = sheet.getCell(c, 0).getContents();
      arrkey.add(cellvalue);
    }
    // 遍歷所有的單元格的值添加到hashmap中
    for (int r = 1; r < rows; r++) {
      for (int c = 0; c < columns; c++) {
        String cellvalue = sheet.getCell(c, r).getContents();
        arrmap[r - 1][0].put(arrkey.get(c), cellvalue);
      }
    }
    return arrmap;
  }
 
  /**
   * 獲得excel文件的路徑
   * @return
   * @throws IOException
   */
  public String getPath() throws IOException {
    File directory = new File(".");
    sourceFile = directory.getCanonicalPath() + "\\src\\source\\"
        + fileName + ".xls";
    return sourceFile;
  }

	public static WebDriver getChromeDriver(String url) {
    //加載Google驅(qū)動
	  //System.setProperty("webdriver.chrome.driver","D:\\java\\chromedriver.exe");
	  System.setProperty("webdriver.chrome.driver",System.getProperties().getProperty("user.dir")+"\\WebDriver\\chromedriver.exe");
	  ChromeOptions options = new ChromeOptions();
	  //通過配置參數(shù)禁止data;的出現(xiàn)
	  options.addArguments("--user-data-dir="+System.getProperties().getProperty("user.home")+"/AppData/Local/Google/Chrome/User Data/Default");
	   //通過配置參數(shù)刪除“您使用的是不受支持的命令行標(biāo)記：--ignore-certificate-errors。穩(wěn)定性和安全性會有所下降。”提示
	  options.addArguments("--start-maximized","allow-running-insecure-content", "--test-type");
	  WebDriver driver = new ChromeDriver(options);
	  driver.manage().timeouts().implicitlyWait(5, TimeUnit.SECONDS);
	  driver.navigate().to(url);
	  return driver;
	}
	public static WebDriver getFireFoxDriver(String url){
		System.setProperty("webdriver.firefox.bin", "D:\\Program Files\\Mozilla Firefox\\firefox.exe");
		// TODO Auto-generated method stub
		WebDriver driver = new FirefoxDriver();
	  //Puts a Implicit wait, Will wait for 10 seconds before throwing exception
		driver.manage().timeouts().implicitlyWait(10, TimeUnit.SECONDS);
	  //Launch website
		driver.navigate().to(url);
		return driver;
	}
	public static WebDriver getIEDriver(String url){
		//System.setProperty("webdriver.ie.driver", "D:\\java\\IE64\\IEDriverServer.exe");
		System.setProperty("webdriver.ie.driver", System.getProperties().getProperty("user.dir")+"\\WebDriver\\IE32\\IEDriverServer.exe");
		DesiredCapabilities capabilities = DesiredCapabilities.internetExplorer();
    capabilities.setCapability(InternetExplorerDriver.INTRODUCE_FLAKINESS_BY_IGNORING_SECURITY_DOMAINS,true);
    capabilities.setPlatform(Platform.WINDOWS);
    capabilities.setCapability("silent", true);
		// TODO Auto-generated method stub
		WebDriver driver = new InternetExplorerDriver(capabilities);
	  //Puts a Implicit wait, Will wait for 10 seconds before throwing exception
		driver.manage().timeouts().implicitlyWait(10, TimeUnit.SECONDS);
	  //Launch website
		driver.navigate().to(url);
		return driver;
	}

@DataProvider(name="action")
  public Object[][] Numbers() throws BiffException, IOException{
		getActionString = actionData.getActionStr(1);//獲取第一個場景的broswer、url、action名
		ExcelData e=new ExcelData("testdata", getActionString.get(2));
    return e.getExcelData();
  }

  @Test(dataProvider="action")
  public void testAction(HashMap<String, String> data) throws BiffException, IOException {
    try {
    	Class<?> MyClass = Class.forName(packageName+"."+getActionString.get(2));
    	Method method = MyClass.getMethod(getActionString.get(2),WebDriver.class);
    	@SuppressWarnings("unused")
					String [] results = (String []) method.invoke(null,driver);
  			String ExpObject=data.get("ExpectedObject");
    	String ExpObject_by=ExpObject.split(";")[0].toString();
    	String ExpObject_Desc=ExpObject.split(";")[1].toString();
    	if(ExpObject_by.length()>0){
    		Assert.assertEquals(driver.findElement(By.id(ExpObject_by)).getText(),data.get("ExpectedData"), getActionString.get(2)+data.get("ID")+"驗證結(jié)果：");
    	}
    	else if(ExpObject_Desc.length()>0){
    		Assert.assertEquals(driver.findElement(By.xpath(ExpObject_Desc)).getText(),data.get("ExpectedData"), getActionString.get(2)+data.get("ID")+"驗證結(jié)果：");
    	}
    	
  		WebDriverDemo.WebSleep(500);	
			} catch (Exception e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
  }

	@DataProvider(name="action")
  public Object[][] Numbers() throws BiffException, IOException{	
		getActionString = actionData.getActionStr(2);//獲取第二個場景的broswer、url、action名
		ExcelData e=new ExcelData("testdata", getActionString.get(2));
    return e.getExcelData();
  }

  @Test(dataProvider="action")
  public void testAction(HashMap<String, String> data) throws BiffException, IOException { 
  	//driver.manage().timeouts().implicitlyWait(5,TimeUnit.SECONDS);//找不到element就再給5秒查找
    try {
    	WebElement TestWebElement = null;
    	String SetObject=data.get("SetObject").trim();
    	String SetObject_by=SetObject.split(";")[0].toString();
    	String SetObject_Desc=SetObject.split(";")[1].toString();
    	if(SetObject_by.length()>0){
    		TestWebElement=driver.findElement(By.id(SetObject_by));
    	}
    	else if(SetObject_Desc.length()>0){
    		TestWebElement=driver.findElement(By.xpath(SetObject_Desc));
    	}
    	if(data.get("SetOperate").equals("sendKeys")){
    		TestWebElement.clear(); 
    		TestWebElement.sendKeys(data.get("SetValue"));
    	}else if(data.get("SetOperate").equals("click")){
    		TestWebElement.click();
    	}
  		String ExpObject=data.get("ExpectedObject").trim();
    	if(ExpObject.length()>0){
    		String ExpObject_by=ExpObject.split(";")[0].toString();
      	String ExpObject_Desc=ExpObject.split(";")[1].toString();
    		if(ExpObject_by.length()>0){
      		Assert.assertEquals(driver.findElement(By.id(ExpObject_by)).getText(),data.get("ExpectedData"), getActionString.get(2)+data.get("ID")+"驗證結(jié)果：");
      	}
      	else if(ExpObject_Desc.length()>0){
      		Assert.assertEquals(driver.findElement(By.xpath(ExpObject_Desc)).getText(),data.get("ExpectedData"), getActionString.get(2)+data.get("ID")+"驗證結(jié)果：");
      	}
    	}
    	
  		WebDriverDemo.WebSleep(500);	
			} catch (Exception e) {
			// TODO Auto-generated catch block
				e.printStackTrace();
			}
  }

<?xml version="1.0" encoding="UTF-8"?> 
<!DOCTYPE suite SYSTEM "http://testng.org/testng-1.0.dtd"> 
<suite name="Suite" parallel="false"> 
 <test verbose="2" name="Test_Action"> 
 	<!--<groups> 
   <run> 
   	<include name="aaa" />
     <include name="bbb" /> 
     <include name="ccc" /> 
    </run> 
  </groups>-->
  <classes> 
   <class name="TestBrowser.ExcActions"/>
   <class name="TestBrowser.ExcActions2"/> 
  </classes> 
 </test> <!-- Default test --> 
</suite> <!-- Default suite -->

<?xml version="1.0" encoding="UTF-8"?>
 
<project name= "TestAction" basedir= "." default="testoutput"><!--default設(shè)置為run表示只執(zhí)行腳本，設(shè)為testoutput表示執(zhí)行完腳本并輸出視圖報告-->
<echo message="import libs" />
<property name= "lib.dir" value= "lib" /> <!--<property name="libdir" location="${basedir}/lib" />-->
<!--<property name="testng.output.dir" location="${basedir}/test-output" />-->
<path id= "test.classpath" >
 
<!-- adding the saxon jar to your classpath -->
 
<fileset dir= "${lib.dir}" includes= "*.jar" />
 <fileset dir="${basedir}/selenium-2.44.0">
  <include name="selenium-java-2.44.0.jar" />
  <include name="libs/*.jar" />
 </fileset>
 
</path>
<taskdef name="testng" classname="org.testng.TestNGAntTask" classpathref="test.classpath" rel="external nofollow" />
<target name="clean">
	<delete dir="build"/>
</target>
<target name="compile" depends="clean">
<echo message="mkdir"/>
 <mkdir dir="build/classes"/>
 <javac srcdir="src" destdir="build/classes" debug="on" encoding="UTF-8" includeAntRuntime="false">
	<classpath refid="test.classpath"/>
	</javac>
</target>
<path id="runpath"> 
	<path refid="test.classpath"/> 
	<pathelement location="build/classes"/> 
	</path> 
<target name="run" depends="compile">
	<testng classpathref="runpath" rel="external nofollow"  outputDir="test-output">
		<xmlfileset dir="${basedir}" includes="testng.xml"/>
		<jvmarg value="-ea" />
	</testng>
</target>
<target name= "testoutput" depends="run">
<xslt in= "test-output/testng-results.xml" style= "test-output/testng-results.xsl"
out= "test-output/index1.html" >
<!-- you need to specify the directory here again -->
<param name= "testNgXslt.outputDir" expression= "${basedir}/test-output/" />
	<param name="testNgXslt.showRuntimeTotals" expression="true" />
<classpath refid= "test.classpath" />
</xslt>
</target>
 
</project>

		String[] result=new String [2];
		result[0] = driver.findElement(By.xpath(pars.get(3).split(";")[1].toString())).getText();
		result[1] = pars.get(4);
		if(result[0].equals(result[1])){//pars.size()-1
			ActionsDemo.modifyExcel(Thread.currentThread().getStackTrace()[1].getMethodName(),k,5,"通過");
		} else {
			ActionsDemo.modifyExcel(Thread.currentThread().getStackTrace()[1].getMethodName(),k,5,"失敗");
		}

@echo off
::先將測試用例文件拷到用戶目錄下
copy src\source\testdata.xls %UserProfile%\src\source
%cd%\org.apache.ant_1.9.6\bin\ant.bat -buildfile build.xml
echo 在%cd%\test-output下查看測試報告
pause