110,535
社区成员
发帖
与我相关
我的任务
分享
public System.Data.DataTable ReadOneSheetData(string sheetTableName)
{
System.Data.DataTable dataTable = new System.Data.DataTable();
string connStr = "Provider = Microsoft.Jet.OLEDB.4.0;Data Source = " + FileName + ";" + "Extended Properties = \"Excel 8.0;HDR=No;IMEX=1\";";
using (OleDbConnection OleDbConn = new OleDbConnection(connStr))
{
OleDbConn.Open();
string sql = "Select * From [" + sheetTableName+"]";
using(OleDbDataAdapter oleDbAdapter = new OleDbDataAdapter(sql,OleDbConn))
{
oleDbAdapter.Fill(dataTable);
}
OleDbConn.Close();
}
if (dataTable.Columns.Count == 1 && dataTable.Rows.Count == 2)//sheet表为空
{
return null;
}
return dataTable;
}