public SubstationsBalanceExport(ExportInfo info) : base(info)
        {
            tableStyle = CreateStyle("style_table");
            tableStyle.Border.Left.Style               =
                tableStyle.Border.Top.Style            =
                    tableStyle.Border.Right.Style      =
                        tableStyle.Border.Bottom.Style = OfficeOpenXml.Style.ExcelBorderStyle.Thin;
            tableStyle.VerticalAlignment               = OfficeOpenXml.Style.ExcelVerticalAlignment.Center;
            tableStyle.HorizontalAlignment             = OfficeOpenXml.Style.ExcelHorizontalAlignment.Center;
            tableStyle.WrapText  = true;
            tableStyle.Font.Bold = true;


            dottedTableCell = CreateStyle("style_dottedTableCell");
            dottedTableCell.Border.Left.Style               =
                dottedTableCell.Border.Right.Style          =
                    dottedTableCell.Border.Top.Style        =
                        dottedTableCell.Border.Bottom.Style = OfficeOpenXml.Style.ExcelBorderStyle.Dotted;
            dottedTableCell.HorizontalAlignment             = OfficeOpenXml.Style.ExcelHorizontalAlignment.Center;
            dottedTableCell.VerticalAlignment               = OfficeOpenXml.Style.ExcelVerticalAlignment.Center;

            titleStyle = base.CreateStyle("style_title");
            titleStyle.HorizontalAlignment = OfficeOpenXml.Style.ExcelHorizontalAlignment.Center;
            titleStyle.VerticalAlignment   = OfficeOpenXml.Style.ExcelVerticalAlignment.Center;
            titleStyle.Font.Bold           = true;
            titleStyle.Font.Name           = "Segoe UI";
            titleStyle.Font.Size           = 14f;
            titleStyle.Font.Color.SetColor(System.Drawing.Color.Navy);
            titleStyle.WrapText = true;
        }
Ejemplo n.º 2
0
 public FiderAnaliz(ExportInfo info) : base(info)
 {
     tableStyle = CreateStyle("style_table");
     tableStyle.Border.Left.Style               =
         tableStyle.Border.Top.Style            =
             tableStyle.Border.Right.Style      =
                 tableStyle.Border.Bottom.Style = OfficeOpenXml.Style.ExcelBorderStyle.Thin;
     tableStyle.VerticalAlignment               = OfficeOpenXml.Style.ExcelVerticalAlignment.Center;
     tableStyle.HorizontalAlignment             = OfficeOpenXml.Style.ExcelHorizontalAlignment.Center;
     tableStyle.WrapText  = true;
     tableStyle.Font.Bold = true;
 }
Ejemplo n.º 3
0
 public BaseExport(ExportInfo info) : this()
 {
     exportInfo = info;
 }