田贤追博客 - QQ：260776893，Tel：13065860667

    C#从EXCEL导入到DATASET代码

 /// <summary>
        /// 从EXCEL导入到DATASET代码
        /// </summary>
        /// <param name="excelName"></param>
        /// <returns></returns>
        public DataSet ExcelReader(string excelName)
        {
            // 拼写连接字符串，打开连接
            string strConn = "Provider=Microsoft.Jet.OleDb.4.0;" + "data source=" + excelName + ";Extended Properties='Excel 8.0; HDR=YES; IMEX=1'";
            OleDbConnection objConn = new OleDbConnection(strConn);
            objConn.Open();
            // 取得Excel工作簿中所有工作表
            DataTable schemaTable = objConn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, null);

            OleDbDataAdapter sqlada = new OleDbDataAdapter();
            DataSet ds = new DataSet();
            // 遍历工作表取得数据并存入Dataset
            foreach (DataRow dr in schemaTable.Rows)
            {
                string strSql = "Select * From [" + dr[2].ToString().Trim() + "]";
                OleDbCommand objCmd = new OleDbCommand(strSql, objConn);
                sqlada.SelectCommand = objCmd;
                sqlada.Fill(ds, dr[2].ToString().Trim());
                break;
            }
            objConn.Close();
            return ds;
        }