读取EXCEL文件信息到TABLE

   #region GetOutNormalInfo
    /// <summary>
    /// 读取Excel文件
    /// </summary>
    /// <param name="fileName">文件名</param>
    /// <param name="tableName">表名</param>
    /// <returns></returns>
    public static DataTable GetOutNormalInfo(string fileName, string tableName)
    {
        string strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=";
        strConn = strConn + fileName + ";";
        strConn = strConn + "Extended Properties=Excel 8.0;";
        string strSql = "Select * from [" + tableName + "$]";
        OleDbConnection conn = new OleDbConnection(strConn);
        OleDbDataAdapter myCommand = new OleDbDataAdapter(strSql, strConn);
        DataSet myDataSet = new DataSet();
        myCommand.Fill(myDataSet, "Table");
        return myDataSet.Tables["Table"];
    }
    #endregion

转载于:https://www.cnblogs.com/black263/archive/2010/06/15/1758545.html