EXCEL转换到TABLE中 | Bruce's Blog

分类

现在位置: 首页＞ .NET, Access ＞正文

EXCEL转换到TABLE中

2011-12-14 15:21 .NET, Access 暂无评论阅读(2,485)

//把EXCEL转换到TABLE中
public static DataTable ExcelToDataTable(string excelPath, string strSheetName)
{
string strConn = "Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=" + excelPath + ";"
+ "Extended Properties=Excel 5.0;";
string strExcel = string.Format("select * from [{0}]", strSheetName);
DataSet ds = new DataSet();
using (OleDbConnection conn = new OleDbConnection(strConn))
{
conn.Open();
OleDbDataAdapter adapter = new OleDbDataAdapter(strExcel, strConn);
adapter.Fill(ds, strSheetName);
conn.Close();
}
return ds.Tables[strSheetName];
}