public void CreateSpreadsheetWorkbookTest() { using (var filePath = TestHelper.GetTemporaryFilePath("CreateSpreadsheetWorkbookTest.xlsx")) { var summary = TestBenchmarkRunner.GetSummary(); var xlsxReporter = new XlsxExporter(); xlsxReporter.CreateSpreadsheetWorkbook(filePath, summary, NullLogger.Instance); Assert.True(File.Exists(filePath)); } }
public void ConvertToExcel() { saveFileDialog1.Filter = "Excel Files|*.xls;*.xlsx;*.xlsm"; if (thisChart == null) { MessageBox.Show("график не выбран"); return; } if (saveFileDialog1.ShowDialog() == DialogResult.OK) { XlsxExporter converter = new XlsxExporter(); converter.export(saveFileDialog1.FileName, thisChart); MessageBox.Show("Сохранено"); } saveFileDialog1.Filter = null; }
private Task <ExportResult> ExportToXlsxAsync <T>(Func <string, int?, IEnumerable <T> > searchFunction, string filePathTemplate, string fileExtension, Func <XlsxExporter, Func <IEnumerable <T>, IProgress <ExportProgress>, CancellationToken, ExportResult> > xlsxExporterFunction, string searchQuery, int?searchResultLimit, IProgress <ExportProgress> progressHandler, CancellationToken cancellationToken) { bool splitIntoMultipleFiles = AppSettings.Export.SplitIntoMultipleFiles; int? rowsPerFile; if (splitIntoMultipleFiles) { rowsPerFile = AppSettings.Export.MaximumRowsPerFile; } else { rowsPerFile = MAX_EXPORT_ROWS_PER_FILE; } XlsxExporter xlsxExporter = new XlsxExporter(filePathTemplate, fileExtension, rowsPerFile, splitIntoMultipleFiles, Localization.CurrentLanguage); Func <IEnumerable <T>, IProgress <ExportProgress>, CancellationToken, ExportResult> exportFunction = xlsxExporterFunction(xlsxExporter); return(ExportAsync(searchFunction, exportFunction, searchQuery, searchResultLimit, progressHandler, cancellationToken)); }
public void ExportToFilesTest() { string file = null; try { var summary = TestBenchmarkRunner.GetSummary(); var xlsxReporter = new XlsxExporter(); var dateTime = DateTime.Now; var files = xlsxReporter.ExportToFiles(summary, NullLogger.Instance); Assert.True(files.Any()); file = files.First(); Assert.True(File.Exists(file)); Assert.True(File.GetLastWriteTime(file) > dateTime); } finally { if (!(file is null)) { File.Delete(file); } } }
public void XlsxExporterExportToLogDoesNotThrowWhenParametersAreNull() { var exporter = new XlsxExporter(); Assert.Null(Record.Exception(() => exporter.ExportToLog(null, null))); }
public void XlsxExporterExportToLogDoesNotThrowOnEmptySummary() { var exporter = new XlsxExporter(); Assert.Null(Record.Exception(() => exporter.ExportToLog(TestBenchmarkRunner.EmptySummary, NullLogger.Instance))); }
public void ExportToFilesThrowsWhenLoggerParameterIsNull() { var exporter = new XlsxExporter(); Assert.NotNull(Record.Exception(() => exporter.ExportToFiles(TestBenchmarkRunner.EmptySummary, null))); }
public void ExportToFilesThrowsWhenSummaryParameterIsNull() { var exporter = new XlsxExporter(); Assert.NotNull(Record.Exception(() => exporter.ExportToFiles(null, NullLogger.Instance))); }