获取excel工作表信息

xls文件连接字符串：

string conn = string.Concat("Provider=Microsoft.Jet.OLEDB.4.0;Data Source= ", "文件路径", ";Extended Properties='Excel 8.0;HDR=YES;IMEX=1'");

xlsx文件连接字符串：

conn = string.Concat("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=","文件路径", ";Extended Properties='Excel 12.0 Xml;HDR=YES;IMEX=1'");

OleDbConnection OleDbConn=new OleDbConnection(conn);

OleDbConn.Open();

//读取excel中包含的表信息
DataTable dt = OleDbConn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, new object[] { null, null, null, "Table" });//获取excel工作表信息
           
string sheetName = dt.Rows[0]["TABLE_NAME"].ToString();