public void ShouldExportExcelFileWithDefaultTableStyle()
{
var stream = new ExportManagerBuilder <ModelTableWithOutTableStyle>()
.Init()
.SetData(VariablesModelTableWithOutTableStyle.Data.ToList())
.StartExportProcess();
StreamTestFile.SaveExternalFile(stream);
}
public void ShouldExportExcelFileWithNumberColumn()
{
var stream = new ExportManagerBuilder <ModelIntProperty>()
.Init()
.SetData(VariablesModelIntProperty.Data.ToList())
.StartExportProcess();
var workbook = new XLWorkbook(stream);
workbook.TryGetWorksheet(VariablesModelIntProperty.WorksheetName, out var worksheet);
worksheet.Should().NotBeNull();
worksheet.Cell(1, 3).Value.ToString().Should().BeEquivalentTo(VariablesModelIntProperty.FieldName);
worksheet.Cell(2, 3).Value.Should().BeEquivalentTo(VariablesModelIntProperty.Data[0].Age);
worksheet.Cell(3, 3).Value.Should().BeEquivalentTo(VariablesModelIntProperty.Data[1].Age);
}
public void ShouldExport()
{
//Arrange
var data = MockRamdomData();
var watch = new Stopwatch();
watch.Start();
var stream = new ExportManagerBuilder <ModelOrderedProperties>()
.Init()
.SetData(data.ToList())
.StartExportProcess();
watch.Stop();
var time = watch.Elapsed.Seconds;
var a = 1;
}
public void ShouldExportExcelFileWithNumberColumn()
{
var stream = new ExportManagerBuilder <ModelOrderedProperties>()
.Init()
.SetData(VariablesModelOrderedProperties.Data.ToList())
.StartExportProcess();
var workbook = new XLWorkbook(stream);
workbook.TryGetWorksheet(VariablesModelOrderedProperties.WorksheetName, out var worksheet);
worksheet.Should().NotBeNull();
worksheet.Cell(1, 1).Value.ToString().Should().BeEquivalentTo(VariablesModelOrderedProperties.NameLabel);
worksheet.Cell(1, 2).Value.ToString().Should().BeEquivalentTo(VariablesModelOrderedProperties.IdLabel);
worksheet.Cell(1, 3).Value.ToString().Should().BeEquivalentTo(VariablesModelOrderedProperties.BirthDateLabel);
worksheet.Cell(1, 4).Value.ToString().Should().BeEquivalentTo(VariablesModelOrderedProperties.HeightLabel);
}
public void ShouldExportAllTypesWithCustomFormat()
{
var stream = new ExportManagerBuilder <ModelExportAllTypesWithCustomFormat>()
.Init()
.SetData(VariablesModelExportAllTypesWithCustomFormat.Data.ToList())
.StartExportProcess();
var workbook = new XLWorkbook(stream);
workbook.TryGetWorksheet(VariablesModelExportAllTypesWithCustomFormat.WorksheetName, out var worksheet);
worksheet.Should().NotBeNull();
worksheet.Cell(2, 1).Style.NumberFormat.Format.Should()
.Be(VariablesModelExportAllTypesWithCustomFormat.IdFieldFormat);
worksheet.Cell(2, 2).Style.NumberFormat.Format.Should()
.Be(VariablesModelExportAllTypesWithCustomFormat.PointsFieldFormat);
worksheet.Cell(2, 3).Style.NumberFormat.Format.Should()
.Be(VariablesModelExportAllTypesWithCustomFormat.DateFieldFormat);
}
public void ShouldExportExcelFileWithBooleanColumn()
{
var stream = new ExportManagerBuilder <ModelBoolNullableProperty>()
.Init()
.SetData(VariablesModelBoolNullableProperty.Data.ToList())
.StartExportProcess();
var workbook = new XLWorkbook(stream);
workbook.TryGetWorksheet(VariablesModelBoolNullableProperty.WorksheetName, out var worksheet);
StreamTestFile.SaveExternalFile(stream);
worksheet.Should().NotBeNull();
worksheet.Cell(1, 5).Value.ToString().Should()
.BeEquivalentTo(VariablesModelBoolNullableProperty.FieldName);
worksheet.Cell(2, 5).Value.Should()
.BeEquivalentTo(VariablesModelBoolNullableProperty.Data[0].Active);
worksheet.Cell(3, 5).Value.Should()
.BeEquivalentTo(VariablesModelBoolNullableProperty.Data[1].Active);
worksheet.Cell(4, 5).Value.Should().Be("");
}
public void ShouldExportExcelFileWithHeaderBackgroundColor()
{
var data = new List <ModelHeaderBackgroundColor>()
{
new ModelHeaderBackgroundColor("Luiz", 32),
new ModelHeaderBackgroundColor("Frodo", 11)
};
var stream = new ExportManagerBuilder <ModelHeaderBackgroundColor>()
.Init()
.SetData(data)
.StartExportProcess();
var workbook = new XLWorkbook(stream);
workbook.TryGetWorksheet("HeaderBackgroundColor", out var worksheet);
worksheet.Should().NotBeNull();
worksheet.Cell(1, 1).Style.Fill.BackgroundColor.Color.Should().BeEquivalentTo(XLColor.Transparent.Color);
worksheet.Cell(1, 2).Style.Fill.BackgroundColor.Color.Should().BeEquivalentTo(XLColor.FromArgb(0, 255, 0).Color);
worksheet.Cell(2, 1).Style.Fill.BackgroundColor.Color.Should().BeEquivalentTo(XLColor.Transparent.Color);
worksheet.Cell(2, 2).Style.Fill.BackgroundColor.Color.Should().BeEquivalentTo(XLColor.Transparent.Color);
}
