public void TestWriteXslx()
{
MacroscopeJobMaster JobMaster = new MacroscopeJobMaster(MacroscopeConstants.RunTimeMode.LIVE);
MaroscopeExcelRemarksReport Report = new MaroscopeExcelRemarksReport();
string Filename = string.Join(".", Path.GetTempFileName(), "xlsx");
Report.WriteXslx(JobMaster: JobMaster, OutputFilename: Filename);
Assert.IsTrue(File.Exists(Filename));
File.Delete(Filename);
}
/** -------------------------------------------------------------------- **/
private void CallbackSaveRemarksExcelReport(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-Remarks.xlsx";
this.Enabled = false;
if (Dialog.ShowDialog() == DialogResult.OK)
{
string Path = Dialog.FileName;
MaroscopeExcelRemarksReport msExcelReport = new MaroscopeExcelRemarksReport();
Cursor.Current = Cursors.WaitCursor;
try
{
msExcelReport.WriteXslx(this.JobMaster, Path);
}
catch (MacroscopeSaveExcelFileException ex)
{
this.DialogueBoxError("Error saving Remarks Excel Report", ex.Message);
}
catch (Exception ex)
{
this.DialogueBoxError("Error saving Remarks Excel Report", ex.Message);
}
finally
{
Cursor.Current = Cursors.Default;
}
}
if (Dialog != null)
{
Dialog.Dispose();
}
this.Enabled = true;
}
/** -------------------------------------------------------------------- **/
private void CallbackSaveRemarksExcelReport(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-Remarks.xlsx";
if (Dialog.ShowDialog() == DialogResult.OK)
{
string Path = Dialog.FileName;
MaroscopeExcelRemarksReport msExcelReport = new MaroscopeExcelRemarksReport();
try
{
if (Macroscope.MemoryGuard(RequiredMegabytes: ExcelReportMegabytesRamRequired))
{
Cursor.Current = Cursors.WaitCursor;
msExcelReport.WriteXslx(this.JobMaster, Path);
Cursor.Current = Cursors.Default;
}
}
catch (MacroscopeInsufficientMemoryException ex)
{
this.DialogueBoxError("Error saving Remarks Excel Report", ex.Message);
}
catch (MacroscopeSaveExcelFileException ex)
{
this.DialogueBoxError("Error saving Remarks Excel Report", ex.Message);
}
catch (Exception ex)
{
this.DialogueBoxError("Error saving Remarks Excel Report", ex.Message);
}
finally
{
Cursor.Current = Cursors.Default;
}
}
Dialog.Dispose();
}