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

aahq39082

于 2009-09-01 22:12:00 发布

阅读量127

点赞数

原文链接：http://www.cnblogs.com/guttersnipe/archive/2009/09/01/1558353.html

版权

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;
        }

转载于:https://www.cnblogs.com/guttersnipe/archive/2009/09/01/1558353.html