在Selenium C#中从Excel读取数据 [英] Reading data from excel in selenium C#

问题描述

我正在尝试在C#.NET中使用Selenium时从excel工作表中读取用户名和密码.下面是代码:

I'm trying to read username and password from excel sheet while using Selenium in C# .NET. Below is the code:

using excel = Microsoft.Office.Interop.Excel;

public void TestMethod1()
{
       excel.Application xlApp = new excel.Application();
       excel.Workbook xlWorkbook = xlApp.Workbooks.Open(@"D:\Test\TestData.xlsx");
       excel._Worksheet xlWorksheet = **xlWorkbook.Sheets[1];**
       excel.Range xlRange = xlWorksheet.UsedRange;
 }

在上述代码中以粗体标记的文本上出现以下错误:

I'm getting the following error at the text that is marked in bold in above code:

错误CS0656缺少必需的编译器成员'Microsoft.CSharp.RuntimeBinder.Binder.Convert'从中读取数据Excel_Office c:\ users \ tabish.khan \ documents \ visual studio2015 \ Projects \从Excel_Office读取数据\从Excel_Office \ OfficeReadExcel.cs 18有效

Error CS0656 Missing compiler required member 'Microsoft.CSharp.RuntimeBinder.Binder.Convert' Read Data From Excel_Office c:\users\tabish.khan\documents\visual studio 2015\Projects\Read Data From Excel_Office\Read Data From Excel_Office\OfficeReadExcel.cs 18 Active

请帮助我解决此问题.

推荐答案

我的C#类库项目有相同的错误.我正在使用.NET Framework 4.6，并使用NuGet安装了Microsoft.Office.Interop.Excel程序集:

I have the same error with my C# Class Library project. I'm using .NET Framework 4.6 and I used NuGet to install the Microsoft.Office.Interop.Excel assembly:

PM> Install-Package Microsoft.Office.Interop.Excel

这是导致此错误的代码的简化版本:

Here is a simplified version of the code which causes this error:

using MSExcel = Microsoft.Office.Interop.Excel;

namespace ProjectReader
{
    public class ExcelExport
    {

        public ExcelExport()
        {
            xlApp = new MSExcel.Application();
            xlWorkBook = xlApp.Workbooks.Add(System.Reflection.Missing.Value);
        }

        public void CreateFile()
        {
            object missingValue = System.Reflection.Missing.Value;

            foreach (MSExcel.Worksheet sht in xlWorkBook.Sheets)
            {
                if (xlWorkBook.Worksheets.Count > 1)
                {
                    sht.Delete();
                }
            }

            **xlWorkSheet = (MSExcel.Worksheet)xlWorkBook.Sheets[1];**
        }

        private MSExcel.Application xlApp;
        private MSExcel.Workbook xlWorkBook;
        private MSExcel.Worksheet xlWorkSheet;
    }
}

有趣的是，我在问题行上方的foreach循环中引用工作表没有问题.

Interestingly, I have no issues referencing the worksheets in the foreach loop just above the offending line.

这篇关于在Selenium C#中从Excel读取数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！