答案来了
OleDbConnection conn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\\zzz.xls;Extended Properties=Excel 8.0;");
conn.Open();
DataTable dt = conn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, null);
conn.Close();
conn.Dispose();
string strTab = "";
for(int i = 0; i < dt.Rows.Count; i ++)
{
strTab += dt.Rows[i]["TABLE_NAME"].ToString() + "\n";
}
MessageBox.Show(strTab);
OleDbConnection conn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\\zzz.xls;Extended Properties=Excel 8.0;");
conn.Open();
DataTable dt = conn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, null);
conn.Close();
conn.Dispose();
string strTab = "";
for(int i = 0; i < dt.Rows.Count; i ++)
{
strTab += dt.Rows[i]["TABLE_NAME"].ToString() + "\n";
}
MessageBox.Show(strTab);
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货