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