我有包含4个工作表(汽车,模型,客户,联系方式)的excel,我在下面有此代码。我需要阅读Excel(Tab)中的特定表格,该怎么做?我正在使用Microsoft Office Interop Excel
string Mysheet = @"C:\MSFT Site Account Updates_May 2015.xlsx";
var excelApp = new Excel.Application();
Excel.Workbooks books = excelApp.Workbooks;
Excel.Workbook sheets = books.Open(Mysheet);
for (int i = 1; i < 2; i++)
{
string Name = ((excelApp.Cells[i, 1] as Excel.Range).Value);
string SiteUrl = ((excelApp.Cells[i, 4] as Excel.Range).Value);
Console.WriteLine("Account created");
}
谢谢你们
var workbook = books.Open(Mysheet);
var worksheet = (Worksheet) workbook.Sheets["Customers"];
Console.WriteLine(worksheet.Cells[2, 2]); // for example...
本文收集自互联网,转载请注明来源。
如有侵权,请联系[email protected] 删除。
我来说两句