/// <summary>

        /// 读取Excel

        /// authon:codeo.cn

        /// </summary>

        /// <param name="strExcelFileName"></param>

        /// <param name="strSheetName"></param>

        /// <returns>DataTable</returns>

        public static DataTable ExcelToDataTable(string strExcelFileName, string strSheetName)

        {

            //源的定义

            string strConn = "Provider=Microsoft.ACE.OLEDB.12.0;" + "Data Source=" + strExcelFileName + ";" + "Extended Properties='Excel 8.0;HDR=NO;IMEX=1';";

            //Sql语句

            //string strExcel = string.Format("select * from [{0}$]", strSheetName); 这是一种方法

            string strExcel = "select * from  [" + strSheetName + "$]";//[sheet1$]

            //定义存放的数据表

            DataSet ds = new DataSet();

            //连接数据源

            OleDbConnection conn = new OleDbConnection(strConn);

            conn.Open();

            //适配到数据源

            OleDbDataAdapter adapter = new OleDbDataAdapter(strExcel, strConn);

            adapter.Fill(ds, strSheetName);

            conn.Close();

            return ds.Tables[strSheetName];

        }

 protected void Page_Load(object sender, EventArgs e)

        {

            string path = GetRootPath();

            DataTable daTable = ExcelToDataTable(path + "Content\\demo.xlsx", "Sheet1");

            GridView1.DataSource = daTable;

            GridView1.DataBind();

        }

/// <summary>

        /// 取得网站根目录的物理路径

        /// authon:codeo.cn

        /// </summary>

        /// <returns></returns>

        public static string GetRootPath()

        {

            string AppPath = "";

            HttpContext HttpCurrent = HttpContext.Current;

            if (HttpCurrent != null)

            {

                AppPath = HttpCurrent.Server.MapPath("~");

            }

            else

            {

                AppPath = AppDomain.CurrentDomain.BaseDirectory;

                if (Regex.Match(AppPath, @"\\$", RegexOptions.Compiled).Success)

                    AppPath = AppPath.Substring(, AppPath.Length - );

            }

            return AppPath;

        }

daTable.Columns[].ColumnName = "表头1";

daTable.Columns[].ColumnName = "表头2";

daTable.Columns[].ColumnName = "表头3";