/// <summary>
/// 获取Excel工作表的名称
/// </summary>
/// <param name="stringExclePath">Excel表格路径</param>
/// <returns>以字符串数组返回Excel工作表的所有名称</returns>
public string[] GetWorkSheetNames(string stringExclePath)
{
string tableName = "";
try
{
stringConnectionExcel = "Provider = Microsoft.Jet.OLEDB.4.0;Data Source = "
+ stringExclePath + ";Extended Properties = Excel 8.0";
oleDbConnection = new OleDbConnection(stringConnectionExcel);
oleDbConnection.Open();
DataTable dataTable = oleDbConnection.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, null);
for (int i = dataTable.Rows.Count - 1; i >= 0; i--)
{
tableName += dataTable.Rows[i][2].ToString().TrimEnd('$') + "/";
}
oleDbConnection.Close();
}
catch { }
tableName = tableName.TrimEnd('/');
string[] workBookNameList = tableName.Split('/');
return workBookNameList;
}