读取Excel表中的数据

<summary>
    /// 从Excel文件中取得表信息
    /// </summary>
    /// <param name="FileName">文件名称</param>
    /// <returns></returns>
    protected DataTable GetDataTableFromExcel(string FileName)
    {
        //创建连接字符串
        String strConn = "Provider=Microsoft.Jet.OLEDB.4.0;" + 
        "Data Source=" + Server.MapPath(FileName) + ";" +
        "Extended Properties=Excel 8.0;";
        OleDbConnection objConn = new OleDbConnection(strConn);
        OleDbCommand objCmd = new OleDbCommand("SELECT * FROM [Sheet1$]", objConn);
        OleDbDataAdapter objDA = new OleDbDataAdapter(objCmd);
        DataTable objDt = new DataTable();
        objDA.Fill(objDt);
        return objDt;
    }