private void saveExcelBtn_Click(object sender, EventArgs e)//+ { try { string infoFileName = string.Empty; string resultFileName = string.Empty; Dictionary <string, ExcelProfile> excelProfileMap = null; using (SheetsSettigsForm ssf = new SheetsSettigsForm()) { ssf.Type = "save"; ssf.Format = "excel"; ssf.Document = Document; ssf.ShowDialog(); if (ssf.Status) { infoFileName = ssf.InfoFileName; resultFileName = ssf.ResultFileName; excelProfileMap = ssf.ExcelProfileMap; } else { return; } } string filePath = CommonService.SaveFilePath("*.xlsx|*.xlsx", Document.DocumentName); DataManipulationService.SaveExcel(infoFileName, resultFileName, excelProfileMap, Document, filePath); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void loadDataExcelBtn_Click(object sender, EventArgs e)//+ { try { string filePath = CommonService.OpenFilePath("*.xlsx|*.xlsx", "физвоспитание анкета"); if (string.IsNullOrEmpty(filePath)) { return; } string fileName = Path.GetFileNameWithoutExtension(filePath); string infoFileName = string.Empty; string resultFileName = string.Empty; Dictionary <string, string> excelProfileMap = null; using (SheetsSettigsForm ssf = new SheetsSettigsForm()) { ssf.Type = "load"; ssf.FilePath = filePath; ssf.ShowDialog(); if (ssf.Status) { infoFileName = ssf.InfoFileName; resultFileName = ssf.ResultFileName; excelProfileMap = ssf.ExcelSheetMap; } else { return; } Document = SortDocument(DataManipulationService.LoadMainProfileExcel(filePath, infoFileName, resultFileName, excelProfileMap)); if (Document != null) { ShowOnTabControl(Document); InitAutoComplete(questionTB, Document); saveBtn.Enabled = true; closeProfileBtn.Enabled = true; visDataBtn.Enabled = true; questionBtn.Enabled = true; } } } catch (Exception ex) { MessageBox.Show(ex.Message); } }