从Xcel电子表格读取数据:错误CS0021

Question

为什么会收到此错误消息？正是我的代码中的这一行被抱怨：

website = x1range.Cells[i][1].value2;

我得到

错误CS0021无法将[]索引应用于类型为"object"的表达式

这是我的代码：

using System; using System.Threading; using OpenQA.Selenium; using
OpenQA.Selenium.Chrome; using excel =
Microsoft.Office.Interop.Excel;
namespace Create Editions
{
class Program
{
static void Main(string[] args)
{
excel.Application x1app = new excel.Application();
excel.Workbook x1workbook = x1app.Workbooks.Open(@"D:DATACreateEditions.xlsx");
excel._Worksheet x1worksheet = (excel._Worksheet)x1workbook.Sheets[1];
excel.Range x1range = x1worksheet.UsedRange;
string website;

for(int i=1; i<=3; i++)
{
website = x1range.Cells[i][1].value2;
IWebDriver driver = new ChromeDriver();
driver.Navigate().GoToUrl(website);
}
}
}
}

Answer 1

x1range.Cells[i]返回一个object，它是Range索引器的返回类型。因此，请将x1range.Cells[i]的类型转换为Range。参考

website = (string)((Range)x1range.Cells[i])[1].value2;