private void btnExcelImport_Click(object sender, EventArgs e) { string path = "员工名册20160823.xls"; DataSet ds = MyExcelUtls.GetExcelToDataSet(path, false); dataGridView1.DataSource = ds.Tables["上海总部$"]; excelTable = ds.Tables["上海总部$"]; btnToDB.Enabled = true; }
private void btnny_Click(object sender, EventArgs e) { string path = "20160425学员名单宁阳.xls"; DataSet ds = MyExcelUtls.GetExcelToDataSet(path, false); dataGridView1.DataSource = ds.Tables[0]; excelTable = ds.Tables[0]; //btnToDB.Enabled = true; }
private void btnjmsadd_Click(object sender, EventArgs e) { //if(openFileDialog1.ShowDialog()== DialogResult.OK) { //string path = "加盟信息记录表_陈志刚.xls"; //string path = "加盟信息记录表_马鑫.xls"; //string path = "加盟信息记录表_王彬.xls"; //string path = "加盟信息记录表_吴华强.xls"; string path = "加盟信息记录表_周悦琪.xls"; DataSet ds = MyExcelUtls.GetExcelToDataSet(path, false); dataGridView1.DataSource = ds.Tables["Sheet1$"]; excelTable = ds.Tables["Sheet1$"]; btnImportJms.Enabled = true; btnImportJmsGenzong.Enabled = true; } }