关于老大如何用excel 批量带入数据的问题的学习

如何获取Excel表里面的数据到DataSet里面？
        /// <summary>
        /// 读取excel文件
        /// </summary>
        /// <param name="path">读取的Excel文件路径</param>
        /// <returns>dataset对象</returns>

        private DataSet readExcel(string path)
        {
            string strConn;
            strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + path + ";Extended  Properties='Excel 8.0';";//js文件需导入
            OleDbConnection conn = new OleDbConnection(strConn);
            OleDbDataAdapter oleDDA = new OleDbDataAdapter("SELECT * FROM [Sheet1$A:B]", strConn);
            DataSet myDataSet = new DataSet();
            try
            {
                oleDDA.Fill(myDataSet);
            }
            catch (Exception ex)
            {
                throw new Exception("该Excel文件的工作表的名字不正确," + ex.Message);
            }
            return myDataSet;
        }
        Tip: myDataSet 仅仅保存的是数据 ，无类型, 而且是暂时的
    下一步：保存到数据库里面  so easy ~~