public void DefaultNumberFormatTest() { var data = new[] { new { TextValue = "SomeText", DateValue = DateTime.Now, DoubleValue = 10.2, IntValue = 5 } }; var dynamicProperties = new[] { DynamicProperty.Create(data, "DynamicColumn1", "Display Name 1", typeof(DateTime?), n => DateTime.Now.AddDays(n.IntValue - 4)), DynamicProperty.Create(data, "DynamicColumn2", "Display Name 2", typeof(double), n => n.DoubleValue - 0.2) }; var excelPackage = EnumerableExporter.Create(data, dynamicProperties) .DefaultNumberFormat(typeof(DateTime), "| yyyy-MM-dd") .DefaultNumberFormat(typeof(DateTime?), "|| yyyy-MM-dd") .DefaultNumberFormat(typeof(double), "0.00 $") .DefaultNumberFormat(typeof(int), "00") .CreateExcelPackage(); var excelWorksheet = excelPackage.Workbook.Worksheets.First(); //TestHelper.OpenDocument(excelPackage); string numberDecimalSeparator = NumberFormatInfo.CurrentInfo.NumberDecimalSeparator; Assert.IsTrue(excelWorksheet.Cells[2, 2].Text == DateTime.Today.ToString("| yyyy-MM-dd")); //DateValue Assert.IsTrue(excelWorksheet.Cells[2, 3].Text == $"10{numberDecimalSeparator}20 $"); //DoubleValue Assert.IsTrue(excelWorksheet.Cells[2, 4].Text == "05"); //IntValue Assert.IsTrue(excelWorksheet.Cells[2, 5].Text == DateTime.Today.AddDays(1).ToString("|| yyyy-MM-dd")); //DynamicColumn1 Assert.IsTrue(excelWorksheet.Cells[2, 6].Text == $"10{numberDecimalSeparator}00 $"); //DynamicColumn2 }
public void ConditionalStyleForTest() { var data = new[] { new { TextValue = "SomeText0", DateValue = DateTime.Now, DoubleValue = 0, IntValue = 5 }, new { TextValue = "SomeText1", DateValue = DateTime.Now, DoubleValue = 1, IntValue = 5 }, new { TextValue = "SomeText2", DateValue = DateTime.Now, DoubleValue = 2, IntValue = 5 }, new { TextValue = "SomeText3", DateValue = DateTime.Now, DoubleValue = 3, IntValue = 5 } }; var exporter = EnumerableExporter.Create(data) .ConditionalStyleFor(n => n.DoubleValue, (entry, style) => { if (entry.DoubleValue > 1) { style.Border.Bottom.Style = ExcelBorderStyle.Thick; } }); var excelPackage = exporter.CreateExcelPackage(); //TestHelper.OpenDocument(excelPackage); var excelWorksheet = excelPackage.Workbook.Worksheets.First(); Assert.IsTrue(excelWorksheet.Cells[3, 3].Style.Border.Bottom.Style == ExcelBorderStyle.None); Assert.IsTrue(excelWorksheet.Cells[4, 3].Style.Border.Bottom.Style == ExcelBorderStyle.Thick); }
public void ConfigureTest() { var data = new[] { new { TextValue = "SomeText", DateValue = DateTime.Now, DoubleValue = 10.2, IntValue = 5 } }; var excelPackage = EnumerableExporter.Create(data) .CustomizeTable(range => { var newRange = range.Worksheet.Cells[range.End.Row, range.Start.Column, range.End.Row, range.End.Column]; newRange.Style.Fill.PatternType = ExcelFillStyle.Solid; newRange.Style.Fill.BackgroundColor.SetColor(Color.HotPink); }) .CreateExcelPackage(); //TestHelper.OpenDocument(excelPackage); var excelWorksheet = excelPackage.Workbook.Worksheets.First(); //header excelWorksheet.Cells[1, 1].Style.Fill.BackgroundColor.Rgb.ShouldNotBe("FFFF69B4"); //data excelWorksheet.Cells[2, 1].Style.Fill.BackgroundColor.Rgb.ShouldBe("FFFF69B4"); }
public void ExportNullTest() { IList <Tuple <string, int, bool> > data = null; // ReSharper disable once ExpressionIsAlwaysNull Assert.IsNull(EnumerableExporter.Create(data).CreateExcelPackage()); // ReSharper disable once ExpressionIsAlwaysNull Assert.IsNull(ObjectExporter.Create(data).AppendToExcelPackage(TestHelper.FakeAnExistingDocument())); }
private static void ExportEnumerable() { Console.WriteLine("Create fake data..."); var faker = new Faker <Employee>().CustomInstantiator(n => new Employee()); var data = faker.Generate(1000); Console.WriteLine("Exporting Enumerable..."); Action <Employee, ExcelStyle> largeFamilyStyle = (employee, style) => { if (employee.ChildrenCount > 3) { style.Fill.PatternType = ExcelFillStyle.Solid; style.Fill.BackgroundColor.SetColor(Color.Orange); } }; var exporter = EnumerableExporter.Create(data) .DefaultNumberFormat(typeof(DateTime), "yyyy-MM-dd") .NumberFormatFor(n => n.DateHired, "dd-MM-yyyy") .NumberFormatFor(n => n.DateHired, "dd-MM-yyyy") .NumberFormatFor(n => n.ShoeSize, "0.0") .NumberFormatFor(n => n.ChangeInPocket, "0.00 $") .NumberFormatFor(n => n.CarValue, "#,##0.00 $") .Ignore(n => n.Email) .TextFormatFor(n => n.Phone, "Cell: {0}") .StyleFor(n => n.DateContractEnd, style => { style.Fill.Gradient.Color1.SetColor(Color.Yellow); style.Fill.Gradient.Color2.SetColor(Color.Green); }) .ConditionalStyleFor(n => n.ShoeSize, (employee, style) => { style.Fill.PatternType = ExcelFillStyle.Solid; if (employee.ShoeSize >= 11) { style.Fill.BackgroundColor.SetColor(Color.OrangeRed); } else if (employee.ShoeSize < 8) { style.Fill.BackgroundColor.SetColor(Color.ForestGreen); } else { style.Fill.BackgroundColor.SetColor(Color.Yellow); } }) .ConditionalStyleFor(n => n.FirstName, largeFamilyStyle) .ConditionalStyleFor(n => n.LastName, largeFamilyStyle) .ConditionalStyleFor(n => n.Phone, largeFamilyStyle) .ConditionalStyleFor(n => n.ChildrenCount, largeFamilyStyle); var excelPackage = exporter.CreateExcelPackage(); SaveAndOpenDocument(excelPackage); }
public void ExportEmptyEnumerableTest() { var data = Enumerable.Empty <Tuple <string, int, bool> >(); var excelPackage = EnumerableExporter.Create(data).CreateExcelPackage(); //TestHelper.OpenDocument(excelPackage); Assert.IsNotNull(excelPackage); }
public void AddWorksheetToNullPackageTest() { var data = new[] { new { TextValue = "SomeText", DateValue = DateTime.Now, DoubleValue = 10.2, IntValue = 5 } }; ArgumentNullException ex = Assert.Throws <ArgumentNullException>(() => EnumerableExporter.Create(data).AppendToExcelPackage(null)); ex.ParamName.ShouldBe("package"); }
public void CreateExcelPackageTest() { var data = new[] { new { TextValue = "SomeText", DateValue = DateTime.Now, DoubleValue = 10.2, IntValue = 5 } }; var excelPackage = EnumerableExporter.Create(data).CreateExcelPackage(); Assert.IsTrue(excelPackage.Workbook.Worksheets.Count == 1); }
public void ConfigureTest() { var data = new[] { new { TextValue = "SomeText", DateValue = DateTime.Now, DoubleValue = 10.2, IntValue = 5 } }; var excelPackage = EnumerableExporter.Create(data) .Configure(n => n.IntValue, configuration => { configuration.Header.Text = ""; }) .Configure(n => n.DateValue, configuration => { configuration.Header.Text = " "; configuration.Header.SetStyle = style => { style.Border.Bottom.Style = ExcelBorderStyle.Thick; }; configuration.Content.NumberFormat = "dd-MM-yyyy"; configuration.Content.SetStyle = style => { style.Border.Left.Style = ExcelBorderStyle.Dashed; style.Border.Right.Style = ExcelBorderStyle.Dashed; }; }) .CustomizeTable(range => { var newRange = range.Worksheet.Cells[range.End.Row, range.Start.Column, range.End.Row, range.End.Column]; newRange.Style.Fill.PatternType = ExcelFillStyle.Solid; newRange.Style.Fill.BackgroundColor.SetColor(Color.HotPink); }) .CreateExcelPackage(); //TestHelper.OpenDocument(excelPackage); var excelWorksheet = excelPackage.Workbook.Worksheets.First(); //header Assert.IsTrue(excelWorksheet.Cells[1, 2].Style.Border.Bottom.Style == ExcelBorderStyle.Thick); Assert.IsTrue(excelWorksheet.Cells[1, 2].Text == " "); Assert.IsTrue(excelWorksheet.Cells[1, 4].Text == "Int Value"); Assert.IsTrue(excelWorksheet.Cells[1, 1].Style.Fill.BackgroundColor.Rgb != "FFFF69B4"); //data Assert.IsTrue(excelWorksheet.Cells[2, 2].Text == DateTime.Now.ToString("dd-MM-yyyy")); Assert.IsTrue(excelWorksheet.Cells[2, 2].Style.Border.Left.Style == ExcelBorderStyle.Dashed); Assert.IsTrue(excelWorksheet.Cells[2, 2].Style.Border.Right.Style == ExcelBorderStyle.Dashed); Assert.IsTrue(excelWorksheet.Cells[2, 1].Style.Fill.BackgroundColor.Rgb == "FFFF69B4"); }
public static void Sample1() { var data = new[] { new { TextValue = "Text #1", DateValue = DateTime.Now, DoubleValue = 10.1, IntValue = 1 }, new { TextValue = "Text #2", DateValue = DateTime.Now, DoubleValue = 10.2, IntValue = 2 }, new { TextValue = "Text #3", DateValue = DateTime.Now, DoubleValue = 10.3, IntValue = 3 }, new { TextValue = "Text #4", DateValue = DateTime.Now, DoubleValue = 10.4, IntValue = 4 } }; var excelPackage = EnumerableExporter.Create(data).CreateExcelPackage(); Program.SaveAndOpenDocument(excelPackage); }
public void IgnoreTest() { var data = new[] { new { TextValue = "SomeText", DateValue = DateTime.Now, DoubleValue = 10.2, IntValue = 5 } }; var excelWorksheet = EnumerableExporter.Create(data) .Ignore(n => n.TextValue) .CreateExcelPackage() .Workbook.Worksheets.First(); Assert.IsTrue(excelWorksheet.Cells[1, 1].Text == "Date Value"); }
public void StyleForTest() { var data = new[] { new { TextValue = "SomeText", DateValue = DateTime.Now, DoubleValue = 10.2, IntValue = 5 } }; const string dateFormat = "yyyy-MM-dd HH:mm"; var exporter = EnumerableExporter.Create(data) .StyleFor(n => n.DateValue, n => n.Numberformat.Format = dateFormat); var excelPackage = exporter.CreateExcelPackage(); var excelWorksheet = excelPackage.Workbook.Worksheets.First(); Assert.IsTrue(excelWorksheet.Cells[2, 2].Text == data.First().DateValue.ToString(dateFormat)); //DateValue }
public void AddWorksheetToNullPackageTest() { var data = new[] { new { TextValue = "SomeText", DateValue = DateTime.Now, DoubleValue = 10.2, IntValue = 5 } }; try { EnumerableExporter.Create(data).AppendToExcelPackage(null); Assert.Fail(); } catch (ArgumentNullException ex) { Assert.IsTrue(ex.ParamName == "package"); } }
public void HeaderStyleForTest() { var data = new[] { new { TextValue = "SomeText", DateValue = DateTime.Now, DoubleValue = 10.2, IntValue = 5 } }; var exporter = EnumerableExporter.Create(data) .HeaderStyleFor(n => new { n.DateValue, n.DoubleValue, n.IntValue }, style => style.Border.Bottom.Style = ExcelBorderStyle.Thick); var excelPackage = exporter.CreateExcelPackage(); //TestHelper.OpenDocument(excelPackage); var excelWorksheet = excelPackage.Workbook.Worksheets.First(); Assert.IsTrue(excelWorksheet.Cells[1, 2].Style.Border.Bottom.Style == ExcelBorderStyle.Thick); }
public void NumberFormatForTest() { var data = new[] { new { TextValue = "SomeText", DateValue = DateTime.Now, DoubleValue = 10.2, IntValue = 5 } }; var excelWorksheet = EnumerableExporter.Create(data) .NumberFormatFor(n => n.DateValue, "DATE: yyyy-MM-dd") .NumberFormatFor(n => n.DoubleValue, "0.00 $") .NumberFormatFor(n => n.IntValue, "00") .CreateExcelPackage() .Workbook.Worksheets.First(); Assert.IsTrue(excelWorksheet.Cells[2, 2].Text == DateTime.Today.ToString("DATE: yyyy-MM-dd")); //DateValue Assert.IsTrue(excelWorksheet.Cells[2, 3].Text == "10.20 $"); //DoubleValue Assert.IsTrue(excelWorksheet.Cells[2, 4].Text == "05"); //IntValue }
public void TableCreationTest() { const string tableName = "MyTable"; var data = new[] { new { TextValue = "SomeText", DateValue = DateTime.Now, DoubleValue = 10.2, IntValue = 5 } }; var exporter = EnumerableExporter.Create(data); exporter.WorksheetName = tableName; exporter.TableStyle = TableStyles.Dark10; var excelPackage = exporter.CreateExcelPackage(); var sheetToCheck = excelPackage.Workbook.Worksheets.Last(); sheetToCheck.Tables[tableName].TableStyle.ShouldBe(exporter.TableStyle); }
public void DefaultNumberFormatTest() { var data = new[] { new { TextValue = "SomeText", DateValue = DateTime.Now, DoubleValue = 10.2, IntValue = 5 } }; var excelWorksheet = EnumerableExporter.Create(data) .DefaultNumberFormat(typeof(DateTime), "DATE: yyyy-MM-dd") .DefaultNumberFormat(typeof(double), "0.00 $") .DefaultNumberFormat(typeof(int), "00") .CreateExcelPackage() .Workbook.Worksheets.First(); string numberDecimalSeparator = NumberFormatInfo.CurrentInfo.NumberDecimalSeparator; Assert.IsTrue(excelWorksheet.Cells[2, 2].Text == DateTime.Today.ToString("DATE: yyyy-MM-dd")); //DateValue Assert.IsTrue(excelWorksheet.Cells[2, 3].Text == $"10{numberDecimalSeparator}20 $"); //DoubleValue Assert.IsTrue(excelWorksheet.Cells[2, 4].Text == "05"); //IntValue }
public void WorksheetConfigurationTest() { const string newWorksheetName = "NewSheet"; var data = new[] { new { TextValue = "SomeText", DateValue = DateTime.Now, DoubleValue = 10.2, IntValue = 5 } }; var excelPackage = TestHelper.FakeAnExistingDocument(); var eporter = EnumerableExporter.Create(data); //set properties eporter.WorksheetName = newWorksheetName; eporter.AppendToExcelPackage(excelPackage); //check properties var sheetToCheck = excelPackage.Workbook.Worksheets.Last(); Assert.IsTrue(sheetToCheck.Name == newWorksheetName); }
public void NumberFormatForTest() { var data = new[] { new { TextValue = "SomeText", DateValue = DateTime.Now, DoubleValue = 10.2, IntValue = 5 } }; var excelWorksheet = EnumerableExporter.Create(data) .NumberFormatFor(n => n.DateValue, "DATE: yyyy-MM-dd") .NumberFormatFor(n => n.DoubleValue, "0.00 $") .NumberFormatFor(n => n.IntValue, "00") .CreateExcelPackage() .Workbook.Worksheets.First(); string numberDecimalSeparator = NumberFormatInfo.CurrentInfo.NumberDecimalSeparator; excelWorksheet.Cells[2, 2].Text.ShouldBe(DateTime.Today.ToString("DATE: yyyy-MM-dd")); //DateValue excelWorksheet.Cells[2, 3].Text.ShouldBe($"10{numberDecimalSeparator}20 $"); //DoubleValue excelWorksheet.Cells[2, 4].Text.ShouldBe("05"); //IntValue }
public void TextFormatForTest() { var data = new[] { new { TextValue = "SomeText", DateValue = DateTime.Now, DoubleValue = 10.2, IntValue = 5 } }; const string textFormat = "Prefix: {0}"; const string dateFormat = "{0:yyyy-MM-dd HH:mm}"; var exporter = EnumerableExporter.Create(data) .TextFormatFor(n => n.TextValue, textFormat) .TextFormatFor(n => n.DateValue, dateFormat); var excelPackage = exporter.CreateExcelPackage(); var excelWorksheet = excelPackage.Workbook.Worksheets.First(); Assert.IsTrue(excelWorksheet.Cells[2, 1].Text == string.Format(textFormat, data.First().TextValue)); //TextValue Assert.IsTrue(excelWorksheet.Cells[2, 2].Text == string.Format(dateFormat, data.First().DateValue)); //DateValue Assert.IsTrue(excelWorksheet.Cells[2, 2].Value.ToString() == string.Format(dateFormat, data.First().DateValue)); //DateValue }
public void FormulaForTest() { var data = new[] { new { TextValue = "SomeText0", DateValue = DateTime.Now, DoubleValue = 0, IntValue = 5 }, new { TextValue = "SomeText1", DateValue = DateTime.Now, DoubleValue = 1, IntValue = 5 }, new { TextValue = "SomeText2", DateValue = DateTime.Now, DoubleValue = 2, IntValue = 5 }, new { TextValue = "SomeText3", DateValue = DateTime.Now, DoubleValue = 3, IntValue = 5 } }; var exporter = EnumerableExporter.Create(data) .FormulaFor(n => n.TextValue, (row, value) => $"=\"Text=\" & \"{value}-\" & \"{row.DoubleValue:0.00}\""); var excelPackage = exporter.CreateExcelPackage(); //TestHelper.OpenDocument(excelPackage); var excelWorksheet = excelPackage.Workbook.Worksheets.First(); Assert.IsTrue(excelWorksheet.Cells[3, 1].Formula == "=\"Text=\" & \"SomeText1-\" & \"1.00\""); Assert.IsTrue(excelWorksheet.Cells[4, 1].Formula == "=\"Text=\" & \"SomeText2-\" & \"2.00\""); }
public void DisplayTest() { var data = new[] { new { TextValue = "SomeText", DateValue = DateTime.Now, DoubleValue = 10.2, IntValue = 5 } }; var excelWorksheet = EnumerableExporter.Create(data) .Ignore(n => n.DateValue) .Display(n => new { n.TextValue, n.DoubleValue }) .CreateExcelPackage() .Workbook.Worksheets.First(); excelWorksheet.Cells[1, 1].Text.ShouldBe("Text Value"); excelWorksheet.Cells[1, 2].Text.ShouldBe("Double Value"); excelWorksheet.Cells[1, 3].Text.ShouldBe(string.Empty); }
public void AutoFitColumnsTest() { var data = new[] { new { TextValue = "The quick brown fox jumps over the lazy dog", DateValue = DateTime.Now, DoubleValue = 10.2, IntValue = 5 } }; { var exporter = EnumerableExporter.Create(data, TableStyles.None) .Configure(n => n.IntValue, configuration => configuration.Width = 60); exporter.AutoFitColumns = false; var excelPackage = exporter.CreateExcelPackage(); //TestHelper.OpenDocument(excelPackage); var excelWorksheet = excelPackage.Workbook.Worksheets.First(); //The two first columns should have the same size Math.Abs(excelWorksheet.Column(1).Width - excelWorksheet.Column(2).Width).ShouldBeLessThan(0.001); Math.Abs(excelWorksheet.Column(4).Width - 60).ShouldBeLessThan(0.001); } { var exporter = EnumerableExporter.Create(data, TableStyles.None) .Configure(n => n.IntValue, configuration => configuration.Width = 60); exporter.AutoFitColumns = true; var excelPackage = exporter.CreateExcelPackage(); //TestHelper.OpenDocument(excelPackage); var excelWorksheet = excelPackage.Workbook.Worksheets.First(); var test1 = excelWorksheet.Column(1).Width; var test2 = excelWorksheet.Column(2).Width; var test4 = excelWorksheet.Column(4).Width; //The two first columns should have the same size Math.Abs(excelWorksheet.Column(1).Width - excelWorksheet.Column(2).Width).ShouldBeGreaterThan(0.001); Math.Abs(excelWorksheet.Column(4).Width - 60).ShouldBeLessThan(0.001); } }
public static void Sample3() { var data = new[] { new { TextValue = "Text #1", DateValue = DateTime.Now, DoubleValue = 10.1, IntValue = 1 }, new { TextValue = "Text #2", DateValue = DateTime.Now, DoubleValue = 10.2, IntValue = 2 }, new { TextValue = "Text #3", DateValue = DateTime.Now, DoubleValue = 10.3, IntValue = 3 }, new { TextValue = "Text #4", DateValue = DateTime.Now, DoubleValue = 10.4, IntValue = 4 } }; var exporter = EnumerableExporter.Create(data) .NumberFormatFor(n => n.DateValue, "yyyy-mmm-dd") .NumberFormatFor(n => new { n.DoubleValue, n.IntValue }, "0.00"); var excelPackage = exporter.CreateExcelPackage(); Program.SaveAndOpenDocument(excelPackage); }
public void WorksheetConfigurationTest() { const string newWorksheetName = "1 - NewSheet"; const string newWorksheetExpectedTableName = "_1_-_NewSheet"; var data = new[] { new { TextValue = "SomeText", DateValue = DateTime.Now, DoubleValue = 10.2, IntValue = 5 } }; var excelPackage = TestHelper.FakeAnExistingDocument(); var eporter = EnumerableExporter.Create(data); //set properties eporter.WorksheetName = newWorksheetName; var sheetToCheck = eporter.AppendToExcelPackage(excelPackage); //TestHelper.OpenDocument(excelPackage); //check properties Assert.IsTrue(sheetToCheck.Name == newWorksheetName); Assert.IsNotNull(sheetToCheck.Tables[newWorksheetExpectedTableName]); }
public void AppendToExcelPackageTest() { var data = new[] { new { TextValue = "SomeText", DateValue = DateTime.Now, DoubleValue = 10.2, IntValue = 5 } }; var excelPackage = TestHelper.FakeAnExistingDocument(); EnumerableExporter.Create(data) .CustomizeTable(range => { var newRange = range.Worksheet.Cells[range.End.Row, range.Start.Column, range.End.Row, range.End.Column]; newRange.Style.Fill.PatternType = ExcelFillStyle.Solid; newRange.Style.Fill.BackgroundColor.SetColor(Color.HotPink); }) .AppendToExcelPackage(excelPackage); //TestHelper.OpenDocument(excelPackage); Assert.IsTrue(excelPackage.Workbook.Worksheets.Count == 2); }
public static void Sample2() { var data = new[] { new { TextValue = "Text #1", DateValue = DateTime.Now, DoubleValue = 10.1, IntValue = 1 }, new { TextValue = "Text #2", DateValue = DateTime.Now, DoubleValue = 10.2, IntValue = 2 }, new { TextValue = "Text #3", DateValue = DateTime.Now, DoubleValue = 10.3, IntValue = 3 }, new { TextValue = "Text #4", DateValue = DateTime.Now, DoubleValue = 10.4, IntValue = 4 } }; var exporter = EnumerableExporter.Create(data) .TextFormatFor(n => n.TextValue, "Prefix: {0}") .NumberFormatFor(n => n.DateValue, "yyyy-MM-dd") .DefaultNumberFormat(typeof(double), "0.00 $") .Ignore(n => n.IntValue); exporter.WorksheetName = "MyData"; exporter.TableStyle = TableStyles.Medium2; var excelPackage = exporter.CreateExcelPackage(); Program.SaveAndOpenDocument(excelPackage); }
public void ConfigureTest() { var data = new[] { new { TextValue = "SomeText", DateValue = DateTime.Now, DoubleValue = 10.2, IntValue = 5 } }; var dynamicProperties = new[] { DynamicProperty.Create(data, "DynamicColumn1", "Display Name 1", typeof(DateTime?), n => DateTime.Now.AddDays(n.IntValue - 4)), DynamicProperty.Create(data, "DynamicColumn2", "Display Name 2", typeof(double), n => n.DoubleValue - 0.2) }; var excelPackage = EnumerableExporter.Create(data, dynamicProperties) .Configure(n => n.IntValue, configuration => { configuration.Header.Text = ""; }) .Configure(n => n.DateValue, configuration => { configuration.Header.Text = " "; configuration.Header.SetStyle = style => { style.Border.Bottom.Style = ExcelBorderStyle.Thick; }; configuration.Content.NumberFormat = "dd-MM-yyyy"; configuration.Content.SetStyle = style => { style.Border.Left.Style = ExcelBorderStyle.Dashed; style.Border.Right.Style = ExcelBorderStyle.Dashed; }; }) .Configure(new [] { "DynamicColumn1", "IntValue" }, n => { n.Header.SetStyle = style => { style.Font.Bold = true; style.Font.Color.SetColor(Color.Black); }; }) .CustomizeTable(range => { var newRange = range.Worksheet.Cells[range.End.Row, range.Start.Column, range.End.Row, range.End.Column]; newRange.Style.Fill.PatternType = ExcelFillStyle.Solid; newRange.Style.Fill.BackgroundColor.SetColor(Color.HotPink); }) .CreateExcelPackage(); //TestHelper.OpenDocument(excelPackage); var excelWorksheet = excelPackage.Workbook.Worksheets.First(); //header excelWorksheet.Cells[1, 2].Style.Border.Bottom.Style.ShouldBe(ExcelBorderStyle.Thick); excelWorksheet.Cells[1, 2].Style.Border.Bottom.Style.ShouldBe(ExcelBorderStyle.Thick); excelWorksheet.Cells[1, 2].Text.ShouldBe(" "); excelWorksheet.Cells[1, 4].Text.ShouldBe("Int Value"); excelWorksheet.Cells[1, 1].Style.Fill.BackgroundColor.Rgb.ShouldNotBe("FFFF69B4"); //data excelWorksheet.Cells[2, 2].Text.ShouldBe(DateTime.Now.ToString("dd-MM-yyyy")); excelWorksheet.Cells[2, 2].Style.Border.Left.Style.ShouldBe(ExcelBorderStyle.Dashed); excelWorksheet.Cells[2, 2].Style.Border.Right.Style.ShouldBe(ExcelBorderStyle.Dashed); excelWorksheet.Cells[2, 1].Style.Fill.BackgroundColor.Rgb.ShouldBe("FFFF69B4"); }