c# 取出 excel 中所有的表名

internal static string[] GetSheetNames(out string errorInfo)
{
errorInfo = null;
OleDbConnection con = null;
try
{
   con = new OleDbConnection(m_ConnString);
   con.Open();
   DataTable dt = con.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, new object[] { null, null, null, "TABLE" });
   con.Close();
   if (dt != null)
   {
    string[] ts = new string[dt.Rows.Count];
    for (int i = 0; i < dt.Rows.Count; i++)
    {
     ts[i] = dt.Rows[i]["TABLE_NAME"].ToString();
    }
    return ts;
   }
   return null;
}
catch (Exception ex)
{
   if (con != null)
   {
    con.Close();
   }
   errorInfo = ex.Message;
   return null;
}
}

转载于:https://www.cnblogs.com/qinhaijun/archive/2011/08/26/2154397.html