vb.net和C#.net读取EXCEL
读取 vb.net Try filePath = ofDialog.FileName objConn.Open() End Try C#.net OpenFileDialog ofDialog = new OpenFileDialog(); if (ofDialog.ShowDialog() == DialogResult.OK) { filePath = ofDialog.FileName; } else { return; } if (!File.Exists(filePath)) { return; } //连接 String strConn = "Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=" + filePath + ";" + "Extended Properties='Excel 8.0;HDR=NO;IMES=1'"; try { OleDbConnection objConn = new OleDbConnection(strConn); if (objConn.State != ConnectionState.Open) { objConn.Open(); } DataTable schemaTable = objConn.GetOleDbSchemaTable(System.Data.OleDb.OleDbSchemaGuid.Tables,null); OleDbCommand objCmd = new OleDbCommand("",objConn); OleDbDataAdapter objDA = null; DataSet objDs = new DataSet(); for (int i = 0; i < schemaTable.Rows.Count; i++) { objCmd.CommandText = "SELECT * FROM [" + schemaTable.Rows[i][2].ToString() + "]"; objDA = new OleDbDataAdapter(objCmd); DataTable objDt = new DataTable(); objDA.Fill(objDt); objDs.Tables.Add(objDt); } } catch (Exception ex) { MessageBox.Show(ex.Message); } (编辑:李大同) 【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容! |