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