TextBox: txtFilePath excel路径 ComboBox: cmbSheets excel里的某个sheet DataGridView: dgvData string connStr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + txtFilePath.Text + ";Extended Properties='Excel 8.0;HDR=No;IMEX=1'"; OleDbConnection conn = new OleDbConnection(connStr); string sql = string.Format("select * from {0}", cmbSheets.Text); OleDbDataAdapter da = new OleDbDataAdapter(sql, conn); DataTable dt = new DataTable(); da.Fill(dt); dgvData.Columns.Clear(); dgvData.DataSource = dt; conn.Close(); conn.Dispose();