把 Excel数据读到DataSet里面 代码示例

  private DataSet ExcelToDS()
        {
            DataSet myDataSet = new DataSet();

            string myConn = "Provider = Microsoft.Jet.OLEDB.4.0 ; Data Source = '" + Server.MapPath("~/App_Data/Db.xls") + "';Extended Properties=Excel 8.0";
            OleDbConnection cnnxls = new OleDbConnection(myConn);
            cnnxls.Open();
            DataTable dt = cnnxls.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, null);
            string StyleSheet = dt.Rows[0][2].ToString().Trim();
            string StrSql = string.Format("SELECT * FROM [{0}]", StyleSheet);
            OleDbDataAdapter myCommand = new OleDbDataAdapter(StrSql, myConn);
            myCommand.Fill(myDataSet, string.Format("[{0}]", StyleSheet));
            myCommand.Dispose();
            cnnxls.Close();

            return myDataSet;
        }