//引用Microsoft.Office.Interop.Excel
//表格地址
string excelPath = "D:\\××\\××××.xlsx";
//表格单元
string Sheets = "Sheet1";
Microsoft.Office.Interop.Excel.Application app = new Microsoft.Office.Interop.Excel.Application();
//工作簿
Microsoft.Office.Interop.Excel.Workbook wbk = app.Workbooks.Open(excelPath);
//工作表
Microsoft.Office.Interop.Excel.Worksheet wsh = wbk.Sheets[Sheets];
//生成datatable 数据表
string asd = string.Empty;
DataSet dataSet = new DataSet();
DataTable dataTable = new DataTable();
循环 从i行开始 到i行结束
for (int i = 2; i <= 1800; i++)
{
//读取i第几个字段
str = wsh.Cells[i, 1].Value.ToString();
}
C#读取Exel表中数据
最新推荐文章于 2024-07-25 00:09:37 发布