Asp.net(C#)中自动获取Excel的Sheet名

方法一：

Excel.Application myExcel = new Excel.Application();
object missing = System.Reflection.Missing.Value;
myExcel.Application.Workbooks.Open(this.txtFile.Text, missing, missing, missing, missing, missing, missing, missing, missing, missing, missing, missing, missing, missing, missing);  //this.txtFile.Text为Excel文件的全路径
Excel.Workbook myBook = myExcel.Workbooks[1];

//获取第一个Sheet
Excel.Worksheet sheet = (Excel.Worksheet)myBook.Sheets[1];　
string sheetName = sheet.Name;  //Sheet名

 

//获取全部Sheet名

public static StringCollection ExcelSheetName(string filepath)
        {
            StringCollection names = new StringCollection();
            string strConn;
            strConn = "Provider=Microsoft.Ace.OLEDB.12.0;Data Source=" + filepath + ";Extended Properties='Excel 12.0;HDR=Yes;IMEX=2'";
            OleDbConnection conn = new OleDbConnection(strConn);
            conn.Open();
            DataTable sheetNames = conn.GetOleDbSchemaTable
            (System.Data.OleDb.OleDbSchemaGuid.Tables, new object[] { null, null, null, "TABLE" });
            conn.Close();

            foreach (DataRow dr in sheetNames.Rows)
            {
                names.Add(dr[2].ToString());
            }
            return names;
        }

 

备注：操作完后要关闭：

myBook.Close(Type.Missing,Type.Missing,Type.Missing);
 myExcel.Quit();

 

方法二：

/// <summary>
/// 获取Excel全部Sheet名
/// </summary>
/// <param name="sFileName">路径</param>
/// <returns></returns>
 public string GetSheetNames(string sFileName)
{
         string sheetName = "";
         using (OleDbConnection oledbConn = new OleDbConnection())
         {
                try
                {
                    oledbConn.ConnectionString = "Provider=Microsoft.Jet.Oledb.4.0;data source=" + sFileName + ";Extended Properties=Excel 8.0;";

                    oledbConn.Open();

                    using (DataTable dtOledb = oledbConn.GetSchema("Tables"))
                    {
                        using (DataTableReader dtReader = new DataTableReader(dtOledb))
                        {
                            while (dtReader.Read())
                            {
                                //获取Sheet名
                                sheetName += dtReader["Table_Name"].ToString();
                            }
                        }
                    }
                }
                catch (Exception ex)
                {
                    throw ex;
                }
            }
            return sheetName;
        }

转载地址：   http://blog.sina.com.cn/s/blog_4a50d85b0100yotp.html