获得Excle工作表数组
/// <summary>获得Excle工作表名称数组</summary>
/// <param name="filePath">文件路径</param>
/// <returns>ArrayList集合</returns>
public ArrayList GetExcleSheetName(string filePath)
{
ArrayList al = new ArrayList();
string connStr = "";
string fileType = System.IO.Path.GetExtension(filePath);
if (string.IsNullOrEmpty(fileType)) return null;
if (fileType == ".xls")
connStr = "Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=" + filePath + ";" + ";Extended Properties=\"Excel 8.0;HDR=YES;IMEX=1\"";
else
connStr = "Provider=Microsoft.ACE.OLEDB.12.0;" + "Data Source=" + filePath + ";" + ";Extended