Excel操作表格

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using System.Data.OleDb;
using System.IO;

namespace ExcelRead
{
   public static class ExcelOperate
    {
       /// <summary>
       /// 根据表格名称获取Excel中表格
       /// </summary>
       /// <param name="path"></param>
       /// <param name="sheetName"></param>
       /// <returns></returns>
       public static DataTable GetTableFromExcel(string path, string sheetName)
       {
           // Path.GetExtension(path) == "xlsx" ? "Provider=Microsoft.Ace.OleDb.12.0;" :
           string parame = "Provider=Microsoft.Jet.OleDb.4.0;";
           string strConn = string.Format("{0}Data Source=" + path + ";Extended Properties='Excel 8.0;HDR=YES;IMEX=1'", parame);
           OleDbConnection OleConn = new OleDbConnection(strConn);
           OleConn.Open();
           String sql = string.Format("SELECT * FROM  [{0}$]", sheetName);

           OleDbDataAdapter OleDaExcel = new OleDbDataAdapter(sql, OleConn);
           DataSet OleDsExcle = new DataSet();
           OleDaExcel.Fill(OleDsExcle, sheetName);
           OleConn.Close();

           DataTable table = OleDsExcle.Tables[0];
           return table;
       }
       /// <summary>
       /// 获取Excel中所有的表格名称
       /// </summary>
       /// <param name="path"></param>
       /// <returns></returns>
       public static List<String> GetSheetNameFromExcel(string path)
       {
           // Path.GetExtension(path) == ".xlsx" ? "Provider=Microsoft.Ace.OleDb.12.0;" : 
           List<String> names = new List<string>();
           string parame ="Provider=Microsoft.Jet.OleDb.4.0;";
           string strConn = string.Format("{0}Data Source=" + path + ";Extended Properties='Excel 8.0;HDR=YES;IMEX=1'", parame);

           OleDbConnection conn = new OleDbConnection(strConn);
           conn.Open();
           DataTable sheetNames = conn.GetOleDbSchemaTable
           (OleDbSchemaGuid.Tables, new object[] { null, null, null, "TABLE" });
           conn.Close();

           foreach (DataRow dr in sheetNames.Rows)
           {
               string sheetName = dr[2].ToString().Replace("'", "").Replace("'", "").Replace("$", "");
               names.Add(sheetName.Trim());
           }
           return names;
       }

    }
}