像访问Sql一样访问Excel

来源：互联网发布：怎么用js隐藏div 编辑：程序博客网时间：2024/06/10 12:30

//由于时间关系,来不及去做Demo 了,就帖一个片段了啊.

DataSet KDDataSet = new DataSet();

System.Data.OleDb.OleDbConnection objConn = new System.Data.OleDb.OleDbConnection("Provider=Microsoft.jet.OLEDB.4.0;Data Source=" + filename + ";Extended Properties=Excel 8.0");//这个更据不同的Excel版本不一样

//filename 为Excel的路径
            objConn.Open();
            //DataTable schemaTable = objConn.GetOleDbSchemaTable(System.Data.OleDb.OleDbSchemaGuid.Tables, null);
           // String tableName = schemaTable.Rows[0][2].ToString().Trim();
            String SqlStr = "Select * from [Sheet1$]";
            System.Data.OleDb.OleDbCommand command = new System.Data.OleDb.OleDbCommand(SqlStr, objConn);
            System.Data.OleDb.OleDbDataAdapter DAP = new System.Data.OleDb.OleDbDataAdapter(command);

DAP.Fill(KDDataSet, "Sheet1");

//剩下的就是ADO的操作了,不用讲了吧