selenium+c#+读取excel内容

声明：加入Microsoft.Office.Interop.Excel的dll

object missing = System.Reflection.Missing.Value;

Application xlsApp = new Application();

xlsApp.Visible = false;

string filepath = "E:\\case";

    //打开已有文件

Microsoft.Office.Interop.Excel.Workbook xlsBook = xlsApp.Workbooks.Open(filepath, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value);

Worksheet xlsSheet = xlsBook.Sheets[1];

driver.Navigate().GoToUrl(baseURL);

     //读取

Range rang2 = xlsSheet.get_Range("A1", Type.Missing);

driver.FindElement(By.Id("DepartCity1TextBox")).Clear();

       driver.FindElement(By.Id("DepartCity1TextBox")).SendKeys(rang2.Value);