OpenFileDialog filedialog = new OpenFileDialog();
filedialog.Filter = "Excel文件|*.xls";
filedialog.ShowDialog();
string filename = filedialog.FileName;
string strconn = @"Provider=Microsoft.ACE.OleDb.12.0;Data Source=" + filename + ";Extended Properties='Excel 12.0;HDR=YES;IMEX=1'";
DataSet dt = new DataSet();
string sql="Select * from [Sheet1$]";
OleDbDataAdapter da = new OleDbDataAdapter(sql, strconn);
da.Fill(dt);
dataGridView2.DataSource = dt.Tables[0];
把Excel导入DataGridView
最新推荐文章于 2015-06-04 10:43:15 发布