public DataTable makeExcelTODatatable(string excelName,string sheetName)
{
string strConn = "Provider=Microsoft.Jet.OLEDB.4.0; " + "Data Source= " + excelName + "; " + "Extended Properties= 'Excel 8.0;HDR=YES;IMEX=1 '; ";
string strSql = "select * from [sheet1$]";
DataSet ds = new DataSet();
OleDbConnection con = new OleDbConnection(strConn);
con.Open();
OleDbDataAdapter oda = new OleDbDataAdapter(strSql, strConn);
oda.Fill(ds,sheetName);
con.Close();
return ds.Tables[sheetName];
}
我到网上找了些回答,但目前还是没解决.忘高人指点.
{
string strConn = "Provider=Microsoft.Jet.OLEDB.4.0; " + "Data Source= " + excelName + "; " + "Extended Properties= 'Excel 8.0;HDR=YES;IMEX=1 '; ";
string strSql = "select * from [sheet1$]";
DataSet ds = new DataSet();
OleDbConnection con = new OleDbConnection(strConn);
con.Open();
OleDbDataAdapter oda = new OleDbDataAdapter(strSql, strConn);
oda.Fill(ds,sheetName);
con.Close();
return ds.Tables[sheetName];
}
我到网上找了些回答,但目前还是没解决.忘高人指点.
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货