Ejemplo n.º 1
0
        private static Theme CreateDefaultTheme()
        {
            TableGroupStyle g3 = new TableGroupStyle
            {
                Header = new RowStyle(),
                Footer = new RowStyle()
            };

            g3.Caption = new CellStyle
            {
                HtmlCellStyle = new HtmlCellStyle {
                    CssClass = "tg3-caption"
                },
                ExcelCellStyle = new ExcelCellStyle
                {
                    BorderStyle = new BorderStyle
                    {
                        Bottom = new BorderEdgeStyle
                        {
                            Color     = ColorTranslator.FromHtml("#99BBE8"),
                            LineStyle = LineStyle.Medium
                        }
                    },
                    FontStyle = new ExcelFontStyle
                    {
                        FontName = "Segoe UI",
                        FontSize = 13,
                        Bold     = true
                    },
                    BackgroundColor = Color.White,
                    CellPadding     = 2
                }
            };

            g3.Footer.RowCell = g3.Footer.RowHeader = new CellStyle
            {
                HtmlCellStyle = new HtmlCellStyle {
                    CssClass = "tg3-f"
                },
                ExcelCellStyle = new ExcelCellStyle
                {
                    BorderStyle = new BorderStyle
                    {
                        Top = new BorderEdgeStyle
                        {
                            Color     = ColorTranslator.FromHtml("#C0C0C0"),
                            LineStyle = LineStyle.Medium
                        }
                    },
                    FontStyle = new ExcelFontStyle
                    {
                        FontName = "Segoe UI",
                        FontSize = 9,
                        Bold     = true
                    },
                    BackgroundColor = ColorTranslator.FromHtml("#EEEEEE"),
                    CellPadding     = 2
                }
            };

            g3.Footer.RowFooter = new CellStyle
            {
                HtmlCellStyle = new HtmlCellStyle {
                    CssClass = "tg3-ff"
                },
                ExcelCellStyle = new ExcelCellStyle
                {
                    BorderStyle = new BorderStyle
                    {
                        Top = new BorderEdgeStyle
                        {
                            Color     = ColorTranslator.FromHtml("#C0C0C0"),
                            LineStyle = LineStyle.Medium
                        }
                    },
                    FontStyle = new ExcelFontStyle
                    {
                        FontName = "Segoe UI",
                        FontSize = 9,
                        Bold     = true
                    },
                    BackgroundColor = ColorTranslator.FromHtml("#DFDFDF"),
                    CellPadding     = 2
                }
            };

            g3.Header.RowCell = g3.Header.RowFooter = g3.Header.RowHeader = new CellStyle
            {
                HtmlCellStyle = new HtmlCellStyle {
                    CssClass = "tg3-h"
                },
                ExcelCellStyle = new ExcelCellStyle
                {
                    BorderStyle = new BorderStyle
                    {
                        Bottom = new BorderEdgeStyle
                        {
                            Color     = ColorTranslator.FromHtml("#99BBE8"),
                            LineStyle = LineStyle.Thin
                        }
                    },
                    FontStyle = new ExcelFontStyle
                    {
                        FontName = "Segoe UI",
                        FontSize = 9,
                        Bold     = true
                    },
                    BackgroundColor = ColorTranslator.FromHtml("#E7EFFA"),
                    CellPadding     = 2
                }
            };

            TableGroupStyle g2 = new TableGroupStyle
            {
                Header = new RowStyle(),
                Footer = new RowStyle()
            };

            g2.Caption = new CellStyle
            {
                HtmlCellStyle = new HtmlCellStyle {
                    CssClass = "tg2-caption"
                },
                ExcelCellStyle = new ExcelCellStyle
                {
                    BorderStyle = new BorderStyle
                    {
                        Bottom = new BorderEdgeStyle
                        {
                            Color     = ColorTranslator.FromHtml("#99BBE8"),
                            LineStyle = LineStyle.Medium
                        }
                    },
                    FontStyle = new ExcelFontStyle
                    {
                        FontName = "Segoe UI",
                        FontSize = 11,
                        Bold     = true
                    },
                    CellPadding = 2
                }
            };

            g2.Footer.RowCell = g2.Footer.RowHeader = new CellStyle
            {
                HtmlCellStyle = new HtmlCellStyle {
                    CssClass = "tg2-f"
                },
                ExcelCellStyle = new ExcelCellStyle
                {
                    BorderStyle = new BorderStyle
                    {
                        Top = new BorderEdgeStyle
                        {
                            Color     = ColorTranslator.FromHtml("#C0C0C0"),
                            LineStyle = LineStyle.Thin
                        }
                    },
                    FontStyle = new ExcelFontStyle
                    {
                        FontName = "Segoe UI",
                        FontSize = 8,
                        Bold     = true
                    },
                    BackgroundColor = ColorTranslator.FromHtml("#EEEEEE"),
                    CellPadding     = 2
                }
            };

            g2.Footer.RowFooter = new CellStyle
            {
                HtmlCellStyle = new HtmlCellStyle {
                    CssClass = "tg2-ff"
                },
                ExcelCellStyle = new ExcelCellStyle
                {
                    BorderStyle = new BorderStyle
                    {
                        Top = new BorderEdgeStyle
                        {
                            Color     = ColorTranslator.FromHtml("#C0C0C0"),
                            LineStyle = LineStyle.Thin
                        }
                    },
                    FontStyle = new ExcelFontStyle
                    {
                        FontName = "Segoe UI",
                        FontSize = 8,
                        Bold     = true
                    },
                    BackgroundColor = ColorTranslator.FromHtml("#DFDFDF"),
                    CellPadding     = 2
                }
            };

            g2.Header.RowCell = g2.Header.RowFooter = g2.Header.RowHeader = new CellStyle
            {
                HtmlCellStyle = new HtmlCellStyle {
                    CssClass = "tg2-h"
                },
                ExcelCellStyle = new ExcelCellStyle
                {
                    BorderStyle = new BorderStyle
                    {
                        Bottom = new BorderEdgeStyle
                        {
                            Color     = ColorTranslator.FromHtml("#99BBE8"),
                            LineStyle = LineStyle.Thin
                        }
                    },
                    FontStyle = new ExcelFontStyle
                    {
                        FontName = "Segoe UI",
                        FontSize = 8,
                        Bold     = true
                    },
                    BackgroundColor = ColorTranslator.FromHtml("#E7EFFA"),
                    CellPadding     = 2
                }
            };


            TableGroupStyle g1 = new TableGroupStyle
            {
                Header = new RowStyle(),
                Footer = new RowStyle()
            };

            g1.Caption = new CellStyle
            {
                HtmlCellStyle = new HtmlCellStyle {
                    CssClass = "tg1-caption"
                },
                ExcelCellStyle = new ExcelCellStyle
                {
                    BorderStyle = new BorderStyle
                    {
                        Bottom = new BorderEdgeStyle
                        {
                            Color     = ColorTranslator.FromHtml("#99BBE8"),
                            LineStyle = LineStyle.Medium
                        }
                    },
                    FontStyle = new ExcelFontStyle
                    {
                        FontName = "Segoe UI",
                        FontSize = 9,
                        Bold     = true
                    },
                    CellPadding = 2
                }
            };

            g1.Footer.RowCell = g1.Footer.RowHeader = new CellStyle
            {
                HtmlCellStyle = new HtmlCellStyle {
                    CssClass = "tg1-f"
                },
                ExcelCellStyle = new ExcelCellStyle
                {
                    FontStyle = new ExcelFontStyle
                    {
                        FontName = "Segoe UI",
                        FontSize = 8
                    },
                    BackgroundColor = ColorTranslator.FromHtml("#EEEEEE"),
                    CellPadding     = 2
                }
            };

            g1.Footer.RowFooter = new CellStyle
            {
                HtmlCellStyle = new HtmlCellStyle {
                    CssClass = "tg1-ff"
                },
                ExcelCellStyle = new ExcelCellStyle
                {
                    FontStyle = new ExcelFontStyle
                    {
                        FontName = "Segoe UI",
                        FontSize = 8
                    },
                    BackgroundColor = ColorTranslator.FromHtml("#DFDFDF"),
                    CellPadding     = 2
                }
            };

            g1.Header.RowCell = g1.Header.RowFooter = g1.Header.RowHeader = new CellStyle
            {
                HtmlCellStyle = new HtmlCellStyle {
                    CssClass = "tg1-h"
                },
                ExcelCellStyle = new ExcelCellStyle
                {
                    BorderStyle = new BorderStyle
                    {
                        Bottom = new BorderEdgeStyle
                        {
                            Color     = ColorTranslator.FromHtml("#99BBE8"),
                            LineStyle = LineStyle.Thin
                        }
                    },
                    FontStyle = new ExcelFontStyle
                    {
                        FontName = "Segoe UI",
                        FontSize = 8,
                        Bold     = true
                    },
                    BackgroundColor = ColorTranslator.FromHtml("#E7EFFA"),
                    CellPadding     = 2
                }
            };


            var rowStyle = new RowStyle();

            rowStyle.RowHeader = rowStyle.RowCell = new CellStyle
            {
                HtmlCellStyle = new HtmlCellStyle {
                    CssClass = "tg1-r"
                },
                ExcelCellStyle = new ExcelCellStyle
                {
                    BorderStyle = new BorderStyle
                    {
                        Bottom = new BorderEdgeStyle
                        {
                            Color     = ColorTranslator.FromHtml("#EEEEEE"),
                            LineStyle = LineStyle.Thin
                        }
                    },
                    FontStyle = new ExcelFontStyle
                    {
                        FontName = "Segoe UI",
                        FontSize = 8
                    },
                    CellPadding = 2
                }
            };

            rowStyle.RowFooter = new CellStyle
            {
                HtmlCellStyle = new HtmlCellStyle {
                    CssClass = "tg1-rf"
                },
                ExcelCellStyle = new ExcelCellStyle
                {
                    BorderStyle = new BorderStyle
                    {
                        Bottom = new BorderEdgeStyle
                        {
                            Color     = ColorTranslator.FromHtml("#E5E5E5"),
                            LineStyle = LineStyle.Thin
                        }
                    },
                    FontStyle = new ExcelFontStyle
                    {
                        FontName = "Segoe UI",
                        FontSize = 8
                    },
                    BackgroundColor = ColorTranslator.FromHtml("#EEEEEE"),
                    CellPadding     = 2
                }
            };

            TableStyle ts = new TableStyle
            {
                Group1   = g1,
                Group2   = g2,
                Group3   = g3,
                RowStyle = rowStyle
            };
            var bodyStyle = new CellStyle {
            };

            LabelStyle labelStyle = new LabelStyle
            {
                Body = new CellStyle {
                    HtmlCellStyle = null, ExcelCellStyle = new ExcelCellStyle {
                        CellPadding = 2, FontStyle = new ExcelFontStyle {
                            FontName = "Segoe UI", FontSize = 8
                        }
                    }
                },
                Note = new CellStyle {
                    HtmlCellStyle = new HtmlCellStyle {
                        CssClass = "lab-note"
                    }, ExcelCellStyle = new ExcelCellStyle {
                        CellPadding = 2, FontStyle = new ExcelFontStyle {
                            FontName = "Segoe UI", FontSize = 7, Bold = true
                        }
                    }
                },
                H3 = new CellStyle {
                    HtmlCellStyle = new HtmlCellStyle {
                        CssClass = "lab-h3"
                    }, ExcelCellStyle = new ExcelCellStyle {
                        CellPadding = 2, FontStyle = new ExcelFontStyle {
                            FontName = "Segoe UI", FontSize = 9, Bold = true
                        }
                    }
                },
                H2 = new CellStyle {
                    HtmlCellStyle = new HtmlCellStyle {
                        CssClass = "lab-h2"
                    }, ExcelCellStyle = new ExcelCellStyle {
                        CellPadding = 3, FontStyle = new ExcelFontStyle {
                            FontName = "Segoe UI", FontSize = 11, Bold = true
                        }
                    }
                },
                H1 = new CellStyle {
                    HtmlCellStyle = new HtmlCellStyle {
                        CssClass = "lab-h1"
                    }, ExcelCellStyle = new ExcelCellStyle {
                        CellPadding = 3, FontStyle = new ExcelFontStyle {
                            FontName = "Segoe UI", FontSize = 13, Bold = true
                        }
                    }
                },
                Title = new CellStyle {
                    HtmlCellStyle = new HtmlCellStyle {
                        CssClass = "lab-title"
                    }, ExcelCellStyle = new ExcelCellStyle {
                        CellPadding = 4, FontStyle = new ExcelFontStyle {
                            FontName = "Segoe UI", FontSize = 15, Bold = true
                        }
                    }
                },
                Highlight = new CellStyle {
                    HtmlCellStyle = new HtmlCellStyle {
                        CssClass = "lab-highlight"
                    }, ExcelCellStyle = new ExcelCellStyle {
                        CellPadding = 2, FontStyle = new ExcelFontStyle {
                            FontName = "Segoe UI", FontSize = 8, Bold = true
                        }
                    }
                }
            };

            return(new Theme
            {
                TableStyle = ts,
                LabelStyle = labelStyle,
                PageNumberStyle = labelStyle.Body,
                PageNumberAlignment = CellAlignment.Right
            });
        }
Ejemplo n.º 2
0
        private static Theme CreateDefaultTheme()
        {
            TableGroupStyle g3 = new TableGroupStyle
            {
                Header = new RowStyle(),
                Footer = new RowStyle()
            };

            g3.Caption = new CellStyle
            {
                HtmlCellStyle = new HtmlCellStyle { CssClass = "tg3-caption" },
                ExcelCellStyle = new ExcelCellStyle
                {
                    BorderStyle = new BorderStyle
                    {
                        Bottom = new BorderEdgeStyle
                        {
                            Color = ColorTranslator.FromHtml("#99BBE8"),
                            LineStyle = LineStyle.Medium
                        }
                    },
                    FontStyle = new ExcelFontStyle
                    {
                        FontName = "Segoe UI",
                        FontSize = 13,
                        Bold = true
                    },
                    BackgroundColor = Color.White,
                    CellPadding = 2
                }
            };

            g3.Footer.RowCell = g3.Footer.RowHeader = new CellStyle
            {
                HtmlCellStyle = new HtmlCellStyle { CssClass = "tg3-f" },
                ExcelCellStyle = new ExcelCellStyle
                {
                    BorderStyle = new BorderStyle
                    {
                        Top = new BorderEdgeStyle
                        {
                            Color = ColorTranslator.FromHtml("#C0C0C0"),
                            LineStyle = LineStyle.Medium
                        }
                    },
                    FontStyle = new ExcelFontStyle
                    {
                        FontName = "Segoe UI",
                        FontSize = 9,
                        Bold = true
                    },
                    BackgroundColor = ColorTranslator.FromHtml("#EEEEEE"),
                    CellPadding = 2
                }
            };

            g3.Footer.RowFooter = new CellStyle
            {
                HtmlCellStyle = new HtmlCellStyle { CssClass = "tg3-ff" },
                ExcelCellStyle = new ExcelCellStyle
                {
                    BorderStyle = new BorderStyle
                    {
                        Top = new BorderEdgeStyle
                        {
                            Color = ColorTranslator.FromHtml("#C0C0C0"),
                            LineStyle = LineStyle.Medium
                        }
                    },
                    FontStyle = new ExcelFontStyle
                    {
                        FontName = "Segoe UI",
                        FontSize = 9,
                        Bold = true
                    },
                    BackgroundColor = ColorTranslator.FromHtml("#DFDFDF"),
                    CellPadding = 2
                }
            };

            g3.Header.RowCell = g3.Header.RowFooter = g3.Header.RowHeader = new CellStyle
            {
                HtmlCellStyle = new HtmlCellStyle { CssClass = "tg3-h" },
                ExcelCellStyle = new ExcelCellStyle
                {
                    BorderStyle = new BorderStyle
                    {
                        Bottom = new BorderEdgeStyle
                        {
                            Color = ColorTranslator.FromHtml("#99BBE8"),
                            LineStyle = LineStyle.Thin
                        }
                    },
                    FontStyle = new ExcelFontStyle
                    {
                        FontName = "Segoe UI",
                        FontSize = 9,
                        Bold = true
                    },
                    BackgroundColor = ColorTranslator.FromHtml("#E7EFFA"),
                    CellPadding = 2
                }
            };

            TableGroupStyle g2 = new TableGroupStyle
            {
                 Header = new RowStyle(),
                 Footer = new RowStyle()
            };

            g2.Caption = new CellStyle
            {
                HtmlCellStyle = new HtmlCellStyle { CssClass = "tg2-caption" },
                ExcelCellStyle = new ExcelCellStyle
                {
                    BorderStyle = new BorderStyle
                    {
                        Bottom = new BorderEdgeStyle
                        {
                            Color = ColorTranslator.FromHtml("#99BBE8"),
                            LineStyle = LineStyle.Medium
                        }
                    },
                    FontStyle = new ExcelFontStyle
                    {
                        FontName = "Segoe UI",
                        FontSize = 11,
                        Bold = true
                    },
                    CellPadding = 2
                }
            };

            g2.Footer.RowCell = g2.Footer.RowHeader= new CellStyle
            {
                HtmlCellStyle = new HtmlCellStyle { CssClass = "tg2-f" },
                ExcelCellStyle = new ExcelCellStyle
                {
                    BorderStyle = new BorderStyle
                    {
                        Top = new BorderEdgeStyle
                        {
                            Color = ColorTranslator.FromHtml("#C0C0C0"),
                            LineStyle = LineStyle.Thin
                        }
                    },
                    FontStyle = new ExcelFontStyle
                    {
                        FontName = "Segoe UI",
                        FontSize = 8,
                        Bold = true
                    },
                    BackgroundColor = ColorTranslator.FromHtml("#EEEEEE"),
                    CellPadding = 2
                }
            };

            g2.Footer.RowFooter = new CellStyle
            {
                HtmlCellStyle = new HtmlCellStyle { CssClass = "tg2-ff" },
                ExcelCellStyle = new ExcelCellStyle
                {
                    BorderStyle = new BorderStyle
                    {
                        Top = new BorderEdgeStyle
                        {
                            Color = ColorTranslator.FromHtml("#C0C0C0"),
                            LineStyle = LineStyle.Thin
                        }
                    },
                    FontStyle = new ExcelFontStyle
                    {
                        FontName = "Segoe UI",
                        FontSize = 8,
                        Bold = true
                    },
                    BackgroundColor = ColorTranslator.FromHtml("#DFDFDF"),
                    CellPadding = 2
                }
            };

            g2.Header.RowCell = g2.Header.RowFooter = g2.Header.RowHeader = new CellStyle
            {
                HtmlCellStyle = new HtmlCellStyle { CssClass = "tg2-h" },
                ExcelCellStyle = new ExcelCellStyle
                {
                    BorderStyle = new BorderStyle
                    {
                        Bottom = new BorderEdgeStyle
                        {
                            Color = ColorTranslator.FromHtml("#99BBE8"),
                            LineStyle = LineStyle.Thin
                        }
                    },
                    FontStyle = new ExcelFontStyle
                    {
                        FontName = "Segoe UI",
                        FontSize = 8,
                        Bold = true
                    },
                    BackgroundColor = ColorTranslator.FromHtml("#E7EFFA"),
                    CellPadding = 2
                }
            };

            TableGroupStyle g1 = new TableGroupStyle
            {
                Header = new RowStyle(),
                Footer = new RowStyle()
            };

            g1.Caption = new CellStyle
            {
                HtmlCellStyle = new HtmlCellStyle { CssClass = "tg1-caption" },
                ExcelCellStyle = new ExcelCellStyle
                {
                    BorderStyle = new BorderStyle
                    {
                        Bottom = new BorderEdgeStyle
                        {
                            Color = ColorTranslator.FromHtml("#99BBE8"),
                            LineStyle = LineStyle.Medium
                        }
                    },
                    FontStyle = new ExcelFontStyle
                    {
                        FontName = "Segoe UI",
                        FontSize = 9,
                        Bold = true
                    },
                    CellPadding = 2
                }
            };

            g1.Footer.RowCell = g1.Footer.RowHeader = new CellStyle
            {
                HtmlCellStyle = new HtmlCellStyle { CssClass = "tg1-f" },
                ExcelCellStyle = new ExcelCellStyle
                {
                    FontStyle = new ExcelFontStyle
                    {
                        FontName = "Segoe UI",
                        FontSize = 8
                    },
                    BackgroundColor = ColorTranslator.FromHtml("#EEEEEE"),
                    CellPadding = 2
                }
            };

            g1.Footer.RowFooter = new CellStyle
            {
                HtmlCellStyle = new HtmlCellStyle { CssClass = "tg1-ff" },
                ExcelCellStyle = new ExcelCellStyle
                {
                    FontStyle = new ExcelFontStyle
                    {
                        FontName = "Segoe UI",
                        FontSize = 8
                    },
                    BackgroundColor = ColorTranslator.FromHtml("#DFDFDF"),
                    CellPadding = 2
                }
            };

            g1.Header.RowCell = g1.Header.RowFooter = g1.Header.RowHeader = new CellStyle
            {
                HtmlCellStyle = new HtmlCellStyle { CssClass = "tg1-h" },
                ExcelCellStyle = new ExcelCellStyle
                {
                    BorderStyle = new BorderStyle
                    {
                        Bottom = new BorderEdgeStyle
                        {
                            Color = ColorTranslator.FromHtml("#99BBE8"),
                            LineStyle = LineStyle.Thin
                        }
                    },
                    FontStyle = new ExcelFontStyle
                    {
                        FontName = "Segoe UI",
                        FontSize = 8,
                        Bold = true
                    },
                    BackgroundColor = ColorTranslator.FromHtml("#E7EFFA"),
                    CellPadding = 2
                }
            };

            var rowStyle = new RowStyle();

            rowStyle.RowHeader = rowStyle.RowCell = new CellStyle
            {
                HtmlCellStyle = new HtmlCellStyle { CssClass = "tg1-r" },
                ExcelCellStyle = new ExcelCellStyle
                {
                    BorderStyle = new BorderStyle
                    {
                        Bottom = new BorderEdgeStyle
                        {
                            Color = ColorTranslator.FromHtml("#EEEEEE"),
                            LineStyle = LineStyle.Thin
                        }
                    },
                    FontStyle = new ExcelFontStyle
                    {
                        FontName = "Segoe UI",
                        FontSize = 8
                    },
                    CellPadding = 2
                }
            };

            rowStyle.RowFooter = new CellStyle
            {
                HtmlCellStyle = new HtmlCellStyle { CssClass = "tg1-rf" },
                ExcelCellStyle = new ExcelCellStyle
                {
                    BorderStyle = new BorderStyle
                    {
                        Bottom = new BorderEdgeStyle
                        {
                            Color = ColorTranslator.FromHtml("#E5E5E5"),
                            LineStyle = LineStyle.Thin
                        }
                    },
                    FontStyle = new ExcelFontStyle
                    {
                        FontName = "Segoe UI",
                        FontSize = 8
                    },
                    BackgroundColor = ColorTranslator.FromHtml("#EEEEEE"),
                    CellPadding = 2
                }
            };

            TableStyle ts = new TableStyle
            {
                Group1 = g1,
                Group2 = g2,
                Group3 = g3,
                RowStyle = rowStyle
            };
            var bodyStyle = new CellStyle { };

            LabelStyle labelStyle = new LabelStyle
            {
                Body = new CellStyle { HtmlCellStyle = null, ExcelCellStyle = new ExcelCellStyle { CellPadding = 2, FontStyle = new ExcelFontStyle { FontName = "Segoe UI", FontSize = 8 } } },
                Note = new CellStyle { HtmlCellStyle = new HtmlCellStyle { CssClass = "lab-note" }, ExcelCellStyle = new ExcelCellStyle { CellPadding = 2, FontStyle = new ExcelFontStyle { FontName = "Segoe UI", FontSize = 7, Bold = true } } },
                H3 = new CellStyle { HtmlCellStyle = new HtmlCellStyle { CssClass = "lab-h3" }, ExcelCellStyle = new ExcelCellStyle { CellPadding = 2, FontStyle = new ExcelFontStyle { FontName = "Segoe UI", FontSize = 9, Bold = true } } },
                H2 = new CellStyle { HtmlCellStyle = new HtmlCellStyle { CssClass = "lab-h2" }, ExcelCellStyle = new ExcelCellStyle { CellPadding = 3, FontStyle = new ExcelFontStyle { FontName = "Segoe UI", FontSize = 11, Bold = true } } },
                H1 = new CellStyle { HtmlCellStyle = new HtmlCellStyle { CssClass = "lab-h1" }, ExcelCellStyle = new ExcelCellStyle { CellPadding = 3, FontStyle = new ExcelFontStyle { FontName = "Segoe UI", FontSize = 13, Bold = true } } },
                Title = new CellStyle { HtmlCellStyle = new HtmlCellStyle { CssClass = "lab-title" }, ExcelCellStyle = new ExcelCellStyle { CellPadding = 4, FontStyle = new ExcelFontStyle { FontName = "Segoe UI", FontSize = 15, Bold = true } } },
                Highlight = new CellStyle { HtmlCellStyle = new HtmlCellStyle { CssClass = "lab-highlight" }, ExcelCellStyle = new ExcelCellStyle { CellPadding = 2, FontStyle = new ExcelFontStyle { FontName = "Segoe UI", FontSize = 8, Bold = true } } }
            };

            return new Theme
            {
                TableStyle = ts,
                LabelStyle = labelStyle,
                PageNumberStyle = labelStyle.Body,
                PageNumberAlignment = CellAlignment.Right
            };
        }