问如何避免每次需要数据时都引用Excel工作表？
EN

Stack Overflow用户

提问于 2015-09-16 17:39:37

回答 1查看 44关注 0票数 1

我一直致力于构建一个Selenium框架来测试我工作的web应用程序。最近，我一直在尝试使用外部Excel表进行数据驱动测试，以存储CSS元素名称以及用于提交表单等内容的数据。我已经在下面包含了我的代码，正如您可以看到的那样，我正在“调用”Excel来获取我需要的每一点数据。这要花上好长时间了。有没有一种方法可以一次性导入所有数据并“在内存中”执行？

public string getCell(string sheet, string a)
    {
        string workbookPath = @"C:\exceltest.xlsx";

        Excel.Application excelApp;
        Excel.Workbook excelWorkbook;
        Excel.Sheets excelSheets;

        excelApp = new Excel.Application();
        excelWorkbook = excelApp.Workbooks.Add(workbookPath);
        excelSheets = excelWorkbook.Sheets;
        excelWorksheet = (Excel.Worksheet)excelSheets.get_Item(sheet);

        Excel.Range range = excelWorksheet.get_Range(a, a);
        string cell = range.Value.ToString();

        return cell;
    }

    [Test]
    public void addGuest()
    {
        newSession();

        driver.FindElement(By.CssSelector(getCell(css, "B11"))).Click();
        driver.FindElement(By.CssSelector(getCell(css, "B12"))).Click();
        driver.SwitchTo().Window(driver.WindowHandles.Last());

        driver.FindElement(By.CssSelector(getCell(css, "B13"))).SendKeys(getCell(property, "B3"));
        driver.FindElement(By.CssSelector(getCell(css, "B14"))).SendKeys(getCell(property, "B4"));
        driver.FindElement(By.CssSelector(getCell(css, "B15"))).SendKeys(getCell(property, "B5"));
        driver.FindElement(By.CssSelector(getCell(css, "B16"))).SendKeys(getCell(property, "B6"));
        driver.FindElement(By.CssSelector(getCell(css, "B17"))).SendKeys(getCell(property, "B7"));
        driver.FindElement(By.CssSelector(getCell(css, "B18"))).SendKeys(getCell(property, "B8"));
        driver.FindElement(By.CssSelector(getCell(css, "B19"))).SendKeys(getCell(property, "B9"));
        driver.FindElement(By.CssSelector(getCell(css, "B20"))).SendKeys(getCell(property, "B10"));
        driver.FindElement(By.CssSelector(getCell(css, "B21"))).SendKeys(getCell(property, "B11"));
        driver.FindElement(By.CssSelector(getCell(css, "B22"))).SendKeys(getCell(property, "B12"));
        driver.FindElement(By.CssSelector(getCell(css, "B23"))).SendKeys(Keys.Down);
        driver.FindElement(By.CssSelector(getCell(css, "B24"))).SendKeys(Keys.Down);
        driver.FindElement(By.CssSelector(getCell(css, "B25"))).SendKeys(getCell(property, "B13"));
        driver.FindElement(By.CssSelector(getCell(css, "B26"))).SendKeys(getCell(property, "B14"));
        driver.FindElement(By.CssSelector(getCell(css, "B27"))).Click();

    }

    [Test]
    public void newSession()
    {
        string baseURL = "https://website.com";

        string property = "Property";

        //Login
        driver.Navigate().GoToUrl(baseURL);
        driver.FindElement(By.CssSelector(getCell(css, "B1"))).SendKeys(getCell("Sheet1", "A1"));
        driver.FindElement(By.CssSelector(getCell(css, "B2"))).SendKeys(getCell("Sheet1", "B1"));
        driver.FindElement(By.CssSelector(getCell(css, "B3"))).Click();

        //Property>New Session

        driver.FindElement(By.CssSelector(getCell(css, "B4"))).SendKeys(getCell(property, "B1"));
        driver.FindElement(By.CssSelector(getCell(css, "B5"))).Click();
        driver.FindElement(By.CssSelector(getCell(css, "B6"))).Click();
        driver.FindElement(By.CssSelector(getCell(css, "B7"))).Click();

    }

selenium

回答 1

Stack Overflow用户

发布于 2015-09-16 18:22:11

你真的不想像这样使用Excel。您最好只将CSS选择器放入代码中。Excel更适合用于数据验证之类的事情。例如，我在eComm网站上工作(想想amazon.com或任何出售商品的网站)。我在Excel表格中有产品数据...例如产品ids、名称、数量、定价等。我得到了一张特定格式的工作表，我有一个脚本，它一次读取一行，遍历网站并购买该产品，同时验证不同的数据位。每周我都会收到一两张或三张新的表格。这是一个更好的使用Excel，国际海事组织。

我会这样做的..。

public class Test
{
    private By sampleElementLocator = By.cssSelector("sampleId");

    public void addGuest()
    {
        driver.findElement(sampleElementLocator).click();
        ...
    }
}