Пример #1
0
        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;
        }