public void TestWriteXslx() { MacroscopeJobMaster JobMaster = new MacroscopeJobMaster(MacroscopeConstants.RunTimeMode.LIVE); MacroscopeExcelDuplicateContent Report = new MacroscopeExcelDuplicateContent(); string Filename = string.Join(".", Path.GetTempFileName(), "xlsx"); Report.WriteXslx(JobMaster: JobMaster, OutputFilename: Filename); Assert.IsTrue(File.Exists(Filename)); File.Delete(Filename); }
/** -------------------------------------------------------------------- **/ private void CallbackSaveDuplicateContentExcelReport(object sender, EventArgs e) { SaveFileDialog Dialog = new SaveFileDialog(); Dialog.Filter = "Excel files (*.xlsx)|*.xlsx|All files (*.*)|*.*"; Dialog.FilterIndex = 2; Dialog.RestoreDirectory = true; Dialog.DefaultExt = "xlsx"; Dialog.AddExtension = true; Dialog.FileName = "Macroscope-Duplicate-Content.xlsx"; this.Enabled = false; if (Dialog.ShowDialog() == DialogResult.OK) { this.Enabled = false; string Path; MacroscopeTriplePercentageProgressForm ProgressForm; MacroscopeExcelDuplicateContent msExcelReport; Path = Dialog.FileName; ProgressForm = new MacroscopeTriplePercentageProgressForm(MainForm: this); msExcelReport = new MacroscopeExcelDuplicateContent(ProgressFormDialogue: ProgressForm); Cursor.Current = Cursors.WaitCursor; try { msExcelReport.WriteXslx(JobMaster: this.JobMaster, OutputFilename: Path); } catch (MacroscopeSaveExcelFileException ex) { this.DialogueBoxError("Error saving Duplicate Content Excel Report", ex.Message); } catch (Exception ex) { this.DialogueBoxError("Error saving Duplicate Content Excel Report", ex.Message); } finally { ProgressForm.DoClose(); Cursor.Current = Cursors.Default; } } if (Dialog != null) { Dialog.Dispose(); } this.Enabled = true; }
/** -------------------------------------------------------------------- **/ private void CallbackSaveDuplicateContentExcelReport(object sender, EventArgs e) { SaveFileDialog Dialog = new SaveFileDialog(); Dialog.Filter = "Excel files (*.xlsx)|*.xlsx|All files (*.*)|*.*"; Dialog.FilterIndex = 2; Dialog.RestoreDirectory = true; Dialog.DefaultExt = "xlsx"; Dialog.AddExtension = true; Dialog.FileName = "Macroscope-Duplicate-Content.xlsx"; if (Dialog.ShowDialog() == DialogResult.OK) { string Path = Dialog.FileName; MacroscopeTriplePercentageProgressForm ProgressForm = new MacroscopeTriplePercentageProgressForm(MainForm: this); MacroscopeExcelDuplicateContent msExcelReport = new MacroscopeExcelDuplicateContent( ProgressFormDialogue: ProgressForm ); try { if (Macroscope.MemoryGuard(RequiredMegabytes: ExcelReportMegabytesRamRequired)) { Cursor.Current = Cursors.WaitCursor; msExcelReport.WriteXslx(JobMaster: this.JobMaster, OutputFilename: Path); Cursor.Current = Cursors.Default; } } catch (MacroscopeInsufficientMemoryException ex) { this.DialogueBoxError("Error saving Duplicate Content Excel Report", ex.Message); } catch (MacroscopeSaveExcelFileException ex) { this.DialogueBoxError("Error saving Duplicate Content Excel Report", ex.Message); } catch (Exception ex) { this.DialogueBoxError("Error saving Duplicate Content Excel Report", ex.Message); } finally { ProgressForm.DoClose(); Cursor.Current = Cursors.Default; } } Dialog.Dispose(); }