导入Excel

最新推荐文章于 2025-08-13 15:20:13 发布

转载最新推荐文章于 2025-08-13 15:20:13 发布 · 596 阅读

文章标签：

#dataset #excel #string #properties #sql #object

[ 01 ] .NET 专栏收录该内容

330 篇文章

订阅专栏

/// <summary> /// Excel路径 /// </summary> const string m_sExcelPath = @"E:/02 Resource/test.xls"; /// <summary> /// 连接 /// </summary> const string m_sExcelConn = @"Provider = Microsoft.Jet.OLEDB.4.0 ; Data Source =" + m_sExcelPath + ";Extended Properties=Excel 8.0"; private void btnReadExcel_Click(object sender, EventArgs e) { DataTable dtResult = new DataTable(); using (OleDbConnection conn = new OleDbConnection(m_sExcelConn)) { string sql = "select * from [Sheet1$]"; conn.Open(); DataSet ds = new DataSet(); ; using (OleDbDataAdapter myCommand = new OleDbDataAdapter(sql, m_sExcelConn)) { myCommand.Fill(ds, "[Sheet1$]"); conn.Close(); dgvDataTable.DataMember = "[Sheet1$]"; } dgvDataTable.DataSource = ds; } }