//å¼å
¥oledb
using System.Data.OleDb;
//读åå
¥å£
public static DataTable Query(string excelPath, string sheetName)
{
OleDbConnection conn = CreateConnection(excelPath);
conn.Open();
DataTable dt = new DataTable();
dt = QueryBySheetName(conn, sheetName + "$");
conn.Close();
return dt;
}
//å®ä¹è¿æ¥ä¸²
internal static OleDbConnection CreateConnection(string excelPath)
{
return new OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source= " + excelPath + ";Extended Properties='Excel 12.0;HDR=YES;IMEX=1;'");
}
//读åexcelæå®sheetçæ°æ®
private static DataTable QueryBySheetName(OleDbConnection conn, string sheetName)
{
string cmd = "select * from [" + sheetName + "]";
OleDbDataAdapter adapter = new OleDbDataAdapter(cmd, conn);
DataTable dt = new DataTable();
adapter.Fill(dt);
return dt;
}
//ä»datatableæå
¥æ°æ®åº,å
·ä½åå¼æå
¥ä»£ç ç¥
for(int i=0;i<dt.Rows.Count;i++)
{
//æå
¥æ°æ®åº
}
温馨提示:答案为网友推荐,仅供参考