如何获取excel对应的sheet个数和对应的名字

最新推荐文章于 2024-08-18 03:28:08 发布

liaomin416100569

最新推荐文章于 2024-08-18 03:28:08 发布

阅读量4.3k

点赞数

分类专栏： C# 文章标签： excel properties string list null table

本文链接：https://blog.csdn.net/liaomin416100569/article/details/6460859

版权

C# 专栏收录该内容

6 篇文章 0 订阅

订阅专栏

public static int GetExcelTableCount(string filename) { DataTable dt = new DataTable(); OleDbConnection cnnxls = new OleDbConnection(); try { string mystring = "Provider = Microsoft.Jet.OLEDB.4.0 ;Extended Properties=Excel 8.0;Data Source =" + filename; cnnxls.ConnectionString = mystring; cnnxls.Open(); dt = cnnxls.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, null); return dt.Rows.Count; } finally { cnnxls.Close(); } return 0; } public static string[] GetExcelTableNames(string filename) { DataTable dt = new DataTable(); OleDbConnection cnnxls = new OleDbConnection(); try { string mystring = "Provider = Microsoft.Jet.OLEDB.4.0 ;Extended Properties=Excel 8.0;Data Source =" + filename; cnnxls.ConnectionString = mystring; cnnxls.Open(); dt = cnnxls.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, null); } finally { cnnxls.Close(); } List names = new List (); foreach (DataRow row in dt.Rows) { names.Add(row["TABLE_NAME"].ToString().Trim('/'', '$').Replace("''", "'").Replace("$$", "$")); } return names.ToArray(); }