导入Excel

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