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