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