private void tsmiOpen_Click(object sender, EventArgs e)
{
this.tbControl.TabPages.Clear();
OpenFileDialog dialog = new OpenFileDialog();
dialog.Filter = "Excel file (*.xlsx)|*.xls;*.xlsx";
dialog.InitialDirectory = System.AppDomain.CurrentDomain.BaseDirectory;//Environment.GetFolderPath(Environment.SpecialFolder.DesktopDirectory);
dialog.Title = "请选择规范的数据文件";
if (dialog.ShowDialog() == DialogResult.OK)
{
ExcelHandler excelHandler = new ExcelHandler(dialog.FileName);
MapData = excelHandler.ExcelToTable();
foreach (KeyValuePair <string, DataTable> kv in MapData)
{
this.tbControl.TabPages.Add(kv.Key, kv.Key);
TableLayoutPanel tb1 = new TableLayoutPanel();
this.tbControl.TabPages[kv.Key].Controls.Add(tb1);
tb1.Dock = DockStyle.Fill;
DataGridView grdUpload = new DataGridView();
grdUpload.DataSource = kv.Value;
grdUpload.Dock = DockStyle.Fill;
tb1.Controls.Add(grdUpload, 0, 0);
grdUpload.ReadOnly = true;
}
}
}
