using System; using System.IO; using System.Globalization; using FlexCel.Core; using FlexCel.XlsAdapter; public class ApiMateExample { public void CreateAndSaveFile() { XlsFile xls = new XlsFile(true); CreateFile(xls); //Save the file as XLS xls.Save(openFileDialog1.FileName); } public void CreateFile(ExcelFile xls) { xls.NewFile(2, TExcelFileFormat.v2010); //Create a new Excel file with 2 sheets. //Set the names of the sheets xls.ActiveSheet = 1; xls.SheetName = "Parameters"; xls.ActiveSheet = 2; xls.SheetName = "Chart TOP Destinations"; xls.ActiveSheet = 2; //Set the sheet we are working in. //Sheet Options xls.SheetZoom = 116; xls.SheetView = new TSheetView(TSheetViewType.Normal, true, true, 116, 0, 0); //There are 2 ways to set the sheet options. You can use the code above to set them all, or the commented code after it to set them one by one. xls.SheetOptions = TSheetOptions.ZeroValues | TSheetOptions.AutomaticGridLineColors | TSheetOptions.OutlineSymbols; // xls.ShowGridLines = false; // xls.ShowGridHeadings = false; //Styles. TFlxFormat StyleFmt; StyleFmt = xls.GetStyle(xls.GetBuiltInStyleName(TBuiltInStyle.Normal, 0)); StyleFmt.FillPattern.Pattern = TFlxPatternStyle.Solid; StyleFmt.FillPattern.FgColor = TExcelColor.FromTheme(TThemeColor.Accent1, 0.79998168889431); StyleFmt.FillPattern.BgColor = TExcelColor.Automatic; xls.SetStyle("20 % - Akzent1", StyleFmt); StyleFmt = xls.GetStyle(xls.GetBuiltInStyleName(TBuiltInStyle.Normal, 0)); StyleFmt.FillPattern.Pattern = TFlxPatternStyle.Solid; StyleFmt.FillPattern.FgColor = TExcelColor.FromTheme(TThemeColor.Accent2, 0.79998168889431); StyleFmt.FillPattern.BgColor = TExcelColor.Automatic; xls.SetStyle("20 % - Akzent2", StyleFmt); StyleFmt = xls.GetStyle(xls.GetBuiltInStyleName(TBuiltInStyle.Normal, 0)); StyleFmt.FillPattern.Pattern = TFlxPatternStyle.Solid; StyleFmt.FillPattern.FgColor = TExcelColor.FromTheme(TThemeColor.Accent3, 0.79998168889431); StyleFmt.FillPattern.BgColor = TExcelColor.Automatic; xls.SetStyle("20 % - Akzent3", StyleFmt); StyleFmt = xls.GetStyle(xls.GetBuiltInStyleName(TBuiltInStyle.Normal, 0)); StyleFmt.FillPattern.Pattern = TFlxPatternStyle.Solid; StyleFmt.FillPattern.FgColor = TExcelColor.FromTheme(TThemeColor.Accent4, 0.79998168889431); StyleFmt.FillPattern.BgColor = TExcelColor.Automatic; xls.SetStyle("20 % - Akzent4", StyleFmt); StyleFmt = xls.GetStyle(xls.GetBuiltInStyleName(TBuiltInStyle.Normal, 0)); StyleFmt.FillPattern.Pattern = TFlxPatternStyle.Solid; StyleFmt.FillPattern.FgColor = TExcelColor.FromTheme(TThemeColor.Accent5, 0.79998168889431); StyleFmt.FillPattern.BgColor = TExcelColor.Automatic; xls.SetStyle("20 % - Akzent5", StyleFmt); StyleFmt = xls.GetStyle(xls.GetBuiltInStyleName(TBuiltInStyle.Normal, 0)); StyleFmt.FillPattern.Pattern = TFlxPatternStyle.Solid; StyleFmt.FillPattern.FgColor = TExcelColor.FromTheme(TThemeColor.Accent6, 0.79998168889431); StyleFmt.FillPattern.BgColor = TExcelColor.Automatic; xls.SetStyle("20 % - Akzent6", StyleFmt); StyleFmt = xls.GetStyle(xls.GetBuiltInStyleName(TBuiltInStyle.Normal, 0)); StyleFmt.FillPattern.Pattern = TFlxPatternStyle.Solid; StyleFmt.FillPattern.FgColor = TExcelColor.FromTheme(TThemeColor.Accent1, 0.59999389629811); StyleFmt.FillPattern.BgColor = TExcelColor.Automatic; xls.SetStyle("40 % - Akzent1", StyleFmt); StyleFmt = xls.GetStyle(xls.GetBuiltInStyleName(TBuiltInStyle.Normal, 0)); StyleFmt.FillPattern.Pattern = TFlxPatternStyle.Solid; StyleFmt.FillPattern.FgColor = TExcelColor.FromTheme(TThemeColor.Accent2, 0.59999389629811); StyleFmt.FillPattern.BgColor = TExcelColor.Automatic; xls.SetStyle("40 % - Akzent2", StyleFmt); StyleFmt = xls.GetStyle(xls.GetBuiltInStyleName(TBuiltInStyle.Normal, 0)); StyleFmt.FillPattern.Pattern = TFlxPatternStyle.Solid; StyleFmt.FillPattern.FgColor = TExcelColor.FromTheme(TThemeColor.Accent3, 0.59999389629811); StyleFmt.FillPattern.BgColor = TExcelColor.Automatic; xls.SetStyle("40 % - Akzent3", StyleFmt); StyleFmt = xls.GetStyle(xls.GetBuiltInStyleName(TBuiltInStyle.Normal, 0)); StyleFmt.FillPattern.Pattern = TFlxPatternStyle.Solid; StyleFmt.FillPattern.FgColor = TExcelColor.FromTheme(TThemeColor.Accent4, 0.59999389629811); StyleFmt.FillPattern.BgColor = TExcelColor.Automatic; xls.SetStyle("40 % - Akzent4", StyleFmt); StyleFmt = xls.GetStyle(xls.GetBuiltInStyleName(TBuiltInStyle.Normal, 0)); StyleFmt.FillPattern.Pattern = TFlxPatternStyle.Solid; StyleFmt.FillPattern.FgColor = TExcelColor.FromTheme(TThemeColor.Accent5, 0.59999389629811); StyleFmt.FillPattern.BgColor = TExcelColor.Automatic; xls.SetStyle("40 % - Akzent5", StyleFmt); StyleFmt = xls.GetStyle(xls.GetBuiltInStyleName(TBuiltInStyle.Normal, 0)); StyleFmt.FillPattern.Pattern = TFlxPatternStyle.Solid; StyleFmt.FillPattern.FgColor = TExcelColor.FromTheme(TThemeColor.Accent6, 0.59999389629811); StyleFmt.FillPattern.BgColor = TExcelColor.Automatic; xls.SetStyle("40 % - Akzent6", StyleFmt); StyleFmt = xls.GetStyle(xls.GetBuiltInStyleName(TBuiltInStyle.Normal, 0)); StyleFmt.Font.Color = TExcelColor.FromTheme(TThemeColor.Light1); StyleFmt.FillPattern.Pattern = TFlxPatternStyle.Solid; StyleFmt.FillPattern.FgColor = TExcelColor.FromTheme(TThemeColor.Accent1, 0.39997558519242); StyleFmt.FillPattern.BgColor = TExcelColor.Automatic; xls.SetStyle("60 % - Akzent1", StyleFmt); StyleFmt = xls.GetStyle(xls.GetBuiltInStyleName(TBuiltInStyle.Normal, 0)); StyleFmt.Font.Color = TExcelColor.FromTheme(TThemeColor.Light1); StyleFmt.FillPattern.Pattern = TFlxPatternStyle.Solid; StyleFmt.FillPattern.FgColor = TExcelColor.FromTheme(TThemeColor.Accent2, 0.39997558519242); StyleFmt.FillPattern.BgColor = TExcelColor.Automatic; xls.SetStyle("60 % - Akzent2", StyleFmt); StyleFmt = xls.GetStyle(xls.GetBuiltInStyleName(TBuiltInStyle.Normal, 0)); StyleFmt.Font.Color = TExcelColor.FromTheme(TThemeColor.Light1); StyleFmt.FillPattern.Pattern = TFlxPatternStyle.Solid; StyleFmt.FillPattern.FgColor = TExcelColor.FromTheme(TThemeColor.Accent3, 0.39997558519242); StyleFmt.FillPattern.BgColor = TExcelColor.Automatic; xls.SetStyle("60 % - Akzent3", StyleFmt); StyleFmt = xls.GetStyle(xls.GetBuiltInStyleName(TBuiltInStyle.Normal, 0)); StyleFmt.Font.Color = TExcelColor.FromTheme(TThemeColor.Light1); StyleFmt.FillPattern.Pattern = TFlxPatternStyle.Solid; StyleFmt.FillPattern.FgColor = TExcelColor.FromTheme(TThemeColor.Accent4, 0.39997558519242); StyleFmt.FillPattern.BgColor = TExcelColor.Automatic; xls.SetStyle("60 % - Akzent4", StyleFmt); StyleFmt = xls.GetStyle(xls.GetBuiltInStyleName(TBuiltInStyle.Normal, 0)); StyleFmt.Font.Color = TExcelColor.FromTheme(TThemeColor.Light1); StyleFmt.FillPattern.Pattern = TFlxPatternStyle.Solid; StyleFmt.FillPattern.FgColor = TExcelColor.FromTheme(TThemeColor.Accent5, 0.39997558519242); StyleFmt.FillPattern.BgColor = TExcelColor.Automatic; xls.SetStyle("60 % - Akzent5", StyleFmt); StyleFmt = xls.GetStyle(xls.GetBuiltInStyleName(TBuiltInStyle.Normal, 0)); StyleFmt.Font.Color = TExcelColor.FromTheme(TThemeColor.Light1); StyleFmt.FillPattern.Pattern = TFlxPatternStyle.Solid; StyleFmt.FillPattern.FgColor = TExcelColor.FromTheme(TThemeColor.Accent6, 0.39997558519242); StyleFmt.FillPattern.BgColor = TExcelColor.Automatic; xls.SetStyle("60 % - Akzent6", StyleFmt); StyleFmt = xls.GetStyle(xls.GetBuiltInStyleName(TBuiltInStyle.Normal, 0)); StyleFmt.Font.Color = TExcelColor.FromTheme(TThemeColor.Light1); StyleFmt.FillPattern.Pattern = TFlxPatternStyle.Solid; StyleFmt.FillPattern.FgColor = TExcelColor.FromTheme(TThemeColor.Accent1); StyleFmt.FillPattern.BgColor = TExcelColor.Automatic; xls.SetStyle("Akzent1", StyleFmt); StyleFmt = xls.GetStyle(xls.GetBuiltInStyleName(TBuiltInStyle.Normal, 0)); StyleFmt.Font.Color = TExcelColor.FromTheme(TThemeColor.Light1); StyleFmt.FillPattern.Pattern = TFlxPatternStyle.Solid; StyleFmt.FillPattern.FgColor = TExcelColor.FromTheme(TThemeColor.Accent2); StyleFmt.FillPattern.BgColor = TExcelColor.Automatic; xls.SetStyle("Akzent2", StyleFmt); StyleFmt = xls.GetStyle(xls.GetBuiltInStyleName(TBuiltInStyle.Normal, 0)); StyleFmt.Font.Color = TExcelColor.FromTheme(TThemeColor.Light1); StyleFmt.FillPattern.Pattern = TFlxPatternStyle.Solid; StyleFmt.FillPattern.FgColor = TExcelColor.FromTheme(TThemeColor.Accent3); StyleFmt.FillPattern.BgColor = TExcelColor.Automatic; xls.SetStyle("Akzent3", StyleFmt); StyleFmt = xls.GetStyle(xls.GetBuiltInStyleName(TBuiltInStyle.Normal, 0)); StyleFmt.Font.Color = TExcelColor.FromTheme(TThemeColor.Light1); StyleFmt.FillPattern.Pattern = TFlxPatternStyle.Solid; StyleFmt.FillPattern.FgColor = TExcelColor.FromTheme(TThemeColor.Accent4); StyleFmt.FillPattern.BgColor = TExcelColor.Automatic; xls.SetStyle("Akzent4", StyleFmt); StyleFmt = xls.GetStyle(xls.GetBuiltInStyleName(TBuiltInStyle.Normal, 0)); StyleFmt.Font.Color = TExcelColor.FromTheme(TThemeColor.Light1); StyleFmt.FillPattern.Pattern = TFlxPatternStyle.Solid; StyleFmt.FillPattern.FgColor = TExcelColor.FromTheme(TThemeColor.Accent5); StyleFmt.FillPattern.BgColor = TExcelColor.Automatic; xls.SetStyle("Akzent5", StyleFmt); StyleFmt = xls.GetStyle(xls.GetBuiltInStyleName(TBuiltInStyle.Normal, 0)); StyleFmt.Font.Color = TExcelColor.FromTheme(TThemeColor.Light1); StyleFmt.FillPattern.Pattern = TFlxPatternStyle.Solid; StyleFmt.FillPattern.FgColor = TExcelColor.FromTheme(TThemeColor.Accent6); StyleFmt.FillPattern.BgColor = TExcelColor.Automatic; xls.SetStyle("Akzent6", StyleFmt); StyleFmt = xls.GetStyle(xls.GetBuiltInStyleName(TBuiltInStyle.Normal, 0)); StyleFmt.Font.Color = TExcelColor.FromArgb(0x3F, 0x3F, 0x3F); StyleFmt.Font.Style = TFlxFontStyles.Bold; StyleFmt.Borders.Left.Style = TFlxBorderStyle.Thin; StyleFmt.Borders.Left.Color = TExcelColor.FromArgb(0x3F, 0x3F, 0x3F); StyleFmt.Borders.Right.Style = TFlxBorderStyle.Thin; StyleFmt.Borders.Right.Color = TExcelColor.FromArgb(0x3F, 0x3F, 0x3F); StyleFmt.Borders.Top.Style = TFlxBorderStyle.Thin; StyleFmt.Borders.Top.Color = TExcelColor.FromArgb(0x3F, 0x3F, 0x3F); StyleFmt.Borders.Bottom.Style = TFlxBorderStyle.Thin; StyleFmt.Borders.Bottom.Color = TExcelColor.FromArgb(0x3F, 0x3F, 0x3F); StyleFmt.FillPattern.Pattern = TFlxPatternStyle.Solid; StyleFmt.FillPattern.FgColor = TExcelColor.FromArgb(0xF2, 0xF2, 0xF2); StyleFmt.FillPattern.BgColor = TExcelColor.Automatic; xls.SetStyle("Ausgabe", StyleFmt); StyleFmt = xls.GetStyle(xls.GetBuiltInStyleName(TBuiltInStyle.Normal, 0)); StyleFmt.Font.Color = TExcelColor.FromArgb(0xFA, 0x7D, 0x00); StyleFmt.Font.Style = TFlxFontStyles.Bold; StyleFmt.Borders.Left.Style = TFlxBorderStyle.Thin; StyleFmt.Borders.Left.Color = TExcelColor.FromArgb(0x7F, 0x7F, 0x7F); StyleFmt.Borders.Right.Style = TFlxBorderStyle.Thin; StyleFmt.Borders.Right.Color = TExcelColor.FromArgb(0x7F, 0x7F, 0x7F); StyleFmt.Borders.Top.Style = TFlxBorderStyle.Thin; StyleFmt.Borders.Top.Color = TExcelColor.FromArgb(0x7F, 0x7F, 0x7F); StyleFmt.Borders.Bottom.Style = TFlxBorderStyle.Thin; StyleFmt.Borders.Bottom.Color = TExcelColor.FromArgb(0x7F, 0x7F, 0x7F); StyleFmt.FillPattern.Pattern = TFlxPatternStyle.Solid; StyleFmt.FillPattern.FgColor = TExcelColor.FromArgb(0xF2, 0xF2, 0xF2); StyleFmt.FillPattern.BgColor = TExcelColor.Automatic; xls.SetStyle("Berechnung", StyleFmt); StyleFmt = xls.GetStyle(xls.GetBuiltInStyleName(TBuiltInStyle.Normal, 0)); StyleFmt.Font.Color = TExcelColor.FromArgb(0x3F, 0x3F, 0x76); StyleFmt.Borders.Left.Style = TFlxBorderStyle.Thin; StyleFmt.Borders.Left.Color = TExcelColor.FromArgb(0x7F, 0x7F, 0x7F); StyleFmt.Borders.Right.Style = TFlxBorderStyle.Thin; StyleFmt.Borders.Right.Color = TExcelColor.FromArgb(0x7F, 0x7F, 0x7F); StyleFmt.Borders.Top.Style = TFlxBorderStyle.Thin; StyleFmt.Borders.Top.Color = TExcelColor.FromArgb(0x7F, 0x7F, 0x7F); StyleFmt.Borders.Bottom.Style = TFlxBorderStyle.Thin; StyleFmt.Borders.Bottom.Color = TExcelColor.FromArgb(0x7F, 0x7F, 0x7F); StyleFmt.FillPattern.Pattern = TFlxPatternStyle.Solid; StyleFmt.FillPattern.FgColor = TExcelColor.FromArgb(0xFF, 0xCC, 0x99); StyleFmt.FillPattern.BgColor = TExcelColor.Automatic; xls.SetStyle("Eingabe", StyleFmt); StyleFmt = xls.GetStyle(xls.GetBuiltInStyleName(TBuiltInStyle.Normal, 0)); StyleFmt.Font.Style = TFlxFontStyles.Bold; StyleFmt.Borders.Top.Style = TFlxBorderStyle.Thin; StyleFmt.Borders.Top.Color = TExcelColor.FromTheme(TThemeColor.Accent1); StyleFmt.Borders.Bottom.Style = TFlxBorderStyle.Double; StyleFmt.Borders.Bottom.Color = TExcelColor.FromTheme(TThemeColor.Accent1); xls.SetStyle("Ergebnis", StyleFmt); StyleFmt = xls.GetStyle(xls.GetBuiltInStyleName(TBuiltInStyle.Normal, 0)); StyleFmt.Font.Color = TExcelColor.FromArgb(0x7F, 0x7F, 0x7F); StyleFmt.Font.Style = TFlxFontStyles.Italic; xls.SetStyle("Erklärender Text", StyleFmt); StyleFmt = xls.GetStyle(xls.GetBuiltInStyleName(TBuiltInStyle.Normal, 0)); StyleFmt.Font.Color = TExcelColor.FromArgb(0x00, 0x61, 0x00); StyleFmt.FillPattern.Pattern = TFlxPatternStyle.Solid; StyleFmt.FillPattern.FgColor = TExcelColor.FromArgb(0xC6, 0xEF, 0xCE); StyleFmt.FillPattern.BgColor = TExcelColor.Automatic; xls.SetStyle("Gut", StyleFmt); StyleFmt = xls.GetStyle(xls.GetBuiltInStyleName(TBuiltInStyle.Normal, 0)); StyleFmt.Borders.Left.Style = TFlxBorderStyle.Thin; StyleFmt.Borders.Left.Color = TExcelColor.FromArgb(0xB2, 0xB2, 0xB2); StyleFmt.Borders.Right.Style = TFlxBorderStyle.Thin; StyleFmt.Borders.Right.Color = TExcelColor.FromArgb(0xB2, 0xB2, 0xB2); StyleFmt.Borders.Top.Style = TFlxBorderStyle.Thin; StyleFmt.Borders.Top.Color = TExcelColor.FromArgb(0xB2, 0xB2, 0xB2); StyleFmt.Borders.Bottom.Style = TFlxBorderStyle.Thin; StyleFmt.Borders.Bottom.Color = TExcelColor.FromArgb(0xB2, 0xB2, 0xB2); StyleFmt.FillPattern.Pattern = TFlxPatternStyle.Solid; StyleFmt.FillPattern.FgColor = TExcelColor.FromArgb(0xFF, 0xFF, 0xCC); StyleFmt.FillPattern.BgColor = TExcelColor.Automatic; xls.SetStyle("Notiz", StyleFmt); StyleFmt = xls.GetStyle(xls.GetBuiltInStyleName(TBuiltInStyle.Normal, 0)); StyleFmt.Font.Color = TExcelColor.FromArgb(0x9C, 0x00, 0x06); StyleFmt.FillPattern.Pattern = TFlxPatternStyle.Solid; StyleFmt.FillPattern.FgColor = TExcelColor.FromArgb(0xFF, 0xC7, 0xCE); StyleFmt.FillPattern.BgColor = TExcelColor.Automatic; xls.SetStyle("Schlecht", StyleFmt); StyleFmt = xls.GetStyle(xls.GetBuiltInStyleName(TBuiltInStyle.Normal, 0)); StyleFmt.Font.Name = "Arial"; StyleFmt.Font.Size20 = 200; StyleFmt.Font.Color = TExcelColor.Automatic; StyleFmt.Font.Scheme = TFontScheme.None; xls.SetStyle("Standard 2", StyleFmt); StyleFmt = xls.GetStyle(xls.GetBuiltInStyleName(TBuiltInStyle.Normal, 0)); StyleFmt.Font.Name = "Cambria"; StyleFmt.Font.Size20 = 360; StyleFmt.Font.Color = TExcelColor.FromTheme(TThemeColor.Dark2); StyleFmt.Font.Style = TFlxFontStyles.Bold; StyleFmt.Font.Scheme = TFontScheme.Major; xls.SetStyle("Überschrift", StyleFmt); StyleFmt = xls.GetStyle(xls.GetBuiltInStyleName(TBuiltInStyle.Normal, 0)); StyleFmt.Font.Size20 = 300; StyleFmt.Font.Color = TExcelColor.FromTheme(TThemeColor.Dark2); StyleFmt.Font.Style = TFlxFontStyles.Bold; StyleFmt.Borders.Bottom.Style = TFlxBorderStyle.Thick; StyleFmt.Borders.Bottom.Color = TExcelColor.FromTheme(TThemeColor.Accent1); xls.SetStyle("Überschrift 1", StyleFmt); StyleFmt = xls.GetStyle(xls.GetBuiltInStyleName(TBuiltInStyle.Normal, 0)); StyleFmt.Font.Size20 = 260; StyleFmt.Font.Color = TExcelColor.FromTheme(TThemeColor.Dark2); StyleFmt.Font.Style = TFlxFontStyles.Bold; StyleFmt.Borders.Bottom.Style = TFlxBorderStyle.Thick; StyleFmt.Borders.Bottom.Color = TExcelColor.FromTheme(TThemeColor.Accent1, 0.49998474074526); xls.SetStyle("Überschrift 2", StyleFmt); StyleFmt = xls.GetStyle(xls.GetBuiltInStyleName(TBuiltInStyle.Normal, 0)); StyleFmt.Font.Color = TExcelColor.FromTheme(TThemeColor.Dark2); StyleFmt.Font.Style = TFlxFontStyles.Bold; StyleFmt.Borders.Bottom.Style = TFlxBorderStyle.Medium; StyleFmt.Borders.Bottom.Color = TExcelColor.FromTheme(TThemeColor.Accent1, 0.39997558519242); xls.SetStyle("Überschrift 3", StyleFmt); StyleFmt = xls.GetStyle(xls.GetBuiltInStyleName(TBuiltInStyle.Normal, 0)); StyleFmt.Font.Color = TExcelColor.FromTheme(TThemeColor.Dark2); StyleFmt.Font.Style = TFlxFontStyles.Bold; xls.SetStyle("Überschrift 4", StyleFmt); StyleFmt = xls.GetStyle(xls.GetBuiltInStyleName(TBuiltInStyle.Normal, 0)); StyleFmt.Font.Color = TExcelColor.FromArgb(0xFA, 0x7D, 0x00); StyleFmt.Borders.Bottom.Style = TFlxBorderStyle.Double; StyleFmt.Borders.Bottom.Color = TExcelColor.FromArgb(0xFF, 0x80, 0x01); xls.SetStyle("Verknüpfte Zelle", StyleFmt); StyleFmt = xls.GetStyle(xls.GetBuiltInStyleName(TBuiltInStyle.Normal, 0)); StyleFmt.Font.Color = TExcelColor.FromArgb(0xFF, 0x00, 0x00); xls.SetStyle("Warnender Text", StyleFmt); StyleFmt = xls.GetStyle(xls.GetBuiltInStyleName(TBuiltInStyle.Normal, 0)); StyleFmt.Font.Color = TExcelColor.FromTheme(TThemeColor.Light1); StyleFmt.Font.Style = TFlxFontStyles.Bold; StyleFmt.Borders.Left.Style = TFlxBorderStyle.Double; StyleFmt.Borders.Left.Color = TExcelColor.FromArgb(0x3F, 0x3F, 0x3F); StyleFmt.Borders.Right.Style = TFlxBorderStyle.Double; StyleFmt.Borders.Right.Color = TExcelColor.FromArgb(0x3F, 0x3F, 0x3F); StyleFmt.Borders.Top.Style = TFlxBorderStyle.Double; StyleFmt.Borders.Top.Color = TExcelColor.FromArgb(0x3F, 0x3F, 0x3F); StyleFmt.Borders.Bottom.Style = TFlxBorderStyle.Double; StyleFmt.Borders.Bottom.Color = TExcelColor.FromArgb(0x3F, 0x3F, 0x3F); StyleFmt.FillPattern.Pattern = TFlxPatternStyle.Solid; StyleFmt.FillPattern.FgColor = TExcelColor.FromArgb(0xA5, 0xA5, 0xA5); StyleFmt.FillPattern.BgColor = TExcelColor.Automatic; xls.SetStyle("Zelle überprüfen", StyleFmt); //Named Ranges TXlsNamedRange Range; Range = new TXlsNamedRange("AIRLINE_1_1", 1, 0, "=Parameters!$D$7"); //You could also use: Range = new TXlsNamedRange("AIRLINE_1_1", 1, 1, 7, 4, 7, 4, 0); xls.SetNamedRange(Range); Range = new TXlsNamedRange("AIRLINE_2_1", 0, 0, "='#REF!'!$B$6"); xls.SetNamedRange(Range); Range = new TXlsNamedRange("AIRLINE_CODE_1_3", 0, 0, "='#REF!'!$N$26"); xls.SetNamedRange(Range); Range = new TXlsNamedRange("AIRLINE_NAME_1_3", 0, 0, "='#REF!'!$P$26"); xls.SetNamedRange(Range); Range = new TXlsNamedRange("AIRPORT_1_1", 2, 0, "='Chart TOP Destinations'!$I$26"); //You could also use: Range = new TXlsNamedRange("AIRPORT_1_1", 2, 2, 26, 9, 26, 9, 0); xls.SetNamedRange(Range); Range = new TXlsNamedRange("AIRPORT_1_1", 1, 0, "=Parameters!$D$15"); //You could also use: Range = new TXlsNamedRange("AIRPORT_1_1", 1, 1, 15, 4, 15, 4, 0); xls.SetNamedRange(Range); Range = new TXlsNamedRange("AIRPORT_1_1", 0, 0, "='#REF!'!$I$26"); xls.SetNamedRange(Range); Range = new TXlsNamedRange("AIRPORT_NAME_1_1", 2, 0, "='Chart TOP Destinations'!$K$26"); //You could also use: Range = new TXlsNamedRange("AIRPORT_NAME_1_1", 2, 2, 26, 11, 26, 11, 0); xls.SetNamedRange(Range); Range = new TXlsNamedRange("AIRPORT_NAME_1_1", 0, 0, "='#REF!'!$K$26"); xls.SetNamedRange(Range); Range = new TXlsNamedRange("COUNTRY_1_1", 0, 0, "=Parameters!$D$11"); //You could also use: Range = new TXlsNamedRange("COUNTRY_1_1", 0, 1, 11, 4, 11, 4, 0); xls.SetNamedRange(Range); Range = new TXlsNamedRange("DELETE_RECORD_1_1", 2, 0, "='Chart TOP Destinations'!$47:$47"); //You could also use: Range = new TXlsNamedRange("DELETE_RECORD_1_1", 2, 2, 47, 1, 47, FlxConsts.Max_Columns + 1, 0); xls.SetNamedRange(Range); Range = new TXlsNamedRange("DELETE_RECORD_1_1", 0, 0, "='#REF!'!$30:$30"); xls.SetNamedRange(Range); Range = new TXlsNamedRange("DELETE_RECORD_1_2", 2, 0, "='Chart TOP Destinations'!$46:$46"); //You could also use: Range = new TXlsNamedRange("DELETE_RECORD_1_2", 2, 2, 46, 1, 46, FlxConsts.Max_Columns + 1, 0); xls.SetNamedRange(Range); Range = new TXlsNamedRange("DELETE_RECORD_1_2", 0, 0, "='#REF!'!$29:$29"); xls.SetNamedRange(Range); Range = new TXlsNamedRange("DESTINATION_1_1", 2, 0, "='Chart TOP Destinations'!$B$26"); //You could also use: Range = new TXlsNamedRange("DESTINATION_1_1", 2, 2, 26, 2, 26, 2, 0); xls.SetNamedRange(Range); Range = new TXlsNamedRange("DESTINATION_1_1", 0, 0, "='#REF!'!$B$26"); xls.SetNamedRange(Range); Range = new TXlsNamedRange("DESTINATION_1_2", 2, 0, "='Chart TOP Destinations'!$E$26"); //You could also use: Range = new TXlsNamedRange("DESTINATION_1_2", 2, 2, 26, 5, 26, 5, 0); xls.SetNamedRange(Range); Range = new TXlsNamedRange("DESTINATION_1_2", 0, 0, "='#REF!'!$F$26"); xls.SetNamedRange(Range); Range = new TXlsNamedRange("DESTINATION_2_1", 0, 0, "='#REF!'!$D$6"); xls.SetNamedRange(Range); Range = new TXlsNamedRange("DIRECTION_1_1", 0, 0, "=Parameters!$D$5"); //You could also use: Range = new TXlsNamedRange("DIRECTION_1_1", 0, 1, 5, 4, 5, 4, 0); xls.SetNamedRange(Range); Range = new TXlsNamedRange("INSERT_RECORD_2_1", 0, 0, "='#REF!'!$7:$7"); xls.SetNamedRange(Range); Range = new TXlsNamedRange("INSERT_RECORD_3_1", 2, 0, "='Chart TOP Destinations'!$A$46:$L$46"); //You could also use: Range = new TXlsNamedRange("INSERT_RECORD_3_1", 2, 2, 46, 1, 46, 12, 0); xls.SetNamedRange(Range); Range = new TXlsNamedRange("INSERT_RECORD_3_2", 2, 0, "='Chart TOP Destinations'!$A$47:$L$47"); //You could also use: Range = new TXlsNamedRange("INSERT_RECORD_3_2", 2, 2, 47, 1, 47, 12, 0); xls.SetNamedRange(Range); Range = new TXlsNamedRange("INTERNATIONAL_1_1", 0, 0, "=Parameters!$D$17"); //You could also use: Range = new TXlsNamedRange("INTERNATIONAL_1_1", 0, 1, 17, 4, 17, 4, 0); xls.SetNamedRange(Range); Range = new TXlsNamedRange("MERGED_AIRLINES_1_1", 0, 0, "=Parameters!$D$9"); //You could also use: Range = new TXlsNamedRange("MERGED_AIRLINES_1_1", 0, 1, 9, 4, 9, 4, 0); xls.SetNamedRange(Range); Range = new TXlsNamedRange("ORIGIN_AIRPORT_1_1", 2, 0, "='Chart TOP Destinations'!$B$26"); //You could also use: Range = new TXlsNamedRange("ORIGIN_AIRPORT_1_1", 2, 2, 26, 2, 26, 2, 0); xls.SetNamedRange(Range); Range = new TXlsNamedRange("ORIGIN_AIRPORT_1_2", 2, 0, "='Chart TOP Destinations'!$F$26"); //You could also use: Range = new TXlsNamedRange("ORIGIN_AIRPORT_1_2", 2, 2, 26, 6, 26, 6, 0); xls.SetNamedRange(Range); Range = new TXlsNamedRange("ORIGIN_AIRPORT_2_1", 0, 0, "='#REF!'!$C$6"); xls.SetNamedRange(Range); Range = new TXlsNamedRange("PAX_1_1", 2, 0, "='Chart TOP Destinations'!$C$26"); //You could also use: Range = new TXlsNamedRange("PAX_1_1", 2, 2, 26, 3, 26, 3, 0); xls.SetNamedRange(Range); Range = new TXlsNamedRange("PAX_1_2", 2, 0, "='Chart TOP Destinations'!$G$26"); //You could also use: Range = new TXlsNamedRange("PAX_1_2", 2, 2, 26, 7, 26, 7, 0); xls.SetNamedRange(Range); Range = new TXlsNamedRange("PAX_1_3", 2, 0, "='Chart TOP Destinations'!$N$26"); //You could also use: Range = new TXlsNamedRange("PAX_1_3", 2, 2, 26, 14, 26, 14, 0); xls.SetNamedRange(Range); Range = new TXlsNamedRange("PAX_1_3", 0, 0, "='#REF!'!$S$26"); xls.SetNamedRange(Range); Range = new TXlsNamedRange("PAX_1_4", 0, 0, "='#REF!'!$X$26"); xls.SetNamedRange(Range); Range = new TXlsNamedRange("PAX_2_1", 0, 0, "='#REF!'!$E$6"); xls.SetNamedRange(Range); Range = new TXlsNamedRange("PERIOD_1_1", 0, 0, "=Parameters!$D$3"); //You could also use: Range = new TXlsNamedRange("PERIOD_1_1", 0, 1, 3, 4, 3, 4, 0); xls.SetNamedRange(Range); String RangeName; RangeName = TXlsNamedRange.GetInternalName(InternalNameRange.Print_Area); Range = new TXlsNamedRange(RangeName, 2, 32, "='Chart TOP Destinations'!$A$1:$R$49"); //You could also use: Range = new TXlsNamedRange(RangeName, 2, 2, 1, 1, 49, 18, 32); xls.SetNamedRange(Range); Range = new TXlsNamedRange("TABLE_CAPTION_1_4", 2, 0, "='Chart TOP Destinations'!$N$25"); //You could also use: Range = new TXlsNamedRange("TABLE_CAPTION_1_4", 2, 2, 25, 14, 25, 14, 0); xls.SetNamedRange(Range); Range = new TXlsNamedRange("TABLE_CAPTION_1_4", 0, 0, "='#REF!'!$S$25"); xls.SetNamedRange(Range); Range = new TXlsNamedRange("TABLE_CAPTION_1_5", 0, 0, "='#REF!'!$X$25"); xls.SetNamedRange(Range); Range = new TXlsNamedRange("TOP_AIRLINES_1_1", 0, 0, "=Parameters!$D$25"); //You could also use: Range = new TXlsNamedRange("TOP_AIRLINES_1_1", 0, 1, 25, 4, 25, 4, 0); xls.SetNamedRange(Range); Range = new TXlsNamedRange("TOP_AIRPORTS_1_1", 0, 0, "=Parameters!$D$19"); //You could also use: Range = new TXlsNamedRange("TOP_AIRPORTS_1_1", 0, 1, 19, 4, 19, 4, 0); xls.SetNamedRange(Range); Range = new TXlsNamedRange("TOP_DESTINATIONS_1_1", 0, 0, "=Parameters!$D$23"); //You could also use: Range = new TXlsNamedRange("TOP_DESTINATIONS_1_1", 0, 1, 23, 4, 23, 4, 0); xls.SetNamedRange(Range); Range = new TXlsNamedRange("TOP_ORIGINS_1_1", 0, 0, "=Parameters!$D$21"); //You could also use: Range = new TXlsNamedRange("TOP_ORIGINS_1_1", 0, 1, 21, 4, 21, 4, 0); xls.SetNamedRange(Range); //Printer Settings xls.PrintToFit = true; xls.PrintScale = 71; xls.PrintXResolution = 65533; xls.PrintYResolution = 600; //The PrintOptions enum can change multiple options at once. //As it is better to change the individual properties (Like PrintLandscape or PrintBlackAndWhite) instead, //we will comment out the PrintOptions line and show the Print... properties instead if needed. // xls.PrintOptions = TPrintOptions.Orientation; xls.PrintPaperSize = TPaperSize.A4; //Set up rows and columns xls.DefaultColWidth = 2925; xls.SetColWidth(1, 1, 694); //(1.96 + 0.75) * 256 xls.SetColWidth(2, 2, 2889); //(10.54 + 0.75) * 256 xls.SetColWidth(3, 3, 2816); //(10.25 + 0.75) * 256 xls.SetColWidth(4, 4, 694); //(1.96 + 0.75) * 256 xls.SetColWidth(5, 5, 2889); //(10.54 + 0.75) * 256 xls.SetColWidth(6, 6, 2194); //(7.82 + 0.75) * 256 xls.SetColWidth(7, 7, 1718); //(5.96 + 0.75) * 256 xls.SetColWidth(8, 8, 694); //(1.96 + 0.75) * 256 xls.SetColWidth(9, 11, 1718); //(5.96 + 0.75) * 256 xls.SetColWidth(12, 12, 2048); //(7.25 + 0.75) * 256 xls.SetColWidth(13, 13, 694); //(1.96 + 0.75) * 256 xls.SetColWidth(14, 14, 1718); //(5.96 + 0.75) * 256 xls.SetColWidth(15, 15, 2633); //(9.54 + 0.75) * 256 xls.SetColWidth(16, 16, 1718); //(5.96 + 0.75) * 256 xls.SetColWidth(17, 17, 2633); //(9.54 + 0.75) * 256 xls.SetColWidth(18, 18, 694); //(1.96 + 0.75) * 256 xls.SetColWidth(19, 21, 2925); //(10.68 + 0.75) * 256 xls.SetColWidth(22, 22, 2523); //(9.11 + 0.75) * 256 xls.SetColWidth(23, 16384, 2925); //(10.68 + 0.75) * 256 xls.SetRowHeight(24, 315); //15.75 * 20 xls.SetRowHeight(25, 315); //15.75 * 20 xls.SetRowHeight(26, 315); //15.75 * 20 xls.SetRowHeight(48, 102); //5.10 * 20 xls.SetRowHeight(49, 102); //5.10 * 20 //Merged Cells xls.MergeCells(44, 9, 44, 10); xls.MergeCells(44, 11, 44, 12); xls.MergeCells(45, 9, 45, 10); xls.MergeCells(45, 11, 45, 12); xls.MergeCells(41, 9, 41, 10); xls.MergeCells(41, 11, 41, 12); xls.MergeCells(42, 9, 42, 10); xls.MergeCells(42, 11, 42, 12); xls.MergeCells(43, 9, 43, 10); xls.MergeCells(43, 11, 43, 12); xls.MergeCells(38, 9, 38, 10); xls.MergeCells(38, 11, 38, 12); xls.MergeCells(39, 9, 39, 10); xls.MergeCells(39, 11, 39, 12); xls.MergeCells(40, 9, 40, 10); xls.MergeCells(40, 11, 40, 12); xls.MergeCells(35, 9, 35, 10); xls.MergeCells(35, 11, 35, 12); xls.MergeCells(36, 9, 36, 10); xls.MergeCells(36, 11, 36, 12); xls.MergeCells(37, 9, 37, 10); xls.MergeCells(37, 11, 37, 12); xls.MergeCells(32, 9, 32, 10); xls.MergeCells(32, 11, 32, 12); xls.MergeCells(33, 9, 33, 10); xls.MergeCells(33, 11, 33, 12); xls.MergeCells(34, 9, 34, 10); xls.MergeCells(34, 11, 34, 12); xls.MergeCells(29, 9, 29, 10); xls.MergeCells(29, 11, 29, 12); xls.MergeCells(30, 9, 30, 10); xls.MergeCells(30, 11, 30, 12); xls.MergeCells(31, 9, 31, 10); xls.MergeCells(31, 11, 31, 12); xls.MergeCells(48, 9, 48, 10); xls.MergeCells(48, 11, 48, 12); xls.MergeCells(27, 9, 27, 10); xls.MergeCells(27, 11, 27, 12); xls.MergeCells(46, 9, 46, 10); xls.MergeCells(46, 11, 46, 12); xls.MergeCells(47, 9, 47, 10); xls.MergeCells(47, 11, 47, 12); xls.MergeCells(28, 9, 28, 10); xls.MergeCells(28, 11, 28, 12); xls.MergeCells(27, 14, 27, 15); xls.MergeCells(26, 14, 26, 15); xls.MergeCells(26, 16, 26, 17); xls.MergeCells(27, 16, 27, 17); xls.MergeCells(25, 2, 25, 3); xls.MergeCells(25, 5, 25, 7); xls.MergeCells(25, 9, 25, 12); xls.MergeCells(25, 14, 25, 17); xls.MergeCells(26, 9, 26, 10); xls.MergeCells(26, 11, 26, 12); //Set the cell values TFlxFormat fmt; fmt = xls.GetCellVisibleFormatDef(25, 2); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; fmt.Font.Style = TFlxFontStyles.Bold; fmt.Borders.Left.Style = TFlxBorderStyle.Medium; fmt.Borders.Left.Color = TExcelColor.Automatic; fmt.Borders.Right.Style = TFlxBorderStyle.Thin; fmt.Borders.Right.Color = TExcelColor.Automatic; fmt.Borders.Top.Style = TFlxBorderStyle.Medium; fmt.Borders.Top.Color = TExcelColor.Automatic; fmt.Borders.Bottom.Style = TFlxBorderStyle.Thin; fmt.Borders.Bottom.Color = TExcelColor.Automatic; fmt.FillPattern.Pattern = TFlxPatternStyle.Solid; fmt.FillPattern.FgColor = TExcelColor.FromTheme(TThemeColor.Light1, -0.14996795556505); fmt.FillPattern.BgColor = TExcelColor.Automatic; fmt.HAlignment = THFlxAlignment.center; fmt.VAlignment = TVFlxAlignment.center; xls.SetCellFormat(25, 2, xls.AddFormat(fmt)); xls.SetCellValue(25, 2, "Destination wise"); fmt = xls.GetCellVisibleFormatDef(25, 3); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; fmt.Font.Style = TFlxFontStyles.Bold; fmt.Borders.Left.Style = TFlxBorderStyle.Thin; fmt.Borders.Left.Color = TExcelColor.Automatic; fmt.Borders.Right.Style = TFlxBorderStyle.Medium; fmt.Borders.Right.Color = TExcelColor.Automatic; fmt.Borders.Top.Style = TFlxBorderStyle.Medium; fmt.Borders.Top.Color = TExcelColor.Automatic; fmt.Borders.Bottom.Style = TFlxBorderStyle.Thin; fmt.Borders.Bottom.Color = TExcelColor.Automatic; fmt.FillPattern.Pattern = TFlxPatternStyle.Solid; fmt.FillPattern.FgColor = TExcelColor.FromTheme(TThemeColor.Light1, -0.14996795556505); fmt.FillPattern.BgColor = TExcelColor.Automatic; fmt.HAlignment = THFlxAlignment.center; fmt.VAlignment = TVFlxAlignment.center; xls.SetCellFormat(25, 3, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(25, 4); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; xls.SetCellFormat(25, 4, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(25, 5); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; fmt.Font.Style = TFlxFontStyles.Bold; fmt.Borders.Left.Style = TFlxBorderStyle.Medium; fmt.Borders.Left.Color = TExcelColor.Automatic; fmt.Borders.Right.Style = TFlxBorderStyle.Thin; fmt.Borders.Right.Color = TExcelColor.Automatic; fmt.Borders.Top.Style = TFlxBorderStyle.Medium; fmt.Borders.Top.Color = TExcelColor.Automatic; fmt.Borders.Bottom.Style = TFlxBorderStyle.Thin; fmt.Borders.Bottom.Color = TExcelColor.Automatic; fmt.FillPattern.Pattern = TFlxPatternStyle.Solid; fmt.FillPattern.FgColor = TExcelColor.FromTheme(TThemeColor.Light1, -0.14996795556505); fmt.FillPattern.BgColor = TExcelColor.Automatic; fmt.HAlignment = THFlxAlignment.center; xls.SetCellFormat(25, 5, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(25, 6); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; fmt.Font.Style = TFlxFontStyles.Bold; fmt.Borders.Left.Style = TFlxBorderStyle.Thin; fmt.Borders.Left.Color = TExcelColor.Automatic; fmt.Borders.Right.Style = TFlxBorderStyle.Thin; fmt.Borders.Right.Color = TExcelColor.Automatic; fmt.Borders.Top.Style = TFlxBorderStyle.Medium; fmt.Borders.Top.Color = TExcelColor.Automatic; fmt.Borders.Bottom.Style = TFlxBorderStyle.Thin; fmt.Borders.Bottom.Color = TExcelColor.Automatic; fmt.FillPattern.Pattern = TFlxPatternStyle.Solid; fmt.FillPattern.FgColor = TExcelColor.FromTheme(TThemeColor.Light1, -0.14996795556505); fmt.FillPattern.BgColor = TExcelColor.Automatic; fmt.HAlignment = THFlxAlignment.center; xls.SetCellFormat(25, 6, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(25, 7); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; fmt.Font.Style = TFlxFontStyles.Bold; fmt.Borders.Left.Style = TFlxBorderStyle.Thin; fmt.Borders.Left.Color = TExcelColor.Automatic; fmt.Borders.Right.Style = TFlxBorderStyle.Medium; fmt.Borders.Right.Color = TExcelColor.Automatic; fmt.Borders.Top.Style = TFlxBorderStyle.Medium; fmt.Borders.Top.Color = TExcelColor.Automatic; fmt.Borders.Bottom.Style = TFlxBorderStyle.Thin; fmt.Borders.Bottom.Color = TExcelColor.Automatic; fmt.FillPattern.Pattern = TFlxPatternStyle.Solid; fmt.FillPattern.FgColor = TExcelColor.FromTheme(TThemeColor.Light1, -0.14996795556505); fmt.FillPattern.BgColor = TExcelColor.Automatic; fmt.HAlignment = THFlxAlignment.center; xls.SetCellFormat(25, 7, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(25, 8); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; fmt.Font.Style = TFlxFontStyles.Bold; xls.SetCellFormat(25, 8, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(25, 9); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; fmt.Font.Style = TFlxFontStyles.Bold; fmt.Borders.Left.Style = TFlxBorderStyle.Medium; fmt.Borders.Left.Color = TExcelColor.Automatic; fmt.Borders.Right.Style = TFlxBorderStyle.Thin; fmt.Borders.Right.Color = TExcelColor.Automatic; fmt.Borders.Top.Style = TFlxBorderStyle.Medium; fmt.Borders.Top.Color = TExcelColor.Automatic; fmt.Borders.Bottom.Style = TFlxBorderStyle.Thin; fmt.Borders.Bottom.Color = TExcelColor.Automatic; fmt.FillPattern.Pattern = TFlxPatternStyle.Solid; fmt.FillPattern.FgColor = TExcelColor.FromTheme(TThemeColor.Light1, -0.14996795556505); fmt.FillPattern.BgColor = TExcelColor.Automatic; fmt.HAlignment = THFlxAlignment.center; xls.SetCellFormat(25, 9, xls.AddFormat(fmt)); xls.SetCellValue(25, 9, "Table of References for Airports"); fmt = xls.GetCellVisibleFormatDef(25, 10); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; fmt.Font.Style = TFlxFontStyles.Bold; fmt.Borders.Left.Style = TFlxBorderStyle.Thin; fmt.Borders.Left.Color = TExcelColor.Automatic; fmt.Borders.Right.Style = TFlxBorderStyle.Thin; fmt.Borders.Right.Color = TExcelColor.Automatic; fmt.Borders.Top.Style = TFlxBorderStyle.Medium; fmt.Borders.Top.Color = TExcelColor.Automatic; fmt.Borders.Bottom.Style = TFlxBorderStyle.Thin; fmt.Borders.Bottom.Color = TExcelColor.Automatic; fmt.FillPattern.Pattern = TFlxPatternStyle.Solid; fmt.FillPattern.FgColor = TExcelColor.FromTheme(TThemeColor.Light1, -0.14996795556505); fmt.FillPattern.BgColor = TExcelColor.Automatic; fmt.HAlignment = THFlxAlignment.center; xls.SetCellFormat(25, 10, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(25, 11); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; fmt.Font.Style = TFlxFontStyles.Bold; fmt.Borders.Left.Style = TFlxBorderStyle.Thin; fmt.Borders.Left.Color = TExcelColor.Automatic; fmt.Borders.Right.Style = TFlxBorderStyle.Thin; fmt.Borders.Right.Color = TExcelColor.Automatic; fmt.Borders.Top.Style = TFlxBorderStyle.Medium; fmt.Borders.Top.Color = TExcelColor.Automatic; fmt.Borders.Bottom.Style = TFlxBorderStyle.Thin; fmt.Borders.Bottom.Color = TExcelColor.Automatic; fmt.FillPattern.Pattern = TFlxPatternStyle.Solid; fmt.FillPattern.FgColor = TExcelColor.FromTheme(TThemeColor.Light1, -0.14996795556505); fmt.FillPattern.BgColor = TExcelColor.Automatic; fmt.HAlignment = THFlxAlignment.center; xls.SetCellFormat(25, 11, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(25, 12); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; fmt.Font.Style = TFlxFontStyles.Bold; fmt.Borders.Left.Style = TFlxBorderStyle.Thin; fmt.Borders.Left.Color = TExcelColor.Automatic; fmt.Borders.Right.Style = TFlxBorderStyle.Medium; fmt.Borders.Right.Color = TExcelColor.Automatic; fmt.Borders.Top.Style = TFlxBorderStyle.Medium; fmt.Borders.Top.Color = TExcelColor.Automatic; fmt.Borders.Bottom.Style = TFlxBorderStyle.Thin; fmt.Borders.Bottom.Color = TExcelColor.Automatic; fmt.FillPattern.Pattern = TFlxPatternStyle.Solid; fmt.FillPattern.FgColor = TExcelColor.FromTheme(TThemeColor.Light1, -0.14996795556505); fmt.FillPattern.BgColor = TExcelColor.Automatic; fmt.HAlignment = THFlxAlignment.center; xls.SetCellFormat(25, 12, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(25, 13); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; fmt.Font.Style = TFlxFontStyles.Bold; xls.SetCellFormat(25, 13, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(25, 14); fmt.Font.Size20 = 200; fmt.Font.Style = TFlxFontStyles.Bold; fmt.Borders.Bottom.Style = TFlxBorderStyle.Medium; fmt.Borders.Bottom.Color = TExcelColor.Automatic; fmt.FillPattern.Pattern = TFlxPatternStyle.Solid; fmt.FillPattern.FgColor = TExcelColor.FromTheme(TThemeColor.Light1, -0.14996795556505); fmt.FillPattern.BgColor = TExcelColor.Automatic; fmt.HAlignment = THFlxAlignment.center; xls.SetCellFormat(25, 14, xls.AddFormat(fmt)); xls.SetCellValue(25, 14, "Total number of transfer pax via SAW"); fmt = xls.GetCellVisibleFormatDef(25, 15); fmt.Font.Size20 = 200; fmt.Font.Style = TFlxFontStyles.Bold; fmt.Borders.Bottom.Style = TFlxBorderStyle.Medium; fmt.Borders.Bottom.Color = TExcelColor.Automatic; fmt.FillPattern.Pattern = TFlxPatternStyle.Solid; fmt.FillPattern.FgColor = TExcelColor.FromTheme(TThemeColor.Light1, -0.14996795556505); fmt.FillPattern.BgColor = TExcelColor.Automatic; fmt.HAlignment = THFlxAlignment.center; xls.SetCellFormat(25, 15, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(25, 16); fmt.Font.Size20 = 200; fmt.Font.Style = TFlxFontStyles.Bold; fmt.Borders.Bottom.Style = TFlxBorderStyle.Medium; fmt.Borders.Bottom.Color = TExcelColor.Automatic; fmt.FillPattern.Pattern = TFlxPatternStyle.Solid; fmt.FillPattern.FgColor = TExcelColor.FromTheme(TThemeColor.Light1, -0.14996795556505); fmt.FillPattern.BgColor = TExcelColor.Automatic; fmt.HAlignment = THFlxAlignment.center; xls.SetCellFormat(25, 16, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(25, 17); fmt.Font.Size20 = 200; fmt.Font.Style = TFlxFontStyles.Bold; fmt.Borders.Bottom.Style = TFlxBorderStyle.Medium; fmt.Borders.Bottom.Color = TExcelColor.Automatic; fmt.FillPattern.Pattern = TFlxPatternStyle.Solid; fmt.FillPattern.FgColor = TExcelColor.FromTheme(TThemeColor.Light1, -0.14996795556505); fmt.FillPattern.BgColor = TExcelColor.Automatic; fmt.HAlignment = THFlxAlignment.center; xls.SetCellFormat(25, 17, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(25, 18); fmt.Font.Size20 = 200; xls.SetCellFormat(25, 18, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(25, 19); fmt.Font.Size20 = 200; xls.SetCellFormat(25, 19, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(26, 2); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; fmt.Font.Style = TFlxFontStyles.Bold; fmt.Borders.Left.Style = TFlxBorderStyle.Medium; fmt.Borders.Left.Color = TExcelColor.Automatic; fmt.Borders.Right.Style = TFlxBorderStyle.Thin; fmt.Borders.Right.Color = TExcelColor.Automatic; fmt.Borders.Top.Style = TFlxBorderStyle.Thin; fmt.Borders.Top.Color = TExcelColor.Automatic; fmt.Borders.Bottom.Style = TFlxBorderStyle.Medium; fmt.Borders.Bottom.Color = TExcelColor.Automatic; fmt.FillPattern.Pattern = TFlxPatternStyle.Solid; fmt.FillPattern.FgColor = TExcelColor.FromTheme(TThemeColor.Light1, -0.14996795556505); fmt.FillPattern.BgColor = TExcelColor.Automatic; fmt.HAlignment = THFlxAlignment.center; fmt.VAlignment = TVFlxAlignment.center; xls.SetCellFormat(26, 2, xls.AddFormat(fmt)); xls.SetCellValue(26, 2, "Destination"); fmt = xls.GetCellVisibleFormatDef(26, 3); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; fmt.Font.Style = TFlxFontStyles.Bold; fmt.Borders.Left.Style = TFlxBorderStyle.Thin; fmt.Borders.Left.Color = TExcelColor.Automatic; fmt.Borders.Right.Style = TFlxBorderStyle.Medium; fmt.Borders.Right.Color = TExcelColor.Automatic; fmt.Borders.Top.Style = TFlxBorderStyle.Thin; fmt.Borders.Top.Color = TExcelColor.Automatic; fmt.Borders.Bottom.Style = TFlxBorderStyle.Medium; fmt.Borders.Bottom.Color = TExcelColor.Automatic; fmt.FillPattern.Pattern = TFlxPatternStyle.Solid; fmt.FillPattern.FgColor = TExcelColor.FromTheme(TThemeColor.Light1, -0.14996795556505); fmt.FillPattern.BgColor = TExcelColor.Automatic; fmt.HAlignment = THFlxAlignment.center; fmt.VAlignment = TVFlxAlignment.center; xls.SetCellFormat(26, 3, xls.AddFormat(fmt)); xls.SetCellValue(26, 3, "Pax"); fmt = xls.GetCellVisibleFormatDef(26, 4); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; fmt.Font.Style = TFlxFontStyles.Bold; fmt.HAlignment = THFlxAlignment.center; fmt.VAlignment = TVFlxAlignment.center; xls.SetCellFormat(26, 4, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(26, 5); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; fmt.Font.Style = TFlxFontStyles.Bold; fmt.Borders.Left.Style = TFlxBorderStyle.Medium; fmt.Borders.Left.Color = TExcelColor.Automatic; fmt.Borders.Right.Style = TFlxBorderStyle.Thin; fmt.Borders.Right.Color = TExcelColor.Automatic; fmt.Borders.Top.Style = TFlxBorderStyle.Thin; fmt.Borders.Top.Color = TExcelColor.Automatic; fmt.Borders.Bottom.Style = TFlxBorderStyle.Medium; fmt.Borders.Bottom.Color = TExcelColor.Automatic; fmt.FillPattern.Pattern = TFlxPatternStyle.Solid; fmt.FillPattern.FgColor = TExcelColor.FromTheme(TThemeColor.Light1, -0.14996795556505); fmt.FillPattern.BgColor = TExcelColor.Automatic; fmt.HAlignment = THFlxAlignment.center; fmt.VAlignment = TVFlxAlignment.center; xls.SetCellFormat(26, 5, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(26, 6); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; fmt.Font.Style = TFlxFontStyles.Bold; fmt.Borders.Left.Style = TFlxBorderStyle.Thin; fmt.Borders.Left.Color = TExcelColor.Automatic; fmt.Borders.Right.Style = TFlxBorderStyle.Thin; fmt.Borders.Right.Color = TExcelColor.Automatic; fmt.Borders.Top.Style = TFlxBorderStyle.Thin; fmt.Borders.Top.Color = TExcelColor.Automatic; fmt.Borders.Bottom.Style = TFlxBorderStyle.Medium; fmt.Borders.Bottom.Color = TExcelColor.Automatic; fmt.FillPattern.Pattern = TFlxPatternStyle.Solid; fmt.FillPattern.FgColor = TExcelColor.FromTheme(TThemeColor.Light1, -0.14996795556505); fmt.FillPattern.BgColor = TExcelColor.Automatic; fmt.HAlignment = THFlxAlignment.center; fmt.VAlignment = TVFlxAlignment.center; xls.SetCellFormat(26, 6, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(26, 7); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; fmt.Font.Style = TFlxFontStyles.Bold; fmt.Borders.Left.Style = TFlxBorderStyle.Thin; fmt.Borders.Left.Color = TExcelColor.Automatic; fmt.Borders.Right.Style = TFlxBorderStyle.Medium; fmt.Borders.Right.Color = TExcelColor.Automatic; fmt.Borders.Top.Style = TFlxBorderStyle.Thin; fmt.Borders.Top.Color = TExcelColor.Automatic; fmt.Borders.Bottom.Style = TFlxBorderStyle.Medium; fmt.Borders.Bottom.Color = TExcelColor.Automatic; fmt.FillPattern.Pattern = TFlxPatternStyle.Solid; fmt.FillPattern.FgColor = TExcelColor.FromTheme(TThemeColor.Light1, -0.14996795556505); fmt.FillPattern.BgColor = TExcelColor.Automatic; fmt.HAlignment = THFlxAlignment.center; fmt.VAlignment = TVFlxAlignment.center; xls.SetCellFormat(26, 7, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(26, 8); fmt.Font.Size20 = 200; xls.SetCellFormat(26, 8, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(26, 9); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; fmt.Font.Style = TFlxFontStyles.Bold; fmt.Borders.Left.Style = TFlxBorderStyle.Medium; fmt.Borders.Left.Color = TExcelColor.Automatic; fmt.Borders.Right.Style = TFlxBorderStyle.Thin; fmt.Borders.Right.Color = TExcelColor.Automatic; fmt.Borders.Top.Style = TFlxBorderStyle.Thin; fmt.Borders.Top.Color = TExcelColor.Automatic; fmt.Borders.Bottom.Style = TFlxBorderStyle.Medium; fmt.Borders.Bottom.Color = TExcelColor.Automatic; fmt.FillPattern.Pattern = TFlxPatternStyle.Solid; fmt.FillPattern.FgColor = TExcelColor.FromTheme(TThemeColor.Light1, -0.14996795556505); fmt.FillPattern.BgColor = TExcelColor.Automatic; fmt.HAlignment = THFlxAlignment.center; xls.SetCellFormat(26, 9, xls.AddFormat(fmt)); xls.SetCellValue(26, 9, "Airport code"); fmt = xls.GetCellVisibleFormatDef(26, 10); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; fmt.Font.Style = TFlxFontStyles.Bold; fmt.Borders.Left.Style = TFlxBorderStyle.Thin; fmt.Borders.Left.Color = TExcelColor.Automatic; fmt.Borders.Right.Style = TFlxBorderStyle.Thin; fmt.Borders.Right.Color = TExcelColor.Automatic; fmt.Borders.Top.Style = TFlxBorderStyle.Thin; fmt.Borders.Top.Color = TExcelColor.Automatic; fmt.Borders.Bottom.Style = TFlxBorderStyle.Medium; fmt.Borders.Bottom.Color = TExcelColor.Automatic; fmt.FillPattern.Pattern = TFlxPatternStyle.Solid; fmt.FillPattern.FgColor = TExcelColor.FromTheme(TThemeColor.Light1, -0.14996795556505); fmt.FillPattern.BgColor = TExcelColor.Automatic; fmt.HAlignment = THFlxAlignment.center; xls.SetCellFormat(26, 10, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(26, 11); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; fmt.Font.Style = TFlxFontStyles.Bold; fmt.Borders.Left.Style = TFlxBorderStyle.Thin; fmt.Borders.Left.Color = TExcelColor.Automatic; fmt.Borders.Right.Style = TFlxBorderStyle.Thin; fmt.Borders.Right.Color = TExcelColor.Automatic; fmt.Borders.Top.Style = TFlxBorderStyle.Thin; fmt.Borders.Top.Color = TExcelColor.Automatic; fmt.Borders.Bottom.Style = TFlxBorderStyle.Medium; fmt.Borders.Bottom.Color = TExcelColor.Automatic; fmt.FillPattern.Pattern = TFlxPatternStyle.Solid; fmt.FillPattern.FgColor = TExcelColor.FromTheme(TThemeColor.Light1, -0.14996795556505); fmt.FillPattern.BgColor = TExcelColor.Automatic; fmt.HAlignment = THFlxAlignment.center; xls.SetCellFormat(26, 11, xls.AddFormat(fmt)); xls.SetCellValue(26, 11, "Airport name"); fmt = xls.GetCellVisibleFormatDef(26, 12); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; fmt.Font.Style = TFlxFontStyles.Bold; fmt.Borders.Left.Style = TFlxBorderStyle.Thin; fmt.Borders.Left.Color = TExcelColor.Automatic; fmt.Borders.Right.Style = TFlxBorderStyle.Medium; fmt.Borders.Right.Color = TExcelColor.Automatic; fmt.Borders.Top.Style = TFlxBorderStyle.Thin; fmt.Borders.Top.Color = TExcelColor.Automatic; fmt.Borders.Bottom.Style = TFlxBorderStyle.Medium; fmt.Borders.Bottom.Color = TExcelColor.Automatic; fmt.FillPattern.Pattern = TFlxPatternStyle.Solid; fmt.FillPattern.FgColor = TExcelColor.FromTheme(TThemeColor.Light1, -0.14996795556505); fmt.FillPattern.BgColor = TExcelColor.Automatic; fmt.HAlignment = THFlxAlignment.center; xls.SetCellFormat(26, 12, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(26, 13); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; fmt.Font.Style = TFlxFontStyles.Bold; fmt.HAlignment = THFlxAlignment.center; xls.SetCellFormat(26, 13, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(26, 14); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; fmt.Font.Style = TFlxFontStyles.Bold; fmt.Borders.Left.Style = TFlxBorderStyle.Medium; fmt.Borders.Left.Color = TExcelColor.Automatic; fmt.Borders.Right.Style = TFlxBorderStyle.Thin; fmt.Borders.Right.Color = TExcelColor.Automatic; fmt.Borders.Top.Style = TFlxBorderStyle.Thin; fmt.Borders.Top.Color = TExcelColor.Automatic; fmt.FillPattern.Pattern = TFlxPatternStyle.Solid; fmt.FillPattern.FgColor = TExcelColor.FromTheme(TThemeColor.Light1, -0.14996795556505); fmt.FillPattern.BgColor = TExcelColor.Automatic; fmt.HAlignment = THFlxAlignment.center; xls.SetCellFormat(26, 14, xls.AddFormat(fmt)); xls.SetCellValue(26, 14, "TOP"); fmt = xls.GetCellVisibleFormatDef(26, 15); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; fmt.Font.Style = TFlxFontStyles.Bold; fmt.Borders.Left.Style = TFlxBorderStyle.Thin; fmt.Borders.Left.Color = TExcelColor.Automatic; fmt.Borders.Right.Style = TFlxBorderStyle.Thin; fmt.Borders.Right.Color = TExcelColor.Automatic; fmt.Borders.Top.Style = TFlxBorderStyle.Thin; fmt.Borders.Top.Color = TExcelColor.Automatic; fmt.FillPattern.Pattern = TFlxPatternStyle.Solid; fmt.FillPattern.FgColor = TExcelColor.FromTheme(TThemeColor.Light1, -0.14996795556505); fmt.FillPattern.BgColor = TExcelColor.Automatic; fmt.HAlignment = THFlxAlignment.center; xls.SetCellFormat(26, 15, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(26, 16); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; fmt.Font.Style = TFlxFontStyles.Bold; fmt.Borders.Left.Style = TFlxBorderStyle.Thin; fmt.Borders.Left.Color = TExcelColor.Automatic; fmt.Borders.Right.Style = TFlxBorderStyle.Thin; fmt.Borders.Right.Color = TExcelColor.Automatic; fmt.Borders.Top.Style = TFlxBorderStyle.Thin; fmt.Borders.Top.Color = TExcelColor.Automatic; fmt.FillPattern.Pattern = TFlxPatternStyle.Solid; fmt.FillPattern.FgColor = TExcelColor.FromTheme(TThemeColor.Light1, -0.14996795556505); fmt.FillPattern.BgColor = TExcelColor.Automatic; fmt.HAlignment = THFlxAlignment.center; xls.SetCellFormat(26, 16, xls.AddFormat(fmt)); xls.SetCellValue(26, 16, "All"); fmt = xls.GetCellVisibleFormatDef(26, 17); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; fmt.Font.Style = TFlxFontStyles.Bold; fmt.Borders.Left.Style = TFlxBorderStyle.Thin; fmt.Borders.Left.Color = TExcelColor.Automatic; fmt.Borders.Right.Style = TFlxBorderStyle.Medium; fmt.Borders.Right.Color = TExcelColor.Automatic; fmt.Borders.Top.Style = TFlxBorderStyle.Thin; fmt.Borders.Top.Color = TExcelColor.Automatic; fmt.FillPattern.Pattern = TFlxPatternStyle.Solid; fmt.FillPattern.FgColor = TExcelColor.FromTheme(TThemeColor.Light1, -0.14996795556505); fmt.FillPattern.BgColor = TExcelColor.Automatic; fmt.HAlignment = THFlxAlignment.center; xls.SetCellFormat(26, 17, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(26, 18); fmt.Font.Size20 = 200; xls.SetCellFormat(26, 18, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(26, 19); fmt.Font.Size20 = 200; xls.SetCellFormat(26, 19, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(27, 2); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; fmt.Borders.Left.Style = TFlxBorderStyle.Thin; fmt.Borders.Left.Color = TExcelColor.Automatic; fmt.Borders.Right.Style = TFlxBorderStyle.Thin; fmt.Borders.Right.Color = TExcelColor.Automatic; fmt.HAlignment = THFlxAlignment.center; fmt.VAlignment = TVFlxAlignment.center; xls.SetCellFormat(27, 2, xls.AddFormat(fmt)); xls.SetCellValue(27, 2, "ESB"); fmt = xls.GetCellVisibleFormatDef(27, 3); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; fmt.Borders.Right.Style = TFlxBorderStyle.Thin; fmt.Borders.Right.Color = TExcelColor.Automatic; fmt.Format = "#,##0"; fmt.HAlignment = THFlxAlignment.right; fmt.VAlignment = TVFlxAlignment.center; xls.SetCellFormat(27, 3, xls.AddFormat(fmt)); xls.SetCellValue(27, 3, 132336); fmt = xls.GetCellVisibleFormatDef(27, 4); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; fmt.HAlignment = THFlxAlignment.center; fmt.VAlignment = TVFlxAlignment.center; xls.SetCellFormat(27, 4, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(27, 5); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; fmt.Borders.Left.Style = TFlxBorderStyle.Thin; fmt.Borders.Left.Color = TExcelColor.Automatic; fmt.Borders.Right.Style = TFlxBorderStyle.Thin; fmt.Borders.Right.Color = TExcelColor.Automatic; fmt.HAlignment = THFlxAlignment.center; fmt.VAlignment = TVFlxAlignment.center; xls.SetCellFormat(27, 5, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(27, 6); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; fmt.Borders.Left.Style = TFlxBorderStyle.Thin; fmt.Borders.Left.Color = TExcelColor.Automatic; fmt.Borders.Right.Style = TFlxBorderStyle.Thin; fmt.Borders.Right.Color = TExcelColor.Automatic; fmt.HAlignment = THFlxAlignment.center; fmt.VAlignment = TVFlxAlignment.center; xls.SetCellFormat(27, 6, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(27, 7); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; fmt.Borders.Right.Style = TFlxBorderStyle.Thin; fmt.Borders.Right.Color = TExcelColor.Automatic; fmt.Format = "#,##0"; fmt.HAlignment = THFlxAlignment.right; fmt.VAlignment = TVFlxAlignment.center; xls.SetCellFormat(27, 7, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(27, 8); fmt.Font.Size20 = 200; xls.SetCellFormat(27, 8, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(27, 9); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; fmt.Borders.Left.Style = TFlxBorderStyle.Thin; fmt.Borders.Left.Color = TExcelColor.Automatic; fmt.HAlignment = THFlxAlignment.center; fmt.VAlignment = TVFlxAlignment.center; xls.SetCellFormat(27, 9, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(27, 10); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; fmt.Borders.Right.Style = TFlxBorderStyle.Thin; fmt.Borders.Right.Color = TExcelColor.Automatic; fmt.HAlignment = THFlxAlignment.center; fmt.VAlignment = TVFlxAlignment.center; xls.SetCellFormat(27, 10, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(27, 11); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; fmt.Borders.Left.Style = TFlxBorderStyle.Thin; fmt.Borders.Left.Color = TExcelColor.Automatic; fmt.HAlignment = THFlxAlignment.center; xls.SetCellFormat(27, 11, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(27, 12); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; fmt.Borders.Right.Style = TFlxBorderStyle.Thin; fmt.Borders.Right.Color = TExcelColor.Automatic; fmt.HAlignment = THFlxAlignment.center; xls.SetCellFormat(27, 12, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(27, 13); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; fmt.HAlignment = THFlxAlignment.center; xls.SetCellFormat(27, 13, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(27, 14); fmt.Font.Size20 = 200; fmt.Borders.Left.Style = TFlxBorderStyle.Thin; fmt.Borders.Left.Color = TExcelColor.Automatic; fmt.Borders.Right.Style = TFlxBorderStyle.Thin; fmt.Borders.Right.Color = TExcelColor.Automatic; fmt.Borders.Top.Style = TFlxBorderStyle.Thin; fmt.Borders.Top.Color = TExcelColor.Automatic; fmt.Borders.Bottom.Style = TFlxBorderStyle.Thin; fmt.Borders.Bottom.Color = TExcelColor.Automatic; fmt.Format = "#,##0"; fmt.HAlignment = THFlxAlignment.center; xls.SetCellFormat(27, 14, xls.AddFormat(fmt)); xls.SetCellValue(27, 14, new TFormula("=C49")); fmt = xls.GetCellVisibleFormatDef(27, 15); fmt.Font.Size20 = 200; fmt.Borders.Left.Style = TFlxBorderStyle.Thin; fmt.Borders.Left.Color = TExcelColor.Automatic; fmt.Borders.Right.Style = TFlxBorderStyle.Thin; fmt.Borders.Right.Color = TExcelColor.Automatic; fmt.Borders.Top.Style = TFlxBorderStyle.Thin; fmt.Borders.Top.Color = TExcelColor.Automatic; fmt.Borders.Bottom.Style = TFlxBorderStyle.Thin; fmt.Borders.Bottom.Color = TExcelColor.Automatic; fmt.Format = "#,##0"; fmt.HAlignment = THFlxAlignment.center; xls.SetCellFormat(27, 15, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(27, 16); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; fmt.Borders.Left.Style = TFlxBorderStyle.Thin; fmt.Borders.Left.Color = TExcelColor.Automatic; fmt.Borders.Top.Style = TFlxBorderStyle.Thin; fmt.Borders.Top.Color = TExcelColor.Automatic; fmt.Borders.Bottom.Style = TFlxBorderStyle.Thin; fmt.Borders.Bottom.Color = TExcelColor.Automatic; fmt.Format = "#,##0"; fmt.HAlignment = THFlxAlignment.center; xls.SetCellFormat(27, 16, xls.AddFormat(fmt)); xls.SetCellValue(27, 16, new TFormula("='#REF!'!E18006")); fmt = xls.GetCellVisibleFormatDef(27, 17); fmt.Font.Size20 = 200; fmt.Borders.Right.Style = TFlxBorderStyle.Thin; fmt.Borders.Right.Color = TExcelColor.Automatic; fmt.Borders.Top.Style = TFlxBorderStyle.Thin; fmt.Borders.Top.Color = TExcelColor.Automatic; fmt.Borders.Bottom.Style = TFlxBorderStyle.Thin; fmt.Borders.Bottom.Color = TExcelColor.Automatic; fmt.HAlignment = THFlxAlignment.center; xls.SetCellFormat(27, 17, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(27, 18); fmt.Font.Size20 = 200; xls.SetCellFormat(27, 18, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(27, 19); fmt.Font.Size20 = 200; xls.SetCellFormat(27, 19, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(28, 2); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; fmt.Borders.Left.Style = TFlxBorderStyle.Thin; fmt.Borders.Left.Color = TExcelColor.Automatic; fmt.Borders.Right.Style = TFlxBorderStyle.Thin; fmt.Borders.Right.Color = TExcelColor.Automatic; fmt.HAlignment = THFlxAlignment.center; fmt.VAlignment = TVFlxAlignment.center; xls.SetCellFormat(28, 2, xls.AddFormat(fmt)); xls.SetCellValue(28, 2, "STN"); fmt = xls.GetCellVisibleFormatDef(28, 3); fmt.Font.Size20 = 200; fmt.Borders.Right.Style = TFlxBorderStyle.Thin; fmt.Borders.Right.Color = TExcelColor.Automatic; fmt.Format = "#,##0"; fmt.HAlignment = THFlxAlignment.right; fmt.VAlignment = TVFlxAlignment.center; xls.SetCellFormat(28, 3, xls.AddFormat(fmt)); xls.SetCellValue(28, 3, 127272); fmt = xls.GetCellVisibleFormatDef(28, 4); fmt.Font.Size20 = 200; xls.SetCellFormat(28, 4, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(28, 5); fmt.Font.Size20 = 200; fmt.Borders.Left.Style = TFlxBorderStyle.Thin; fmt.Borders.Left.Color = TExcelColor.Automatic; fmt.Borders.Right.Style = TFlxBorderStyle.Thin; fmt.Borders.Right.Color = TExcelColor.Automatic; fmt.VAlignment = TVFlxAlignment.center; xls.SetCellFormat(28, 5, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(28, 6); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; fmt.Borders.Left.Style = TFlxBorderStyle.Thin; fmt.Borders.Left.Color = TExcelColor.Automatic; fmt.Borders.Right.Style = TFlxBorderStyle.Thin; fmt.Borders.Right.Color = TExcelColor.Automatic; fmt.HAlignment = THFlxAlignment.center; fmt.VAlignment = TVFlxAlignment.center; xls.SetCellFormat(28, 6, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(28, 7); fmt.Font.Size20 = 200; fmt.Borders.Right.Style = TFlxBorderStyle.Thin; fmt.Borders.Right.Color = TExcelColor.Automatic; fmt.Format = "#,##0"; fmt.HAlignment = THFlxAlignment.right; fmt.VAlignment = TVFlxAlignment.center; xls.SetCellFormat(28, 7, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(28, 8); fmt.Font.Size20 = 200; xls.SetCellFormat(28, 8, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(28, 9); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; fmt.Borders.Left.Style = TFlxBorderStyle.Thin; fmt.Borders.Left.Color = TExcelColor.Automatic; fmt.HAlignment = THFlxAlignment.center; fmt.VAlignment = TVFlxAlignment.center; xls.SetCellFormat(28, 9, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(28, 10); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; fmt.Borders.Right.Style = TFlxBorderStyle.Thin; fmt.Borders.Right.Color = TExcelColor.Automatic; fmt.HAlignment = THFlxAlignment.center; fmt.VAlignment = TVFlxAlignment.center; xls.SetCellFormat(28, 10, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(28, 11); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; fmt.Borders.Left.Style = TFlxBorderStyle.Thin; fmt.Borders.Left.Color = TExcelColor.Automatic; fmt.HAlignment = THFlxAlignment.center; xls.SetCellFormat(28, 11, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(28, 12); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; fmt.Borders.Right.Style = TFlxBorderStyle.Thin; fmt.Borders.Right.Color = TExcelColor.Automatic; fmt.HAlignment = THFlxAlignment.center; xls.SetCellFormat(28, 12, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(28, 13); fmt.Font.Size20 = 200; xls.SetCellFormat(28, 13, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(28, 14); fmt.Font.Size20 = 200; xls.SetCellFormat(28, 14, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(28, 15); fmt.Font.Size20 = 200; xls.SetCellFormat(28, 15, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(28, 16); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; xls.SetCellFormat(28, 16, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(28, 17); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; xls.SetCellFormat(28, 17, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(28, 18); fmt.Font.Size20 = 200; xls.SetCellFormat(28, 18, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(28, 19); fmt.Font.Size20 = 200; xls.SetCellFormat(28, 19, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(28, 22); fmt.HAlignment = THFlxAlignment.center; fmt.VAlignment = TVFlxAlignment.center; xls.SetCellFormat(28, 22, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(29, 2); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; fmt.Borders.Left.Style = TFlxBorderStyle.Thin; fmt.Borders.Left.Color = TExcelColor.Automatic; fmt.Borders.Right.Style = TFlxBorderStyle.Thin; fmt.Borders.Right.Color = TExcelColor.Automatic; fmt.HAlignment = THFlxAlignment.center; fmt.VAlignment = TVFlxAlignment.center; xls.SetCellFormat(29, 2, xls.AddFormat(fmt)); xls.SetCellValue(29, 2, "AYT"); fmt = xls.GetCellVisibleFormatDef(29, 3); fmt.Font.Size20 = 200; fmt.Borders.Right.Style = TFlxBorderStyle.Thin; fmt.Borders.Right.Color = TExcelColor.Automatic; fmt.Format = "#,##0"; fmt.HAlignment = THFlxAlignment.right; fmt.VAlignment = TVFlxAlignment.center; xls.SetCellFormat(29, 3, xls.AddFormat(fmt)); xls.SetCellValue(29, 3, 125380); fmt = xls.GetCellVisibleFormatDef(29, 4); fmt.Font.Size20 = 200; xls.SetCellFormat(29, 4, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(29, 5); fmt.Font.Size20 = 200; fmt.Borders.Left.Style = TFlxBorderStyle.Thin; fmt.Borders.Left.Color = TExcelColor.Automatic; fmt.Borders.Right.Style = TFlxBorderStyle.Thin; fmt.Borders.Right.Color = TExcelColor.Automatic; fmt.VAlignment = TVFlxAlignment.center; xls.SetCellFormat(29, 5, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(29, 6); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; fmt.Borders.Left.Style = TFlxBorderStyle.Thin; fmt.Borders.Left.Color = TExcelColor.Automatic; fmt.Borders.Right.Style = TFlxBorderStyle.Thin; fmt.Borders.Right.Color = TExcelColor.Automatic; fmt.HAlignment = THFlxAlignment.center; fmt.VAlignment = TVFlxAlignment.center; xls.SetCellFormat(29, 6, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(29, 7); fmt.Font.Size20 = 200; fmt.Borders.Right.Style = TFlxBorderStyle.Thin; fmt.Borders.Right.Color = TExcelColor.Automatic; fmt.Format = "#,##0"; fmt.HAlignment = THFlxAlignment.right; fmt.VAlignment = TVFlxAlignment.center; xls.SetCellFormat(29, 7, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(29, 8); fmt.Font.Size20 = 200; xls.SetCellFormat(29, 8, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(29, 9); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; fmt.Borders.Left.Style = TFlxBorderStyle.Thin; fmt.Borders.Left.Color = TExcelColor.Automatic; fmt.HAlignment = THFlxAlignment.center; fmt.VAlignment = TVFlxAlignment.center; xls.SetCellFormat(29, 9, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(29, 10); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; fmt.Borders.Right.Style = TFlxBorderStyle.Thin; fmt.Borders.Right.Color = TExcelColor.Automatic; fmt.HAlignment = THFlxAlignment.center; fmt.VAlignment = TVFlxAlignment.center; xls.SetCellFormat(29, 10, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(29, 11); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; fmt.Borders.Left.Style = TFlxBorderStyle.Thin; fmt.Borders.Left.Color = TExcelColor.Automatic; fmt.HAlignment = THFlxAlignment.center; xls.SetCellFormat(29, 11, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(29, 12); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; fmt.Borders.Right.Style = TFlxBorderStyle.Thin; fmt.Borders.Right.Color = TExcelColor.Automatic; fmt.HAlignment = THFlxAlignment.center; xls.SetCellFormat(29, 12, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(29, 13); fmt.Font.Size20 = 200; xls.SetCellFormat(29, 13, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(29, 14); fmt.Font.Size20 = 200; xls.SetCellFormat(29, 14, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(29, 15); fmt.Font.Size20 = 200; xls.SetCellFormat(29, 15, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(29, 16); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; xls.SetCellFormat(29, 16, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(29, 17); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; xls.SetCellFormat(29, 17, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(29, 18); fmt.Font.Size20 = 200; xls.SetCellFormat(29, 18, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(29, 19); fmt.Font.Size20 = 200; xls.SetCellFormat(29, 19, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(29, 22); fmt.HAlignment = THFlxAlignment.center; fmt.VAlignment = TVFlxAlignment.center; xls.SetCellFormat(29, 22, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(30, 2); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; fmt.Borders.Left.Style = TFlxBorderStyle.Thin; fmt.Borders.Left.Color = TExcelColor.Automatic; fmt.Borders.Right.Style = TFlxBorderStyle.Thin; fmt.Borders.Right.Color = TExcelColor.Automatic; fmt.HAlignment = THFlxAlignment.center; fmt.VAlignment = TVFlxAlignment.center; xls.SetCellFormat(30, 2, xls.AddFormat(fmt)); xls.SetCellValue(30, 2, "ADB"); fmt = xls.GetCellVisibleFormatDef(30, 3); fmt.Font.Size20 = 200; fmt.Borders.Right.Style = TFlxBorderStyle.Thin; fmt.Borders.Right.Color = TExcelColor.Automatic; fmt.Format = "#,##0"; fmt.HAlignment = THFlxAlignment.right; fmt.VAlignment = TVFlxAlignment.center; xls.SetCellFormat(30, 3, xls.AddFormat(fmt)); xls.SetCellValue(30, 3, 122952); fmt = xls.GetCellVisibleFormatDef(30, 4); fmt.Font.Size20 = 200; xls.SetCellFormat(30, 4, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(30, 5); fmt.Font.Size20 = 200; fmt.Borders.Left.Style = TFlxBorderStyle.Thin; fmt.Borders.Left.Color = TExcelColor.Automatic; fmt.Borders.Right.Style = TFlxBorderStyle.Thin; fmt.Borders.Right.Color = TExcelColor.Automatic; fmt.VAlignment = TVFlxAlignment.center; xls.SetCellFormat(30, 5, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(30, 6); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; fmt.Borders.Left.Style = TFlxBorderStyle.Thin; fmt.Borders.Left.Color = TExcelColor.Automatic; fmt.Borders.Right.Style = TFlxBorderStyle.Thin; fmt.Borders.Right.Color = TExcelColor.Automatic; fmt.HAlignment = THFlxAlignment.center; fmt.VAlignment = TVFlxAlignment.center; xls.SetCellFormat(30, 6, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(30, 7); fmt.Font.Size20 = 200; fmt.Borders.Right.Style = TFlxBorderStyle.Thin; fmt.Borders.Right.Color = TExcelColor.Automatic; fmt.Format = "#,##0"; fmt.HAlignment = THFlxAlignment.right; fmt.VAlignment = TVFlxAlignment.center; xls.SetCellFormat(30, 7, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(30, 8); fmt.Font.Size20 = 200; xls.SetCellFormat(30, 8, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(30, 9); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; fmt.Borders.Left.Style = TFlxBorderStyle.Thin; fmt.Borders.Left.Color = TExcelColor.Automatic; fmt.HAlignment = THFlxAlignment.center; fmt.VAlignment = TVFlxAlignment.center; xls.SetCellFormat(30, 9, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(30, 10); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; fmt.Borders.Right.Style = TFlxBorderStyle.Thin; fmt.Borders.Right.Color = TExcelColor.Automatic; fmt.HAlignment = THFlxAlignment.center; fmt.VAlignment = TVFlxAlignment.center; xls.SetCellFormat(30, 10, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(30, 11); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; fmt.Borders.Left.Style = TFlxBorderStyle.Thin; fmt.Borders.Left.Color = TExcelColor.Automatic; fmt.HAlignment = THFlxAlignment.center; xls.SetCellFormat(30, 11, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(30, 12); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; fmt.Borders.Right.Style = TFlxBorderStyle.Thin; fmt.Borders.Right.Color = TExcelColor.Automatic; fmt.HAlignment = THFlxAlignment.center; xls.SetCellFormat(30, 12, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(30, 13); fmt.Font.Size20 = 200; xls.SetCellFormat(30, 13, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(30, 14); fmt.Font.Size20 = 200; xls.SetCellFormat(30, 14, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(30, 15); fmt.Font.Size20 = 200; xls.SetCellFormat(30, 15, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(30, 16); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; xls.SetCellFormat(30, 16, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(30, 17); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; xls.SetCellFormat(30, 17, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(30, 18); fmt.Font.Size20 = 200; xls.SetCellFormat(30, 18, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(30, 19); fmt.Font.Size20 = 200; xls.SetCellFormat(30, 19, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(30, 22); fmt.HAlignment = THFlxAlignment.center; fmt.VAlignment = TVFlxAlignment.center; xls.SetCellFormat(30, 22, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(31, 2); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; fmt.Borders.Left.Style = TFlxBorderStyle.Thin; fmt.Borders.Left.Color = TExcelColor.Automatic; fmt.Borders.Right.Style = TFlxBorderStyle.Thin; fmt.Borders.Right.Color = TExcelColor.Automatic; fmt.HAlignment = THFlxAlignment.center; fmt.VAlignment = TVFlxAlignment.center; xls.SetCellFormat(31, 2, xls.AddFormat(fmt)); xls.SetCellValue(31, 2, "VKO"); fmt = xls.GetCellVisibleFormatDef(31, 3); fmt.Font.Size20 = 200; fmt.Borders.Right.Style = TFlxBorderStyle.Thin; fmt.Borders.Right.Color = TExcelColor.Automatic; fmt.Format = "#,##0"; fmt.HAlignment = THFlxAlignment.right; fmt.VAlignment = TVFlxAlignment.center; xls.SetCellFormat(31, 3, xls.AddFormat(fmt)); xls.SetCellValue(31, 3, 120826); fmt = xls.GetCellVisibleFormatDef(31, 4); fmt.Font.Size20 = 200; xls.SetCellFormat(31, 4, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(31, 5); fmt.Font.Size20 = 200; fmt.Borders.Left.Style = TFlxBorderStyle.Thin; fmt.Borders.Left.Color = TExcelColor.Automatic; fmt.Borders.Right.Style = TFlxBorderStyle.Thin; fmt.Borders.Right.Color = TExcelColor.Automatic; fmt.VAlignment = TVFlxAlignment.center; xls.SetCellFormat(31, 5, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(31, 6); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; fmt.Borders.Left.Style = TFlxBorderStyle.Thin; fmt.Borders.Left.Color = TExcelColor.Automatic; fmt.Borders.Right.Style = TFlxBorderStyle.Thin; fmt.Borders.Right.Color = TExcelColor.Automatic; fmt.HAlignment = THFlxAlignment.center; fmt.VAlignment = TVFlxAlignment.center; xls.SetCellFormat(31, 6, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(31, 7); fmt.Font.Size20 = 200; fmt.Borders.Right.Style = TFlxBorderStyle.Thin; fmt.Borders.Right.Color = TExcelColor.Automatic; fmt.Format = "#,##0"; fmt.HAlignment = THFlxAlignment.right; fmt.VAlignment = TVFlxAlignment.center; xls.SetCellFormat(31, 7, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(31, 8); fmt.Font.Size20 = 200; xls.SetCellFormat(31, 8, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(31, 9); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; fmt.Borders.Left.Style = TFlxBorderStyle.Thin; fmt.Borders.Left.Color = TExcelColor.Automatic; fmt.HAlignment = THFlxAlignment.center; fmt.VAlignment = TVFlxAlignment.center; xls.SetCellFormat(31, 9, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(31, 10); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; fmt.Borders.Right.Style = TFlxBorderStyle.Thin; fmt.Borders.Right.Color = TExcelColor.Automatic; fmt.HAlignment = THFlxAlignment.center; fmt.VAlignment = TVFlxAlignment.center; xls.SetCellFormat(31, 10, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(31, 11); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; fmt.Borders.Left.Style = TFlxBorderStyle.Thin; fmt.Borders.Left.Color = TExcelColor.Automatic; fmt.HAlignment = THFlxAlignment.center; xls.SetCellFormat(31, 11, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(31, 12); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; fmt.Borders.Right.Style = TFlxBorderStyle.Thin; fmt.Borders.Right.Color = TExcelColor.Automatic; fmt.HAlignment = THFlxAlignment.center; xls.SetCellFormat(31, 12, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(31, 13); fmt.Font.Size20 = 200; xls.SetCellFormat(31, 13, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(31, 14); fmt.Font.Size20 = 200; xls.SetCellFormat(31, 14, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(31, 15); fmt.Font.Size20 = 200; xls.SetCellFormat(31, 15, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(31, 16); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; xls.SetCellFormat(31, 16, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(31, 17); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; xls.SetCellFormat(31, 17, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(31, 18); fmt.Font.Size20 = 200; xls.SetCellFormat(31, 18, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(31, 19); fmt.Font.Size20 = 200; xls.SetCellFormat(31, 19, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(31, 22); fmt.HAlignment = THFlxAlignment.center; fmt.VAlignment = TVFlxAlignment.center; xls.SetCellFormat(31, 22, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(32, 2); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; fmt.Borders.Left.Style = TFlxBorderStyle.Thin; fmt.Borders.Left.Color = TExcelColor.Automatic; fmt.Borders.Right.Style = TFlxBorderStyle.Thin; fmt.Borders.Right.Color = TExcelColor.Automatic; fmt.HAlignment = THFlxAlignment.center; fmt.VAlignment = TVFlxAlignment.center; xls.SetCellFormat(32, 2, xls.AddFormat(fmt)); xls.SetCellValue(32, 2, "IKA"); fmt = xls.GetCellVisibleFormatDef(32, 3); fmt.Font.Size20 = 200; fmt.Borders.Right.Style = TFlxBorderStyle.Thin; fmt.Borders.Right.Color = TExcelColor.Automatic; fmt.Format = "#,##0"; fmt.HAlignment = THFlxAlignment.right; fmt.VAlignment = TVFlxAlignment.center; xls.SetCellFormat(32, 3, xls.AddFormat(fmt)); xls.SetCellValue(32, 3, 98847); fmt = xls.GetCellVisibleFormatDef(32, 4); fmt.Font.Size20 = 200; xls.SetCellFormat(32, 4, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(32, 5); fmt.Font.Size20 = 200; fmt.Borders.Left.Style = TFlxBorderStyle.Thin; fmt.Borders.Left.Color = TExcelColor.Automatic; fmt.Borders.Right.Style = TFlxBorderStyle.Thin; fmt.Borders.Right.Color = TExcelColor.Automatic; fmt.VAlignment = TVFlxAlignment.center; xls.SetCellFormat(32, 5, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(32, 6); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; fmt.Borders.Left.Style = TFlxBorderStyle.Thin; fmt.Borders.Left.Color = TExcelColor.Automatic; fmt.Borders.Right.Style = TFlxBorderStyle.Thin; fmt.Borders.Right.Color = TExcelColor.Automatic; fmt.HAlignment = THFlxAlignment.center; fmt.VAlignment = TVFlxAlignment.center; xls.SetCellFormat(32, 6, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(32, 7); fmt.Font.Size20 = 200; fmt.Borders.Right.Style = TFlxBorderStyle.Thin; fmt.Borders.Right.Color = TExcelColor.Automatic; fmt.Format = "#,##0"; fmt.HAlignment = THFlxAlignment.right; fmt.VAlignment = TVFlxAlignment.center; xls.SetCellFormat(32, 7, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(32, 8); fmt.Font.Size20 = 200; xls.SetCellFormat(32, 8, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(32, 9); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; fmt.Borders.Left.Style = TFlxBorderStyle.Thin; fmt.Borders.Left.Color = TExcelColor.Automatic; fmt.HAlignment = THFlxAlignment.center; fmt.VAlignment = TVFlxAlignment.center; xls.SetCellFormat(32, 9, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(32, 10); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; fmt.Borders.Right.Style = TFlxBorderStyle.Thin; fmt.Borders.Right.Color = TExcelColor.Automatic; fmt.HAlignment = THFlxAlignment.center; fmt.VAlignment = TVFlxAlignment.center; xls.SetCellFormat(32, 10, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(32, 11); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; fmt.Borders.Left.Style = TFlxBorderStyle.Thin; fmt.Borders.Left.Color = TExcelColor.Automatic; fmt.HAlignment = THFlxAlignment.center; xls.SetCellFormat(32, 11, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(32, 12); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; fmt.Borders.Right.Style = TFlxBorderStyle.Thin; fmt.Borders.Right.Color = TExcelColor.Automatic; fmt.HAlignment = THFlxAlignment.center; xls.SetCellFormat(32, 12, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(32, 13); fmt.Font.Size20 = 200; xls.SetCellFormat(32, 13, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(32, 14); fmt.Font.Size20 = 200; xls.SetCellFormat(32, 14, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(32, 15); fmt.Font.Size20 = 200; xls.SetCellFormat(32, 15, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(32, 16); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; xls.SetCellFormat(32, 16, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(32, 17); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; xls.SetCellFormat(32, 17, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(32, 18); fmt.Font.Size20 = 200; xls.SetCellFormat(32, 18, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(32, 19); fmt.Font.Size20 = 200; xls.SetCellFormat(32, 19, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(32, 22); fmt.HAlignment = THFlxAlignment.center; fmt.VAlignment = TVFlxAlignment.center; xls.SetCellFormat(32, 22, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(33, 2); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; fmt.Borders.Left.Style = TFlxBorderStyle.Thin; fmt.Borders.Left.Color = TExcelColor.Automatic; fmt.Borders.Right.Style = TFlxBorderStyle.Thin; fmt.Borders.Right.Color = TExcelColor.Automatic; fmt.HAlignment = THFlxAlignment.center; fmt.VAlignment = TVFlxAlignment.center; xls.SetCellFormat(33, 2, xls.AddFormat(fmt)); xls.SetCellValue(33, 2, "COV"); fmt = xls.GetCellVisibleFormatDef(33, 3); fmt.Font.Size20 = 200; fmt.Borders.Right.Style = TFlxBorderStyle.Thin; fmt.Borders.Right.Color = TExcelColor.Automatic; fmt.Format = "#,##0"; fmt.HAlignment = THFlxAlignment.right; fmt.VAlignment = TVFlxAlignment.center; xls.SetCellFormat(33, 3, xls.AddFormat(fmt)); xls.SetCellValue(33, 3, 88483); fmt = xls.GetCellVisibleFormatDef(33, 4); fmt.Font.Size20 = 200; xls.SetCellFormat(33, 4, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(33, 5); fmt.Font.Size20 = 200; fmt.Borders.Left.Style = TFlxBorderStyle.Thin; fmt.Borders.Left.Color = TExcelColor.Automatic; fmt.Borders.Right.Style = TFlxBorderStyle.Thin; fmt.Borders.Right.Color = TExcelColor.Automatic; fmt.VAlignment = TVFlxAlignment.center; xls.SetCellFormat(33, 5, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(33, 6); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; fmt.Borders.Left.Style = TFlxBorderStyle.Thin; fmt.Borders.Left.Color = TExcelColor.Automatic; fmt.Borders.Right.Style = TFlxBorderStyle.Thin; fmt.Borders.Right.Color = TExcelColor.Automatic; fmt.HAlignment = THFlxAlignment.center; fmt.VAlignment = TVFlxAlignment.center; xls.SetCellFormat(33, 6, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(33, 7); fmt.Font.Size20 = 200; fmt.Borders.Right.Style = TFlxBorderStyle.Thin; fmt.Borders.Right.Color = TExcelColor.Automatic; fmt.Format = "#,##0"; fmt.HAlignment = THFlxAlignment.right; fmt.VAlignment = TVFlxAlignment.center; xls.SetCellFormat(33, 7, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(33, 8); fmt.Font.Size20 = 200; xls.SetCellFormat(33, 8, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(33, 9); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; fmt.Borders.Left.Style = TFlxBorderStyle.Thin; fmt.Borders.Left.Color = TExcelColor.Automatic; fmt.HAlignment = THFlxAlignment.center; fmt.VAlignment = TVFlxAlignment.center; xls.SetCellFormat(33, 9, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(33, 10); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; fmt.Borders.Right.Style = TFlxBorderStyle.Thin; fmt.Borders.Right.Color = TExcelColor.Automatic; fmt.HAlignment = THFlxAlignment.center; fmt.VAlignment = TVFlxAlignment.center; xls.SetCellFormat(33, 10, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(33, 11); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; fmt.Borders.Left.Style = TFlxBorderStyle.Thin; fmt.Borders.Left.Color = TExcelColor.Automatic; fmt.HAlignment = THFlxAlignment.center; xls.SetCellFormat(33, 11, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(33, 12); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; fmt.Borders.Right.Style = TFlxBorderStyle.Thin; fmt.Borders.Right.Color = TExcelColor.Automatic; fmt.HAlignment = THFlxAlignment.center; xls.SetCellFormat(33, 12, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(33, 13); fmt.Font.Size20 = 200; xls.SetCellFormat(33, 13, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(33, 14); fmt.Font.Size20 = 200; xls.SetCellFormat(33, 14, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(33, 15); fmt.Font.Size20 = 200; xls.SetCellFormat(33, 15, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(33, 16); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; xls.SetCellFormat(33, 16, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(33, 17); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; xls.SetCellFormat(33, 17, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(33, 18); fmt.Font.Size20 = 200; xls.SetCellFormat(33, 18, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(33, 19); fmt.Font.Size20 = 200; xls.SetCellFormat(33, 19, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(33, 22); fmt.HAlignment = THFlxAlignment.center; fmt.VAlignment = TVFlxAlignment.center; xls.SetCellFormat(33, 22, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(34, 2); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; fmt.Borders.Left.Style = TFlxBorderStyle.Thin; fmt.Borders.Left.Color = TExcelColor.Automatic; fmt.Borders.Right.Style = TFlxBorderStyle.Thin; fmt.Borders.Right.Color = TExcelColor.Automatic; fmt.HAlignment = THFlxAlignment.center; fmt.VAlignment = TVFlxAlignment.center; xls.SetCellFormat(34, 2, xls.AddFormat(fmt)); xls.SetCellValue(34, 2, "ECN"); fmt = xls.GetCellVisibleFormatDef(34, 3); fmt.Font.Size20 = 200; fmt.Borders.Right.Style = TFlxBorderStyle.Thin; fmt.Borders.Right.Color = TExcelColor.Automatic; fmt.Format = "#,##0"; fmt.HAlignment = THFlxAlignment.right; fmt.VAlignment = TVFlxAlignment.center; xls.SetCellFormat(34, 3, xls.AddFormat(fmt)); xls.SetCellValue(34, 3, 83830); fmt = xls.GetCellVisibleFormatDef(34, 4); fmt.Font.Size20 = 200; xls.SetCellFormat(34, 4, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(34, 5); fmt.Font.Size20 = 200; fmt.Borders.Left.Style = TFlxBorderStyle.Thin; fmt.Borders.Left.Color = TExcelColor.Automatic; fmt.Borders.Right.Style = TFlxBorderStyle.Thin; fmt.Borders.Right.Color = TExcelColor.Automatic; fmt.VAlignment = TVFlxAlignment.center; xls.SetCellFormat(34, 5, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(34, 6); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; fmt.Borders.Left.Style = TFlxBorderStyle.Thin; fmt.Borders.Left.Color = TExcelColor.Automatic; fmt.Borders.Right.Style = TFlxBorderStyle.Thin; fmt.Borders.Right.Color = TExcelColor.Automatic; fmt.HAlignment = THFlxAlignment.center; fmt.VAlignment = TVFlxAlignment.center; xls.SetCellFormat(34, 6, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(34, 7); fmt.Font.Size20 = 200; fmt.Borders.Right.Style = TFlxBorderStyle.Thin; fmt.Borders.Right.Color = TExcelColor.Automatic; fmt.Format = "#,##0"; fmt.HAlignment = THFlxAlignment.right; fmt.VAlignment = TVFlxAlignment.center; xls.SetCellFormat(34, 7, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(34, 8); fmt.Font.Size20 = 200; xls.SetCellFormat(34, 8, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(34, 9); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; fmt.Borders.Left.Style = TFlxBorderStyle.Thin; fmt.Borders.Left.Color = TExcelColor.Automatic; fmt.HAlignment = THFlxAlignment.center; fmt.VAlignment = TVFlxAlignment.center; xls.SetCellFormat(34, 9, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(34, 10); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; fmt.Borders.Right.Style = TFlxBorderStyle.Thin; fmt.Borders.Right.Color = TExcelColor.Automatic; fmt.HAlignment = THFlxAlignment.center; fmt.VAlignment = TVFlxAlignment.center; xls.SetCellFormat(34, 10, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(34, 11); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; fmt.Borders.Left.Style = TFlxBorderStyle.Thin; fmt.Borders.Left.Color = TExcelColor.Automatic; fmt.HAlignment = THFlxAlignment.center; xls.SetCellFormat(34, 11, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(34, 12); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; fmt.Borders.Right.Style = TFlxBorderStyle.Thin; fmt.Borders.Right.Color = TExcelColor.Automatic; fmt.HAlignment = THFlxAlignment.center; xls.SetCellFormat(34, 12, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(34, 13); fmt.Font.Size20 = 200; xls.SetCellFormat(34, 13, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(34, 14); fmt.Font.Size20 = 200; xls.SetCellFormat(34, 14, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(34, 15); fmt.Font.Size20 = 200; xls.SetCellFormat(34, 15, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(34, 16); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; xls.SetCellFormat(34, 16, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(34, 17); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; xls.SetCellFormat(34, 17, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(34, 18); fmt.Font.Size20 = 200; xls.SetCellFormat(34, 18, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(34, 19); fmt.Font.Size20 = 200; xls.SetCellFormat(34, 19, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(34, 22); fmt.HAlignment = THFlxAlignment.center; fmt.VAlignment = TVFlxAlignment.center; xls.SetCellFormat(34, 22, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(35, 2); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; fmt.Borders.Left.Style = TFlxBorderStyle.Thin; fmt.Borders.Left.Color = TExcelColor.Automatic; fmt.Borders.Right.Style = TFlxBorderStyle.Thin; fmt.Borders.Right.Color = TExcelColor.Automatic; fmt.HAlignment = THFlxAlignment.center; fmt.VAlignment = TVFlxAlignment.center; xls.SetCellFormat(35, 2, xls.AddFormat(fmt)); xls.SetCellValue(35, 2, "AMS"); fmt = xls.GetCellVisibleFormatDef(35, 3); fmt.Font.Size20 = 200; fmt.Borders.Right.Style = TFlxBorderStyle.Thin; fmt.Borders.Right.Color = TExcelColor.Automatic; fmt.Format = "#,##0"; fmt.HAlignment = THFlxAlignment.right; fmt.VAlignment = TVFlxAlignment.center; xls.SetCellFormat(35, 3, xls.AddFormat(fmt)); xls.SetCellValue(35, 3, 82710); fmt = xls.GetCellVisibleFormatDef(35, 4); fmt.Font.Size20 = 200; xls.SetCellFormat(35, 4, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(35, 5); fmt.Font.Size20 = 200; fmt.Borders.Left.Style = TFlxBorderStyle.Thin; fmt.Borders.Left.Color = TExcelColor.Automatic; fmt.Borders.Right.Style = TFlxBorderStyle.Thin; fmt.Borders.Right.Color = TExcelColor.Automatic; fmt.VAlignment = TVFlxAlignment.center; xls.SetCellFormat(35, 5, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(35, 6); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; fmt.Borders.Left.Style = TFlxBorderStyle.Thin; fmt.Borders.Left.Color = TExcelColor.Automatic; fmt.Borders.Right.Style = TFlxBorderStyle.Thin; fmt.Borders.Right.Color = TExcelColor.Automatic; fmt.HAlignment = THFlxAlignment.center; fmt.VAlignment = TVFlxAlignment.center; xls.SetCellFormat(35, 6, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(35, 7); fmt.Font.Size20 = 200; fmt.Borders.Right.Style = TFlxBorderStyle.Thin; fmt.Borders.Right.Color = TExcelColor.Automatic; fmt.Format = "#,##0"; fmt.HAlignment = THFlxAlignment.right; fmt.VAlignment = TVFlxAlignment.center; xls.SetCellFormat(35, 7, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(35, 8); fmt.Font.Size20 = 200; xls.SetCellFormat(35, 8, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(35, 9); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; fmt.Borders.Left.Style = TFlxBorderStyle.Thin; fmt.Borders.Left.Color = TExcelColor.Automatic; fmt.HAlignment = THFlxAlignment.center; fmt.VAlignment = TVFlxAlignment.center; xls.SetCellFormat(35, 9, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(35, 10); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; fmt.Borders.Right.Style = TFlxBorderStyle.Thin; fmt.Borders.Right.Color = TExcelColor.Automatic; fmt.HAlignment = THFlxAlignment.center; fmt.VAlignment = TVFlxAlignment.center; xls.SetCellFormat(35, 10, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(35, 11); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; fmt.Borders.Left.Style = TFlxBorderStyle.Thin; fmt.Borders.Left.Color = TExcelColor.Automatic; fmt.HAlignment = THFlxAlignment.center; xls.SetCellFormat(35, 11, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(35, 12); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; fmt.Borders.Right.Style = TFlxBorderStyle.Thin; fmt.Borders.Right.Color = TExcelColor.Automatic; fmt.HAlignment = THFlxAlignment.center; xls.SetCellFormat(35, 12, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(35, 13); fmt.Font.Size20 = 200; xls.SetCellFormat(35, 13, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(35, 14); fmt.Font.Size20 = 200; xls.SetCellFormat(35, 14, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(35, 15); fmt.Font.Size20 = 200; xls.SetCellFormat(35, 15, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(35, 16); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; xls.SetCellFormat(35, 16, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(35, 17); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; xls.SetCellFormat(35, 17, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(35, 18); fmt.Font.Size20 = 200; xls.SetCellFormat(35, 18, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(35, 19); fmt.Font.Size20 = 200; xls.SetCellFormat(35, 19, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(35, 22); fmt.HAlignment = THFlxAlignment.center; fmt.VAlignment = TVFlxAlignment.center; xls.SetCellFormat(35, 22, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(36, 2); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; fmt.Borders.Left.Style = TFlxBorderStyle.Thin; fmt.Borders.Left.Color = TExcelColor.Automatic; fmt.Borders.Right.Style = TFlxBorderStyle.Thin; fmt.Borders.Right.Color = TExcelColor.Automatic; fmt.HAlignment = THFlxAlignment.center; fmt.VAlignment = TVFlxAlignment.center; xls.SetCellFormat(36, 2, xls.AddFormat(fmt)); xls.SetCellValue(36, 2, "HRG"); fmt = xls.GetCellVisibleFormatDef(36, 3); fmt.Font.Size20 = 200; fmt.Borders.Right.Style = TFlxBorderStyle.Thin; fmt.Borders.Right.Color = TExcelColor.Automatic; fmt.Format = "#,##0"; fmt.HAlignment = THFlxAlignment.right; fmt.VAlignment = TVFlxAlignment.center; xls.SetCellFormat(36, 3, xls.AddFormat(fmt)); xls.SetCellValue(36, 3, 79317); fmt = xls.GetCellVisibleFormatDef(36, 4); fmt.Font.Size20 = 200; xls.SetCellFormat(36, 4, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(36, 5); fmt.Font.Size20 = 200; fmt.Borders.Left.Style = TFlxBorderStyle.Thin; fmt.Borders.Left.Color = TExcelColor.Automatic; fmt.Borders.Right.Style = TFlxBorderStyle.Thin; fmt.Borders.Right.Color = TExcelColor.Automatic; fmt.VAlignment = TVFlxAlignment.center; xls.SetCellFormat(36, 5, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(36, 6); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; fmt.Borders.Left.Style = TFlxBorderStyle.Thin; fmt.Borders.Left.Color = TExcelColor.Automatic; fmt.Borders.Right.Style = TFlxBorderStyle.Thin; fmt.Borders.Right.Color = TExcelColor.Automatic; fmt.HAlignment = THFlxAlignment.center; fmt.VAlignment = TVFlxAlignment.center; xls.SetCellFormat(36, 6, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(36, 7); fmt.Font.Size20 = 200; fmt.Borders.Right.Style = TFlxBorderStyle.Thin; fmt.Borders.Right.Color = TExcelColor.Automatic; fmt.Format = "#,##0"; fmt.HAlignment = THFlxAlignment.right; fmt.VAlignment = TVFlxAlignment.center; xls.SetCellFormat(36, 7, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(36, 8); fmt.Font.Size20 = 200; xls.SetCellFormat(36, 8, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(36, 9); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; fmt.Borders.Left.Style = TFlxBorderStyle.Thin; fmt.Borders.Left.Color = TExcelColor.Automatic; fmt.HAlignment = THFlxAlignment.center; fmt.VAlignment = TVFlxAlignment.center; xls.SetCellFormat(36, 9, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(36, 10); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; fmt.Borders.Right.Style = TFlxBorderStyle.Thin; fmt.Borders.Right.Color = TExcelColor.Automatic; fmt.HAlignment = THFlxAlignment.center; fmt.VAlignment = TVFlxAlignment.center; xls.SetCellFormat(36, 10, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(36, 11); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; fmt.Borders.Left.Style = TFlxBorderStyle.Thin; fmt.Borders.Left.Color = TExcelColor.Automatic; fmt.HAlignment = THFlxAlignment.center; xls.SetCellFormat(36, 11, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(36, 12); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; fmt.Borders.Right.Style = TFlxBorderStyle.Thin; fmt.Borders.Right.Color = TExcelColor.Automatic; fmt.HAlignment = THFlxAlignment.center; xls.SetCellFormat(36, 12, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(36, 13); fmt.Font.Size20 = 200; xls.SetCellFormat(36, 13, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(36, 14); fmt.Font.Size20 = 200; xls.SetCellFormat(36, 14, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(36, 15); fmt.Font.Size20 = 200; xls.SetCellFormat(36, 15, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(36, 16); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; xls.SetCellFormat(36, 16, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(36, 17); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; xls.SetCellFormat(36, 17, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(36, 18); fmt.Font.Size20 = 200; xls.SetCellFormat(36, 18, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(36, 19); fmt.Font.Size20 = 200; xls.SetCellFormat(36, 19, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(36, 22); fmt.HAlignment = THFlxAlignment.center; fmt.VAlignment = TVFlxAlignment.center; xls.SetCellFormat(36, 22, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(37, 2); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; fmt.Borders.Left.Style = TFlxBorderStyle.Thin; fmt.Borders.Left.Color = TExcelColor.Automatic; fmt.Borders.Right.Style = TFlxBorderStyle.Thin; fmt.Borders.Right.Color = TExcelColor.Automatic; fmt.HAlignment = THFlxAlignment.center; fmt.VAlignment = TVFlxAlignment.center; xls.SetCellFormat(37, 2, xls.AddFormat(fmt)); xls.SetCellValue(37, 2, "TBS"); fmt = xls.GetCellVisibleFormatDef(37, 3); fmt.Font.Size20 = 200; fmt.Borders.Right.Style = TFlxBorderStyle.Thin; fmt.Borders.Right.Color = TExcelColor.Automatic; fmt.Format = "#,##0"; fmt.HAlignment = THFlxAlignment.right; fmt.VAlignment = TVFlxAlignment.center; xls.SetCellFormat(37, 3, xls.AddFormat(fmt)); xls.SetCellValue(37, 3, 77584); fmt = xls.GetCellVisibleFormatDef(37, 4); fmt.Font.Size20 = 200; xls.SetCellFormat(37, 4, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(37, 5); fmt.Font.Size20 = 200; fmt.Borders.Left.Style = TFlxBorderStyle.Thin; fmt.Borders.Left.Color = TExcelColor.Automatic; fmt.Borders.Right.Style = TFlxBorderStyle.Thin; fmt.Borders.Right.Color = TExcelColor.Automatic; fmt.VAlignment = TVFlxAlignment.center; xls.SetCellFormat(37, 5, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(37, 6); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; fmt.Borders.Left.Style = TFlxBorderStyle.Thin; fmt.Borders.Left.Color = TExcelColor.Automatic; fmt.Borders.Right.Style = TFlxBorderStyle.Thin; fmt.Borders.Right.Color = TExcelColor.Automatic; fmt.HAlignment = THFlxAlignment.center; fmt.VAlignment = TVFlxAlignment.center; xls.SetCellFormat(37, 6, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(37, 7); fmt.Font.Size20 = 200; fmt.Borders.Right.Style = TFlxBorderStyle.Thin; fmt.Borders.Right.Color = TExcelColor.Automatic; fmt.Format = "#,##0"; fmt.HAlignment = THFlxAlignment.right; fmt.VAlignment = TVFlxAlignment.center; xls.SetCellFormat(37, 7, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(37, 8); fmt.Font.Size20 = 200; xls.SetCellFormat(37, 8, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(37, 9); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; fmt.Borders.Left.Style = TFlxBorderStyle.Thin; fmt.Borders.Left.Color = TExcelColor.Automatic; fmt.HAlignment = THFlxAlignment.center; fmt.VAlignment = TVFlxAlignment.center; xls.SetCellFormat(37, 9, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(37, 10); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; fmt.Borders.Right.Style = TFlxBorderStyle.Thin; fmt.Borders.Right.Color = TExcelColor.Automatic; fmt.HAlignment = THFlxAlignment.center; fmt.VAlignment = TVFlxAlignment.center; xls.SetCellFormat(37, 10, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(37, 11); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; fmt.Borders.Left.Style = TFlxBorderStyle.Thin; fmt.Borders.Left.Color = TExcelColor.Automatic; fmt.HAlignment = THFlxAlignment.center; xls.SetCellFormat(37, 11, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(37, 12); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; fmt.Borders.Right.Style = TFlxBorderStyle.Thin; fmt.Borders.Right.Color = TExcelColor.Automatic; fmt.HAlignment = THFlxAlignment.center; xls.SetCellFormat(37, 12, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(37, 13); fmt.Font.Size20 = 200; xls.SetCellFormat(37, 13, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(37, 14); fmt.Font.Size20 = 200; xls.SetCellFormat(37, 14, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(37, 15); fmt.Font.Size20 = 200; xls.SetCellFormat(37, 15, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(37, 16); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; xls.SetCellFormat(37, 16, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(37, 17); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; xls.SetCellFormat(37, 17, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(37, 18); fmt.Font.Size20 = 200; xls.SetCellFormat(37, 18, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(37, 19); fmt.Font.Size20 = 200; xls.SetCellFormat(37, 19, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(37, 22); fmt.HAlignment = THFlxAlignment.center; fmt.VAlignment = TVFlxAlignment.center; xls.SetCellFormat(37, 22, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(38, 2); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; fmt.Borders.Left.Style = TFlxBorderStyle.Thin; fmt.Borders.Left.Color = TExcelColor.Automatic; fmt.Borders.Right.Style = TFlxBorderStyle.Thin; fmt.Borders.Right.Color = TExcelColor.Automatic; fmt.HAlignment = THFlxAlignment.center; fmt.VAlignment = TVFlxAlignment.center; xls.SetCellFormat(38, 2, xls.AddFormat(fmt)); xls.SetCellValue(38, 2, "TZX"); fmt = xls.GetCellVisibleFormatDef(38, 3); fmt.Font.Size20 = 200; fmt.Borders.Right.Style = TFlxBorderStyle.Thin; fmt.Borders.Right.Color = TExcelColor.Automatic; fmt.Format = "#,##0"; fmt.HAlignment = THFlxAlignment.right; fmt.VAlignment = TVFlxAlignment.center; xls.SetCellFormat(38, 3, xls.AddFormat(fmt)); xls.SetCellValue(38, 3, 76797); fmt = xls.GetCellVisibleFormatDef(38, 4); fmt.Font.Size20 = 200; xls.SetCellFormat(38, 4, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(38, 5); fmt.Font.Size20 = 200; fmt.Borders.Left.Style = TFlxBorderStyle.Thin; fmt.Borders.Left.Color = TExcelColor.Automatic; fmt.Borders.Right.Style = TFlxBorderStyle.Thin; fmt.Borders.Right.Color = TExcelColor.Automatic; fmt.VAlignment = TVFlxAlignment.center; xls.SetCellFormat(38, 5, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(38, 6); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; fmt.Borders.Left.Style = TFlxBorderStyle.Thin; fmt.Borders.Left.Color = TExcelColor.Automatic; fmt.Borders.Right.Style = TFlxBorderStyle.Thin; fmt.Borders.Right.Color = TExcelColor.Automatic; fmt.HAlignment = THFlxAlignment.center; fmt.VAlignment = TVFlxAlignment.center; xls.SetCellFormat(38, 6, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(38, 7); fmt.Font.Size20 = 200; fmt.Borders.Right.Style = TFlxBorderStyle.Thin; fmt.Borders.Right.Color = TExcelColor.Automatic; fmt.Format = "#,##0"; fmt.HAlignment = THFlxAlignment.right; fmt.VAlignment = TVFlxAlignment.center; xls.SetCellFormat(38, 7, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(38, 8); fmt.Font.Size20 = 200; xls.SetCellFormat(38, 8, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(38, 9); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; fmt.Borders.Left.Style = TFlxBorderStyle.Thin; fmt.Borders.Left.Color = TExcelColor.Automatic; fmt.HAlignment = THFlxAlignment.center; fmt.VAlignment = TVFlxAlignment.center; xls.SetCellFormat(38, 9, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(38, 10); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; fmt.Borders.Right.Style = TFlxBorderStyle.Thin; fmt.Borders.Right.Color = TExcelColor.Automatic; fmt.HAlignment = THFlxAlignment.center; fmt.VAlignment = TVFlxAlignment.center; xls.SetCellFormat(38, 10, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(38, 11); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; fmt.Borders.Left.Style = TFlxBorderStyle.Thin; fmt.Borders.Left.Color = TExcelColor.Automatic; fmt.HAlignment = THFlxAlignment.center; xls.SetCellFormat(38, 11, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(38, 12); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; fmt.Borders.Right.Style = TFlxBorderStyle.Thin; fmt.Borders.Right.Color = TExcelColor.Automatic; fmt.HAlignment = THFlxAlignment.center; xls.SetCellFormat(38, 12, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(38, 13); fmt.Font.Size20 = 200; xls.SetCellFormat(38, 13, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(38, 14); fmt.Font.Size20 = 200; xls.SetCellFormat(38, 14, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(38, 15); fmt.Font.Size20 = 200; xls.SetCellFormat(38, 15, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(38, 16); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; xls.SetCellFormat(38, 16, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(38, 17); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; xls.SetCellFormat(38, 17, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(38, 18); fmt.Font.Size20 = 200; xls.SetCellFormat(38, 18, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(38, 19); fmt.Font.Size20 = 200; xls.SetCellFormat(38, 19, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(38, 22); fmt.HAlignment = THFlxAlignment.center; fmt.VAlignment = TVFlxAlignment.center; xls.SetCellFormat(38, 22, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(39, 2); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; fmt.Borders.Left.Style = TFlxBorderStyle.Thin; fmt.Borders.Left.Color = TExcelColor.Automatic; fmt.Borders.Right.Style = TFlxBorderStyle.Thin; fmt.Borders.Right.Color = TExcelColor.Automatic; fmt.HAlignment = THFlxAlignment.center; fmt.VAlignment = TVFlxAlignment.center; xls.SetCellFormat(39, 2, xls.AddFormat(fmt)); xls.SetCellValue(39, 2, "LED"); fmt = xls.GetCellVisibleFormatDef(39, 3); fmt.Font.Size20 = 200; fmt.Borders.Right.Style = TFlxBorderStyle.Thin; fmt.Borders.Right.Color = TExcelColor.Automatic; fmt.Format = "#,##0"; fmt.HAlignment = THFlxAlignment.right; fmt.VAlignment = TVFlxAlignment.center; xls.SetCellFormat(39, 3, xls.AddFormat(fmt)); xls.SetCellValue(39, 3, 73848); fmt = xls.GetCellVisibleFormatDef(39, 4); fmt.Font.Size20 = 200; xls.SetCellFormat(39, 4, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(39, 5); fmt.Font.Size20 = 200; fmt.Borders.Left.Style = TFlxBorderStyle.Thin; fmt.Borders.Left.Color = TExcelColor.Automatic; fmt.Borders.Right.Style = TFlxBorderStyle.Thin; fmt.Borders.Right.Color = TExcelColor.Automatic; fmt.VAlignment = TVFlxAlignment.center; xls.SetCellFormat(39, 5, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(39, 6); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; fmt.Borders.Left.Style = TFlxBorderStyle.Thin; fmt.Borders.Left.Color = TExcelColor.Automatic; fmt.Borders.Right.Style = TFlxBorderStyle.Thin; fmt.Borders.Right.Color = TExcelColor.Automatic; fmt.HAlignment = THFlxAlignment.center; fmt.VAlignment = TVFlxAlignment.center; xls.SetCellFormat(39, 6, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(39, 7); fmt.Font.Size20 = 200; fmt.Borders.Right.Style = TFlxBorderStyle.Thin; fmt.Borders.Right.Color = TExcelColor.Automatic; fmt.Format = "#,##0"; fmt.HAlignment = THFlxAlignment.right; fmt.VAlignment = TVFlxAlignment.center; xls.SetCellFormat(39, 7, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(39, 8); fmt.Font.Size20 = 200; xls.SetCellFormat(39, 8, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(39, 9); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; fmt.Borders.Left.Style = TFlxBorderStyle.Thin; fmt.Borders.Left.Color = TExcelColor.Automatic; fmt.HAlignment = THFlxAlignment.center; fmt.VAlignment = TVFlxAlignment.center; xls.SetCellFormat(39, 9, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(39, 10); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; fmt.Borders.Right.Style = TFlxBorderStyle.Thin; fmt.Borders.Right.Color = TExcelColor.Automatic; fmt.HAlignment = THFlxAlignment.center; fmt.VAlignment = TVFlxAlignment.center; xls.SetCellFormat(39, 10, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(39, 11); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; fmt.Borders.Left.Style = TFlxBorderStyle.Thin; fmt.Borders.Left.Color = TExcelColor.Automatic; fmt.HAlignment = THFlxAlignment.center; xls.SetCellFormat(39, 11, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(39, 12); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; fmt.Borders.Right.Style = TFlxBorderStyle.Thin; fmt.Borders.Right.Color = TExcelColor.Automatic; fmt.HAlignment = THFlxAlignment.center; xls.SetCellFormat(39, 12, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(39, 13); fmt.Font.Size20 = 200; xls.SetCellFormat(39, 13, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(39, 14); fmt.Font.Size20 = 200; xls.SetCellFormat(39, 14, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(39, 15); fmt.Font.Size20 = 200; xls.SetCellFormat(39, 15, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(39, 16); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; xls.SetCellFormat(39, 16, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(39, 17); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; xls.SetCellFormat(39, 17, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(39, 18); fmt.Font.Size20 = 200; xls.SetCellFormat(39, 18, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(39, 19); fmt.Font.Size20 = 200; xls.SetCellFormat(39, 19, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(39, 22); fmt.HAlignment = THFlxAlignment.center; fmt.VAlignment = TVFlxAlignment.center; xls.SetCellFormat(39, 22, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(40, 2); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; fmt.Borders.Left.Style = TFlxBorderStyle.Thin; fmt.Borders.Left.Color = TExcelColor.Automatic; fmt.Borders.Right.Style = TFlxBorderStyle.Thin; fmt.Borders.Right.Color = TExcelColor.Automatic; fmt.HAlignment = THFlxAlignment.center; fmt.VAlignment = TVFlxAlignment.center; xls.SetCellFormat(40, 2, xls.AddFormat(fmt)); xls.SetCellValue(40, 2, "DUS"); fmt = xls.GetCellVisibleFormatDef(40, 3); fmt.Font.Size20 = 200; fmt.Borders.Right.Style = TFlxBorderStyle.Thin; fmt.Borders.Right.Color = TExcelColor.Automatic; fmt.Format = "#,##0"; fmt.HAlignment = THFlxAlignment.right; fmt.VAlignment = TVFlxAlignment.center; xls.SetCellFormat(40, 3, xls.AddFormat(fmt)); xls.SetCellValue(40, 3, 72749); fmt = xls.GetCellVisibleFormatDef(40, 4); fmt.Font.Size20 = 200; xls.SetCellFormat(40, 4, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(40, 5); fmt.Font.Size20 = 200; fmt.Borders.Left.Style = TFlxBorderStyle.Thin; fmt.Borders.Left.Color = TExcelColor.Automatic; fmt.Borders.Right.Style = TFlxBorderStyle.Thin; fmt.Borders.Right.Color = TExcelColor.Automatic; fmt.VAlignment = TVFlxAlignment.center; xls.SetCellFormat(40, 5, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(40, 6); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; fmt.Borders.Left.Style = TFlxBorderStyle.Thin; fmt.Borders.Left.Color = TExcelColor.Automatic; fmt.Borders.Right.Style = TFlxBorderStyle.Thin; fmt.Borders.Right.Color = TExcelColor.Automatic; fmt.HAlignment = THFlxAlignment.center; fmt.VAlignment = TVFlxAlignment.center; xls.SetCellFormat(40, 6, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(40, 7); fmt.Font.Size20 = 200; fmt.Borders.Right.Style = TFlxBorderStyle.Thin; fmt.Borders.Right.Color = TExcelColor.Automatic; fmt.Format = "#,##0"; fmt.HAlignment = THFlxAlignment.right; fmt.VAlignment = TVFlxAlignment.center; xls.SetCellFormat(40, 7, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(40, 8); fmt.Font.Size20 = 200; xls.SetCellFormat(40, 8, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(40, 9); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; fmt.Borders.Left.Style = TFlxBorderStyle.Thin; fmt.Borders.Left.Color = TExcelColor.Automatic; fmt.HAlignment = THFlxAlignment.center; fmt.VAlignment = TVFlxAlignment.center; xls.SetCellFormat(40, 9, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(40, 10); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; fmt.Borders.Right.Style = TFlxBorderStyle.Thin; fmt.Borders.Right.Color = TExcelColor.Automatic; fmt.HAlignment = THFlxAlignment.center; fmt.VAlignment = TVFlxAlignment.center; xls.SetCellFormat(40, 10, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(40, 11); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; fmt.Borders.Left.Style = TFlxBorderStyle.Thin; fmt.Borders.Left.Color = TExcelColor.Automatic; fmt.HAlignment = THFlxAlignment.center; xls.SetCellFormat(40, 11, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(40, 12); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; fmt.Borders.Right.Style = TFlxBorderStyle.Thin; fmt.Borders.Right.Color = TExcelColor.Automatic; fmt.HAlignment = THFlxAlignment.center; xls.SetCellFormat(40, 12, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(40, 13); fmt.Font.Size20 = 200; xls.SetCellFormat(40, 13, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(40, 14); fmt.Font.Size20 = 200; xls.SetCellFormat(40, 14, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(40, 15); fmt.Font.Size20 = 200; xls.SetCellFormat(40, 15, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(40, 16); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; xls.SetCellFormat(40, 16, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(40, 17); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; xls.SetCellFormat(40, 17, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(40, 18); fmt.Font.Size20 = 200; xls.SetCellFormat(40, 18, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(40, 19); fmt.Font.Size20 = 200; xls.SetCellFormat(40, 19, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(40, 22); fmt.HAlignment = THFlxAlignment.center; fmt.VAlignment = TVFlxAlignment.center; xls.SetCellFormat(40, 22, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(41, 2); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; fmt.Borders.Left.Style = TFlxBorderStyle.Thin; fmt.Borders.Left.Color = TExcelColor.Automatic; fmt.Borders.Right.Style = TFlxBorderStyle.Thin; fmt.Borders.Right.Color = TExcelColor.Automatic; fmt.HAlignment = THFlxAlignment.center; fmt.VAlignment = TVFlxAlignment.center; xls.SetCellFormat(41, 2, xls.AddFormat(fmt)); xls.SetCellValue(41, 2, "BER"); fmt = xls.GetCellVisibleFormatDef(41, 3); fmt.Font.Size20 = 200; fmt.Borders.Right.Style = TFlxBorderStyle.Thin; fmt.Borders.Right.Color = TExcelColor.Automatic; fmt.Format = "#,##0"; fmt.HAlignment = THFlxAlignment.right; fmt.VAlignment = TVFlxAlignment.center; xls.SetCellFormat(41, 3, xls.AddFormat(fmt)); xls.SetCellValue(41, 3, 69988); fmt = xls.GetCellVisibleFormatDef(41, 4); fmt.Font.Size20 = 200; xls.SetCellFormat(41, 4, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(41, 5); fmt.Font.Size20 = 200; fmt.Borders.Left.Style = TFlxBorderStyle.Thin; fmt.Borders.Left.Color = TExcelColor.Automatic; fmt.Borders.Right.Style = TFlxBorderStyle.Thin; fmt.Borders.Right.Color = TExcelColor.Automatic; fmt.VAlignment = TVFlxAlignment.center; xls.SetCellFormat(41, 5, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(41, 6); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; fmt.Borders.Left.Style = TFlxBorderStyle.Thin; fmt.Borders.Left.Color = TExcelColor.Automatic; fmt.Borders.Right.Style = TFlxBorderStyle.Thin; fmt.Borders.Right.Color = TExcelColor.Automatic; fmt.HAlignment = THFlxAlignment.center; fmt.VAlignment = TVFlxAlignment.center; xls.SetCellFormat(41, 6, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(41, 7); fmt.Font.Size20 = 200; fmt.Borders.Right.Style = TFlxBorderStyle.Thin; fmt.Borders.Right.Color = TExcelColor.Automatic; fmt.Format = "#,##0"; fmt.HAlignment = THFlxAlignment.right; fmt.VAlignment = TVFlxAlignment.center; xls.SetCellFormat(41, 7, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(41, 8); fmt.Font.Size20 = 200; xls.SetCellFormat(41, 8, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(41, 9); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; fmt.Borders.Left.Style = TFlxBorderStyle.Thin; fmt.Borders.Left.Color = TExcelColor.Automatic; fmt.HAlignment = THFlxAlignment.center; fmt.VAlignment = TVFlxAlignment.center; xls.SetCellFormat(41, 9, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(41, 10); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; fmt.Borders.Right.Style = TFlxBorderStyle.Thin; fmt.Borders.Right.Color = TExcelColor.Automatic; fmt.HAlignment = THFlxAlignment.center; fmt.VAlignment = TVFlxAlignment.center; xls.SetCellFormat(41, 10, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(41, 11); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; fmt.Borders.Left.Style = TFlxBorderStyle.Thin; fmt.Borders.Left.Color = TExcelColor.Automatic; fmt.HAlignment = THFlxAlignment.center; xls.SetCellFormat(41, 11, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(41, 12); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; fmt.Borders.Right.Style = TFlxBorderStyle.Thin; fmt.Borders.Right.Color = TExcelColor.Automatic; fmt.HAlignment = THFlxAlignment.center; xls.SetCellFormat(41, 12, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(41, 13); fmt.Font.Size20 = 200; xls.SetCellFormat(41, 13, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(41, 14); fmt.Font.Size20 = 200; xls.SetCellFormat(41, 14, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(41, 15); fmt.Font.Size20 = 200; xls.SetCellFormat(41, 15, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(41, 16); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; xls.SetCellFormat(41, 16, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(41, 17); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; xls.SetCellFormat(41, 17, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(41, 18); fmt.Font.Size20 = 200; xls.SetCellFormat(41, 18, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(41, 19); fmt.Font.Size20 = 200; xls.SetCellFormat(41, 19, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(41, 22); fmt.HAlignment = THFlxAlignment.center; fmt.VAlignment = TVFlxAlignment.center; xls.SetCellFormat(41, 22, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(42, 2); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; fmt.Borders.Left.Style = TFlxBorderStyle.Thin; fmt.Borders.Left.Color = TExcelColor.Automatic; fmt.Borders.Right.Style = TFlxBorderStyle.Thin; fmt.Borders.Right.Color = TExcelColor.Automatic; fmt.HAlignment = THFlxAlignment.center; fmt.VAlignment = TVFlxAlignment.center; xls.SetCellFormat(42, 2, xls.AddFormat(fmt)); xls.SetCellValue(42, 2, "ASR"); fmt = xls.GetCellVisibleFormatDef(42, 3); fmt.Font.Size20 = 200; fmt.Borders.Right.Style = TFlxBorderStyle.Thin; fmt.Borders.Right.Color = TExcelColor.Automatic; fmt.Format = "#,##0"; fmt.HAlignment = THFlxAlignment.right; fmt.VAlignment = TVFlxAlignment.center; xls.SetCellFormat(42, 3, xls.AddFormat(fmt)); xls.SetCellValue(42, 3, 67142); fmt = xls.GetCellVisibleFormatDef(42, 4); fmt.Font.Size20 = 200; xls.SetCellFormat(42, 4, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(42, 5); fmt.Font.Size20 = 200; fmt.Borders.Left.Style = TFlxBorderStyle.Thin; fmt.Borders.Left.Color = TExcelColor.Automatic; fmt.Borders.Right.Style = TFlxBorderStyle.Thin; fmt.Borders.Right.Color = TExcelColor.Automatic; fmt.VAlignment = TVFlxAlignment.center; xls.SetCellFormat(42, 5, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(42, 6); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; fmt.Borders.Left.Style = TFlxBorderStyle.Thin; fmt.Borders.Left.Color = TExcelColor.Automatic; fmt.Borders.Right.Style = TFlxBorderStyle.Thin; fmt.Borders.Right.Color = TExcelColor.Automatic; fmt.HAlignment = THFlxAlignment.center; fmt.VAlignment = TVFlxAlignment.center; xls.SetCellFormat(42, 6, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(42, 7); fmt.Font.Size20 = 200; fmt.Borders.Right.Style = TFlxBorderStyle.Thin; fmt.Borders.Right.Color = TExcelColor.Automatic; fmt.Format = "#,##0"; fmt.HAlignment = THFlxAlignment.right; fmt.VAlignment = TVFlxAlignment.center; xls.SetCellFormat(42, 7, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(42, 8); fmt.Font.Size20 = 200; xls.SetCellFormat(42, 8, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(42, 9); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; fmt.Borders.Left.Style = TFlxBorderStyle.Thin; fmt.Borders.Left.Color = TExcelColor.Automatic; fmt.HAlignment = THFlxAlignment.center; fmt.VAlignment = TVFlxAlignment.center; xls.SetCellFormat(42, 9, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(42, 10); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; fmt.Borders.Right.Style = TFlxBorderStyle.Thin; fmt.Borders.Right.Color = TExcelColor.Automatic; fmt.HAlignment = THFlxAlignment.center; fmt.VAlignment = TVFlxAlignment.center; xls.SetCellFormat(42, 10, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(42, 11); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; fmt.Borders.Left.Style = TFlxBorderStyle.Thin; fmt.Borders.Left.Color = TExcelColor.Automatic; fmt.HAlignment = THFlxAlignment.center; xls.SetCellFormat(42, 11, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(42, 12); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; fmt.Borders.Right.Style = TFlxBorderStyle.Thin; fmt.Borders.Right.Color = TExcelColor.Automatic; fmt.HAlignment = THFlxAlignment.center; xls.SetCellFormat(42, 12, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(42, 13); fmt.Font.Size20 = 200; xls.SetCellFormat(42, 13, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(42, 14); fmt.Font.Size20 = 200; xls.SetCellFormat(42, 14, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(42, 15); fmt.Font.Size20 = 200; xls.SetCellFormat(42, 15, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(42, 16); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; xls.SetCellFormat(42, 16, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(42, 17); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; xls.SetCellFormat(42, 17, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(42, 18); fmt.Font.Size20 = 200; xls.SetCellFormat(42, 18, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(42, 19); fmt.Font.Size20 = 200; xls.SetCellFormat(42, 19, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(42, 22); fmt.HAlignment = THFlxAlignment.center; fmt.VAlignment = TVFlxAlignment.center; xls.SetCellFormat(42, 22, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(43, 2); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; fmt.Borders.Left.Style = TFlxBorderStyle.Thin; fmt.Borders.Left.Color = TExcelColor.Automatic; fmt.Borders.Right.Style = TFlxBorderStyle.Thin; fmt.Borders.Right.Color = TExcelColor.Automatic; fmt.HAlignment = THFlxAlignment.center; fmt.VAlignment = TVFlxAlignment.center; xls.SetCellFormat(43, 2, xls.AddFormat(fmt)); xls.SetCellValue(43, 2, "BEY"); fmt = xls.GetCellVisibleFormatDef(43, 3); fmt.Font.Size20 = 200; fmt.Borders.Right.Style = TFlxBorderStyle.Thin; fmt.Borders.Right.Color = TExcelColor.Automatic; fmt.Format = "#,##0"; fmt.HAlignment = THFlxAlignment.right; fmt.VAlignment = TVFlxAlignment.center; xls.SetCellFormat(43, 3, xls.AddFormat(fmt)); xls.SetCellValue(43, 3, 65594); fmt = xls.GetCellVisibleFormatDef(43, 4); fmt.Font.Size20 = 200; xls.SetCellFormat(43, 4, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(43, 5); fmt.Font.Size20 = 200; fmt.Borders.Left.Style = TFlxBorderStyle.Thin; fmt.Borders.Left.Color = TExcelColor.Automatic; fmt.Borders.Right.Style = TFlxBorderStyle.Thin; fmt.Borders.Right.Color = TExcelColor.Automatic; fmt.VAlignment = TVFlxAlignment.center; xls.SetCellFormat(43, 5, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(43, 6); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; fmt.Borders.Left.Style = TFlxBorderStyle.Thin; fmt.Borders.Left.Color = TExcelColor.Automatic; fmt.Borders.Right.Style = TFlxBorderStyle.Thin; fmt.Borders.Right.Color = TExcelColor.Automatic; fmt.HAlignment = THFlxAlignment.center; fmt.VAlignment = TVFlxAlignment.center; xls.SetCellFormat(43, 6, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(43, 7); fmt.Font.Size20 = 200; fmt.Borders.Right.Style = TFlxBorderStyle.Thin; fmt.Borders.Right.Color = TExcelColor.Automatic; fmt.Format = "#,##0"; fmt.HAlignment = THFlxAlignment.right; fmt.VAlignment = TVFlxAlignment.center; xls.SetCellFormat(43, 7, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(43, 8); fmt.Font.Size20 = 200; xls.SetCellFormat(43, 8, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(43, 9); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; fmt.Borders.Left.Style = TFlxBorderStyle.Thin; fmt.Borders.Left.Color = TExcelColor.Automatic; fmt.HAlignment = THFlxAlignment.center; fmt.VAlignment = TVFlxAlignment.center; xls.SetCellFormat(43, 9, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(43, 10); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; fmt.Borders.Right.Style = TFlxBorderStyle.Thin; fmt.Borders.Right.Color = TExcelColor.Automatic; fmt.HAlignment = THFlxAlignment.center; fmt.VAlignment = TVFlxAlignment.center; xls.SetCellFormat(43, 10, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(43, 11); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; fmt.Borders.Left.Style = TFlxBorderStyle.Thin; fmt.Borders.Left.Color = TExcelColor.Automatic; fmt.HAlignment = THFlxAlignment.center; xls.SetCellFormat(43, 11, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(43, 12); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; fmt.Borders.Right.Style = TFlxBorderStyle.Thin; fmt.Borders.Right.Color = TExcelColor.Automatic; fmt.HAlignment = THFlxAlignment.center; xls.SetCellFormat(43, 12, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(43, 13); fmt.Font.Size20 = 200; xls.SetCellFormat(43, 13, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(43, 14); fmt.Font.Size20 = 200; xls.SetCellFormat(43, 14, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(43, 15); fmt.Font.Size20 = 200; xls.SetCellFormat(43, 15, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(43, 16); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; xls.SetCellFormat(43, 16, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(43, 17); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; xls.SetCellFormat(43, 17, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(43, 18); fmt.Font.Size20 = 200; xls.SetCellFormat(43, 18, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(43, 19); fmt.Font.Size20 = 200; xls.SetCellFormat(43, 19, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(43, 22); fmt.HAlignment = THFlxAlignment.center; fmt.VAlignment = TVFlxAlignment.center; xls.SetCellFormat(43, 22, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(44, 2); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; fmt.Borders.Left.Style = TFlxBorderStyle.Thin; fmt.Borders.Left.Color = TExcelColor.Automatic; fmt.Borders.Right.Style = TFlxBorderStyle.Thin; fmt.Borders.Right.Color = TExcelColor.Automatic; fmt.HAlignment = THFlxAlignment.center; fmt.VAlignment = TVFlxAlignment.center; xls.SetCellFormat(44, 2, xls.AddFormat(fmt)); xls.SetCellValue(44, 2, "EBL"); fmt = xls.GetCellVisibleFormatDef(44, 3); fmt.Font.Size20 = 200; fmt.Borders.Right.Style = TFlxBorderStyle.Thin; fmt.Borders.Right.Color = TExcelColor.Automatic; fmt.Format = "#,##0"; fmt.HAlignment = THFlxAlignment.right; fmt.VAlignment = TVFlxAlignment.center; xls.SetCellFormat(44, 3, xls.AddFormat(fmt)); xls.SetCellValue(44, 3, 64123); fmt = xls.GetCellVisibleFormatDef(44, 4); fmt.Font.Size20 = 200; xls.SetCellFormat(44, 4, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(44, 5); fmt.Font.Size20 = 200; fmt.Borders.Left.Style = TFlxBorderStyle.Thin; fmt.Borders.Left.Color = TExcelColor.Automatic; fmt.Borders.Right.Style = TFlxBorderStyle.Thin; fmt.Borders.Right.Color = TExcelColor.Automatic; fmt.VAlignment = TVFlxAlignment.center; xls.SetCellFormat(44, 5, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(44, 6); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; fmt.Borders.Left.Style = TFlxBorderStyle.Thin; fmt.Borders.Left.Color = TExcelColor.Automatic; fmt.Borders.Right.Style = TFlxBorderStyle.Thin; fmt.Borders.Right.Color = TExcelColor.Automatic; fmt.HAlignment = THFlxAlignment.center; fmt.VAlignment = TVFlxAlignment.center; xls.SetCellFormat(44, 6, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(44, 7); fmt.Font.Size20 = 200; fmt.Borders.Right.Style = TFlxBorderStyle.Thin; fmt.Borders.Right.Color = TExcelColor.Automatic; fmt.Format = "#,##0"; fmt.HAlignment = THFlxAlignment.right; fmt.VAlignment = TVFlxAlignment.center; xls.SetCellFormat(44, 7, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(44, 8); fmt.Font.Size20 = 200; xls.SetCellFormat(44, 8, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(44, 9); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; fmt.Borders.Left.Style = TFlxBorderStyle.Thin; fmt.Borders.Left.Color = TExcelColor.Automatic; fmt.HAlignment = THFlxAlignment.center; fmt.VAlignment = TVFlxAlignment.center; xls.SetCellFormat(44, 9, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(44, 10); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; fmt.Borders.Right.Style = TFlxBorderStyle.Thin; fmt.Borders.Right.Color = TExcelColor.Automatic; fmt.HAlignment = THFlxAlignment.center; fmt.VAlignment = TVFlxAlignment.center; xls.SetCellFormat(44, 10, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(44, 11); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; fmt.Borders.Left.Style = TFlxBorderStyle.Thin; fmt.Borders.Left.Color = TExcelColor.Automatic; fmt.HAlignment = THFlxAlignment.center; xls.SetCellFormat(44, 11, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(44, 12); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; fmt.Borders.Right.Style = TFlxBorderStyle.Thin; fmt.Borders.Right.Color = TExcelColor.Automatic; fmt.HAlignment = THFlxAlignment.center; xls.SetCellFormat(44, 12, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(44, 13); fmt.Font.Size20 = 200; xls.SetCellFormat(44, 13, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(44, 14); fmt.Font.Size20 = 200; xls.SetCellFormat(44, 14, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(44, 15); fmt.Font.Size20 = 200; xls.SetCellFormat(44, 15, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(44, 16); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; xls.SetCellFormat(44, 16, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(44, 17); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; xls.SetCellFormat(44, 17, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(44, 18); fmt.Font.Size20 = 200; xls.SetCellFormat(44, 18, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(44, 19); fmt.Font.Size20 = 200; xls.SetCellFormat(44, 19, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(44, 22); fmt.HAlignment = THFlxAlignment.center; fmt.VAlignment = TVFlxAlignment.center; xls.SetCellFormat(44, 22, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(45, 2); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; fmt.Borders.Left.Style = TFlxBorderStyle.Thin; fmt.Borders.Left.Color = TExcelColor.Automatic; fmt.Borders.Right.Style = TFlxBorderStyle.Thin; fmt.Borders.Right.Color = TExcelColor.Automatic; fmt.HAlignment = THFlxAlignment.center; fmt.VAlignment = TVFlxAlignment.center; xls.SetCellFormat(45, 2, xls.AddFormat(fmt)); xls.SetCellValue(45, 2, "BJV"); fmt = xls.GetCellVisibleFormatDef(45, 3); fmt.Font.Size20 = 200; fmt.Borders.Right.Style = TFlxBorderStyle.Thin; fmt.Borders.Right.Color = TExcelColor.Automatic; fmt.Format = "#,##0"; fmt.HAlignment = THFlxAlignment.right; fmt.VAlignment = TVFlxAlignment.center; xls.SetCellFormat(45, 3, xls.AddFormat(fmt)); xls.SetCellValue(45, 3, 63538); fmt = xls.GetCellVisibleFormatDef(45, 4); fmt.Font.Size20 = 200; xls.SetCellFormat(45, 4, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(45, 5); fmt.Font.Size20 = 200; fmt.Borders.Left.Style = TFlxBorderStyle.Thin; fmt.Borders.Left.Color = TExcelColor.Automatic; fmt.Borders.Right.Style = TFlxBorderStyle.Thin; fmt.Borders.Right.Color = TExcelColor.Automatic; fmt.VAlignment = TVFlxAlignment.center; xls.SetCellFormat(45, 5, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(45, 6); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; fmt.Borders.Left.Style = TFlxBorderStyle.Thin; fmt.Borders.Left.Color = TExcelColor.Automatic; fmt.Borders.Right.Style = TFlxBorderStyle.Thin; fmt.Borders.Right.Color = TExcelColor.Automatic; fmt.HAlignment = THFlxAlignment.center; fmt.VAlignment = TVFlxAlignment.center; xls.SetCellFormat(45, 6, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(45, 7); fmt.Font.Size20 = 200; fmt.Borders.Right.Style = TFlxBorderStyle.Thin; fmt.Borders.Right.Color = TExcelColor.Automatic; fmt.Format = "#,##0"; fmt.HAlignment = THFlxAlignment.right; fmt.VAlignment = TVFlxAlignment.center; xls.SetCellFormat(45, 7, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(45, 8); fmt.Font.Size20 = 200; xls.SetCellFormat(45, 8, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(45, 9); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; fmt.Borders.Left.Style = TFlxBorderStyle.Thin; fmt.Borders.Left.Color = TExcelColor.Automatic; fmt.HAlignment = THFlxAlignment.center; fmt.VAlignment = TVFlxAlignment.center; xls.SetCellFormat(45, 9, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(45, 10); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; fmt.Borders.Right.Style = TFlxBorderStyle.Thin; fmt.Borders.Right.Color = TExcelColor.Automatic; fmt.HAlignment = THFlxAlignment.center; fmt.VAlignment = TVFlxAlignment.center; xls.SetCellFormat(45, 10, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(45, 11); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; fmt.Borders.Left.Style = TFlxBorderStyle.Thin; fmt.Borders.Left.Color = TExcelColor.Automatic; fmt.HAlignment = THFlxAlignment.center; xls.SetCellFormat(45, 11, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(45, 12); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; fmt.Borders.Right.Style = TFlxBorderStyle.Thin; fmt.Borders.Right.Color = TExcelColor.Automatic; fmt.HAlignment = THFlxAlignment.center; xls.SetCellFormat(45, 12, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(45, 13); fmt.Font.Size20 = 200; xls.SetCellFormat(45, 13, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(45, 14); fmt.Font.Size20 = 200; xls.SetCellFormat(45, 14, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(45, 15); fmt.Font.Size20 = 200; xls.SetCellFormat(45, 15, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(45, 16); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; xls.SetCellFormat(45, 16, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(45, 17); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; xls.SetCellFormat(45, 17, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(45, 18); fmt.Font.Size20 = 200; xls.SetCellFormat(45, 18, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(45, 19); fmt.Font.Size20 = 200; xls.SetCellFormat(45, 19, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(45, 22); fmt.HAlignment = THFlxAlignment.center; fmt.VAlignment = TVFlxAlignment.center; xls.SetCellFormat(45, 22, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(46, 2); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; fmt.Borders.Left.Style = TFlxBorderStyle.Thin; fmt.Borders.Left.Color = TExcelColor.Automatic; fmt.Borders.Right.Style = TFlxBorderStyle.Thin; fmt.Borders.Right.Color = TExcelColor.Automatic; fmt.HAlignment = THFlxAlignment.center; fmt.VAlignment = TVFlxAlignment.center; xls.SetCellFormat(46, 2, xls.AddFormat(fmt)); xls.SetCellValue(46, 2, "SSH"); fmt = xls.GetCellVisibleFormatDef(46, 3); fmt.Font.Size20 = 200; fmt.Borders.Right.Style = TFlxBorderStyle.Thin; fmt.Borders.Right.Color = TExcelColor.Automatic; fmt.Format = "#,##0"; fmt.HAlignment = THFlxAlignment.right; fmt.VAlignment = TVFlxAlignment.center; xls.SetCellFormat(46, 3, xls.AddFormat(fmt)); xls.SetCellValue(46, 3, 61944); fmt = xls.GetCellVisibleFormatDef(46, 4); fmt.Font.Size20 = 200; xls.SetCellFormat(46, 4, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(46, 5); fmt.Font.Size20 = 200; fmt.Borders.Left.Style = TFlxBorderStyle.Thin; fmt.Borders.Left.Color = TExcelColor.Automatic; fmt.Borders.Right.Style = TFlxBorderStyle.Thin; fmt.Borders.Right.Color = TExcelColor.Automatic; fmt.VAlignment = TVFlxAlignment.center; xls.SetCellFormat(46, 5, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(46, 6); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; fmt.Borders.Left.Style = TFlxBorderStyle.Thin; fmt.Borders.Left.Color = TExcelColor.Automatic; fmt.Borders.Right.Style = TFlxBorderStyle.Thin; fmt.Borders.Right.Color = TExcelColor.Automatic; fmt.HAlignment = THFlxAlignment.center; fmt.VAlignment = TVFlxAlignment.center; xls.SetCellFormat(46, 6, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(46, 7); fmt.Font.Size20 = 200; fmt.Borders.Right.Style = TFlxBorderStyle.Thin; fmt.Borders.Right.Color = TExcelColor.Automatic; fmt.Format = "#,##0"; fmt.HAlignment = THFlxAlignment.right; fmt.VAlignment = TVFlxAlignment.center; xls.SetCellFormat(46, 7, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(46, 8); fmt.Font.Size20 = 200; xls.SetCellFormat(46, 8, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(46, 9); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; fmt.Borders.Left.Style = TFlxBorderStyle.Thin; fmt.Borders.Left.Color = TExcelColor.Automatic; fmt.HAlignment = THFlxAlignment.center; fmt.VAlignment = TVFlxAlignment.center; xls.SetCellFormat(46, 9, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(46, 10); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; fmt.Borders.Right.Style = TFlxBorderStyle.Thin; fmt.Borders.Right.Color = TExcelColor.Automatic; fmt.HAlignment = THFlxAlignment.center; fmt.VAlignment = TVFlxAlignment.center; xls.SetCellFormat(46, 10, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(46, 11); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; fmt.Borders.Left.Style = TFlxBorderStyle.Thin; fmt.Borders.Left.Color = TExcelColor.Automatic; fmt.HAlignment = THFlxAlignment.center; xls.SetCellFormat(46, 11, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(46, 12); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; fmt.Borders.Right.Style = TFlxBorderStyle.Thin; fmt.Borders.Right.Color = TExcelColor.Automatic; fmt.HAlignment = THFlxAlignment.center; xls.SetCellFormat(46, 12, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(46, 13); fmt.Font.Size20 = 200; xls.SetCellFormat(46, 13, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(46, 14); fmt.Font.Size20 = 200; xls.SetCellFormat(46, 14, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(46, 15); fmt.Font.Size20 = 200; xls.SetCellFormat(46, 15, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(46, 16); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; xls.SetCellFormat(46, 16, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(46, 17); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; xls.SetCellFormat(46, 17, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(46, 18); fmt.Font.Size20 = 200; xls.SetCellFormat(46, 18, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(46, 19); fmt.Font.Size20 = 200; xls.SetCellFormat(46, 19, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(46, 22); fmt.HAlignment = THFlxAlignment.center; fmt.VAlignment = TVFlxAlignment.center; xls.SetCellFormat(46, 22, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(47, 2); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; fmt.Borders.Left.Style = TFlxBorderStyle.Thin; fmt.Borders.Left.Color = TExcelColor.Automatic; fmt.Borders.Right.Style = TFlxBorderStyle.Thin; fmt.Borders.Right.Color = TExcelColor.Automatic; fmt.VAlignment = TVFlxAlignment.center; xls.SetCellFormat(47, 2, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(47, 3); fmt.Font.Size20 = 200; fmt.Borders.Right.Style = TFlxBorderStyle.Thin; fmt.Borders.Right.Color = TExcelColor.Automatic; fmt.Format = "#,##0"; fmt.HAlignment = THFlxAlignment.right; fmt.VAlignment = TVFlxAlignment.center; xls.SetCellFormat(47, 3, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(47, 4); fmt.Font.Size20 = 200; xls.SetCellFormat(47, 4, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(47, 5); fmt.Font.Size20 = 200; fmt.Borders.Left.Style = TFlxBorderStyle.Thin; fmt.Borders.Left.Color = TExcelColor.Automatic; fmt.Borders.Right.Style = TFlxBorderStyle.Thin; fmt.Borders.Right.Color = TExcelColor.Automatic; fmt.HAlignment = THFlxAlignment.center; fmt.VAlignment = TVFlxAlignment.center; xls.SetCellFormat(47, 5, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(47, 6); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; fmt.Borders.Left.Style = TFlxBorderStyle.Thin; fmt.Borders.Left.Color = TExcelColor.Automatic; fmt.Borders.Right.Style = TFlxBorderStyle.Thin; fmt.Borders.Right.Color = TExcelColor.Automatic; fmt.HAlignment = THFlxAlignment.center; fmt.VAlignment = TVFlxAlignment.center; xls.SetCellFormat(47, 6, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(47, 7); fmt.Font.Size20 = 200; fmt.Borders.Right.Style = TFlxBorderStyle.Thin; fmt.Borders.Right.Color = TExcelColor.Automatic; fmt.Format = "#,##0"; fmt.HAlignment = THFlxAlignment.right; fmt.VAlignment = TVFlxAlignment.center; xls.SetCellFormat(47, 7, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(47, 8); fmt.Font.Size20 = 200; xls.SetCellFormat(47, 8, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(47, 9); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; fmt.Borders.Left.Style = TFlxBorderStyle.Thin; fmt.Borders.Left.Color = TExcelColor.Automatic; fmt.HAlignment = THFlxAlignment.center; fmt.VAlignment = TVFlxAlignment.center; xls.SetCellFormat(47, 9, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(47, 10); fmt.Font.Size20 = 200; fmt.Borders.Right.Style = TFlxBorderStyle.Thin; fmt.Borders.Right.Color = TExcelColor.Automatic; fmt.HAlignment = THFlxAlignment.center; fmt.VAlignment = TVFlxAlignment.center; xls.SetCellFormat(47, 10, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(47, 11); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; fmt.Borders.Left.Style = TFlxBorderStyle.Thin; fmt.Borders.Left.Color = TExcelColor.Automatic; fmt.HAlignment = THFlxAlignment.center; xls.SetCellFormat(47, 11, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(47, 12); fmt.Font.Size20 = 200; fmt.Borders.Right.Style = TFlxBorderStyle.Thin; fmt.Borders.Right.Color = TExcelColor.Automatic; fmt.HAlignment = THFlxAlignment.center; xls.SetCellFormat(47, 12, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(47, 13); fmt.Font.Size20 = 200; xls.SetCellFormat(47, 13, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(47, 14); fmt.Font.Size20 = 200; xls.SetCellFormat(47, 14, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(47, 15); fmt.Font.Size20 = 200; xls.SetCellFormat(47, 15, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(47, 16); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; xls.SetCellFormat(47, 16, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(47, 17); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; xls.SetCellFormat(47, 17, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(47, 18); fmt.Font.Size20 = 200; xls.SetCellFormat(47, 18, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(47, 19); fmt.Font.Size20 = 200; xls.SetCellFormat(47, 19, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(47, 22); fmt.HAlignment = THFlxAlignment.center; fmt.VAlignment = TVFlxAlignment.center; xls.SetCellFormat(47, 22, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(48, 2); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; fmt.Borders.Left.Style = TFlxBorderStyle.Thin; fmt.Borders.Left.Color = TExcelColor.Automatic; fmt.Borders.Right.Style = TFlxBorderStyle.Thin; fmt.Borders.Right.Color = TExcelColor.Automatic; fmt.Borders.Bottom.Style = TFlxBorderStyle.Thin; fmt.Borders.Bottom.Color = TExcelColor.Automatic; fmt.HAlignment = THFlxAlignment.center; fmt.VAlignment = TVFlxAlignment.center; xls.SetCellFormat(48, 2, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(48, 3); fmt.Font.Size20 = 200; fmt.Borders.Right.Style = TFlxBorderStyle.Thin; fmt.Borders.Right.Color = TExcelColor.Automatic; fmt.Borders.Bottom.Style = TFlxBorderStyle.Thin; fmt.Borders.Bottom.Color = TExcelColor.Automatic; fmt.HAlignment = THFlxAlignment.right; fmt.VAlignment = TVFlxAlignment.center; xls.SetCellFormat(48, 3, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(48, 4); fmt.Font.Size20 = 200; xls.SetCellFormat(48, 4, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(48, 5); fmt.Font.Size20 = 200; fmt.Borders.Left.Style = TFlxBorderStyle.Thin; fmt.Borders.Left.Color = TExcelColor.Automatic; fmt.Borders.Right.Style = TFlxBorderStyle.Thin; fmt.Borders.Right.Color = TExcelColor.Automatic; fmt.Borders.Bottom.Style = TFlxBorderStyle.Thin; fmt.Borders.Bottom.Color = TExcelColor.Automatic; fmt.VAlignment = TVFlxAlignment.center; xls.SetCellFormat(48, 5, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(48, 6); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; fmt.Borders.Left.Style = TFlxBorderStyle.Thin; fmt.Borders.Left.Color = TExcelColor.Automatic; fmt.Borders.Right.Style = TFlxBorderStyle.Thin; fmt.Borders.Right.Color = TExcelColor.Automatic; fmt.Borders.Bottom.Style = TFlxBorderStyle.Thin; fmt.Borders.Bottom.Color = TExcelColor.Automatic; fmt.HAlignment = THFlxAlignment.center; fmt.VAlignment = TVFlxAlignment.center; xls.SetCellFormat(48, 6, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(48, 7); fmt.Font.Size20 = 200; fmt.Borders.Right.Style = TFlxBorderStyle.Thin; fmt.Borders.Right.Color = TExcelColor.Automatic; fmt.Borders.Bottom.Style = TFlxBorderStyle.Thin; fmt.Borders.Bottom.Color = TExcelColor.Automatic; fmt.HAlignment = THFlxAlignment.right; fmt.VAlignment = TVFlxAlignment.center; xls.SetCellFormat(48, 7, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(48, 8); fmt.Font.Size20 = 200; xls.SetCellFormat(48, 8, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(48, 9); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; fmt.Borders.Left.Style = TFlxBorderStyle.Thin; fmt.Borders.Left.Color = TExcelColor.Automatic; fmt.Borders.Bottom.Style = TFlxBorderStyle.Thin; fmt.Borders.Bottom.Color = TExcelColor.Automatic; fmt.HAlignment = THFlxAlignment.center; fmt.VAlignment = TVFlxAlignment.center; xls.SetCellFormat(48, 9, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(48, 10); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; fmt.Borders.Right.Style = TFlxBorderStyle.Thin; fmt.Borders.Right.Color = TExcelColor.Automatic; fmt.Borders.Bottom.Style = TFlxBorderStyle.Thin; fmt.Borders.Bottom.Color = TExcelColor.Automatic; fmt.HAlignment = THFlxAlignment.center; fmt.VAlignment = TVFlxAlignment.center; xls.SetCellFormat(48, 10, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(48, 11); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; fmt.Borders.Left.Style = TFlxBorderStyle.Thin; fmt.Borders.Left.Color = TExcelColor.Automatic; fmt.Borders.Bottom.Style = TFlxBorderStyle.Thin; fmt.Borders.Bottom.Color = TExcelColor.Automatic; fmt.HAlignment = THFlxAlignment.center; xls.SetCellFormat(48, 11, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(48, 12); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; fmt.Borders.Right.Style = TFlxBorderStyle.Thin; fmt.Borders.Right.Color = TExcelColor.Automatic; fmt.Borders.Bottom.Style = TFlxBorderStyle.Thin; fmt.Borders.Bottom.Color = TExcelColor.Automatic; fmt.HAlignment = THFlxAlignment.center; xls.SetCellFormat(48, 12, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(48, 13); fmt.Font.Size20 = 200; xls.SetCellFormat(48, 13, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(48, 14); fmt.Font.Size20 = 200; xls.SetCellFormat(48, 14, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(48, 15); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; xls.SetCellFormat(48, 15, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(48, 16); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; xls.SetCellFormat(48, 16, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(48, 17); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; xls.SetCellFormat(48, 17, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(48, 18); fmt.Font.Size20 = 200; xls.SetCellFormat(48, 18, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(48, 19); fmt.Font.Size20 = 200; xls.SetCellFormat(48, 19, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(48, 22); fmt.HAlignment = THFlxAlignment.center; fmt.VAlignment = TVFlxAlignment.center; xls.SetCellFormat(48, 22, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(49, 2); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; xls.SetCellFormat(49, 2, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(49, 3); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.FromTheme(TThemeColor.Light1); fmt.HAlignment = THFlxAlignment.center; fmt.VAlignment = TVFlxAlignment.center; xls.SetCellFormat(49, 3, xls.AddFormat(fmt)); xls.SetCellValue(49, 3, new TFormula("=SUM(C27:C48)")); fmt = xls.GetCellVisibleFormatDef(49, 4); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; fmt.HAlignment = THFlxAlignment.center; fmt.VAlignment = TVFlxAlignment.center; xls.SetCellFormat(49, 4, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(49, 5); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; fmt.HAlignment = THFlxAlignment.center; fmt.VAlignment = TVFlxAlignment.center; xls.SetCellFormat(49, 5, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(49, 6); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; xls.SetCellFormat(49, 6, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(49, 7); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; xls.SetCellFormat(49, 7, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(49, 8); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; xls.SetCellFormat(49, 8, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(49, 9); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; xls.SetCellFormat(49, 9, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(49, 10); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; xls.SetCellFormat(49, 10, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(49, 11); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; xls.SetCellFormat(49, 11, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(49, 12); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; xls.SetCellFormat(49, 12, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(49, 13); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; fmt.HAlignment = THFlxAlignment.center; fmt.VAlignment = TVFlxAlignment.center; xls.SetCellFormat(49, 13, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(49, 14); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; xls.SetCellFormat(49, 14, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(49, 15); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; xls.SetCellFormat(49, 15, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(49, 16); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; xls.SetCellFormat(49, 16, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(49, 17); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; xls.SetCellFormat(49, 17, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(49, 18); fmt.Font.Size20 = 200; xls.SetCellFormat(49, 18, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(49, 19); fmt.Font.Size20 = 200; xls.SetCellFormat(49, 19, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(49, 22); fmt.HAlignment = THFlxAlignment.center; fmt.VAlignment = TVFlxAlignment.center; xls.SetCellFormat(49, 22, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(50, 2); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; xls.SetCellFormat(50, 2, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(50, 3); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; xls.SetCellFormat(50, 3, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(50, 4); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; xls.SetCellFormat(50, 4, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(50, 5); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; xls.SetCellFormat(50, 5, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(50, 6); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; xls.SetCellFormat(50, 6, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(50, 7); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; xls.SetCellFormat(50, 7, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(50, 8); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; xls.SetCellFormat(50, 8, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(50, 9); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; xls.SetCellFormat(50, 9, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(50, 10); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; xls.SetCellFormat(50, 10, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(50, 11); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; xls.SetCellFormat(50, 11, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(50, 12); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; xls.SetCellFormat(50, 12, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(50, 13); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; xls.SetCellFormat(50, 13, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(50, 14); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; xls.SetCellFormat(50, 14, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(50, 15); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; xls.SetCellFormat(50, 15, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(50, 16); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; xls.SetCellFormat(50, 16, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(50, 17); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; xls.SetCellFormat(50, 17, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(50, 18); fmt.Font.Size20 = 200; xls.SetCellFormat(50, 18, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(50, 19); fmt.Font.Size20 = 200; xls.SetCellFormat(50, 19, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(51, 2); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; xls.SetCellFormat(51, 2, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(51, 3); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; xls.SetCellFormat(51, 3, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(51, 4); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; xls.SetCellFormat(51, 4, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(51, 5); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; xls.SetCellFormat(51, 5, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(51, 6); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; xls.SetCellFormat(51, 6, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(51, 7); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; xls.SetCellFormat(51, 7, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(51, 8); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; xls.SetCellFormat(51, 8, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(51, 9); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; xls.SetCellFormat(51, 9, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(51, 10); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; xls.SetCellFormat(51, 10, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(51, 11); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; xls.SetCellFormat(51, 11, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(51, 12); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; xls.SetCellFormat(51, 12, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(51, 13); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; xls.SetCellFormat(51, 13, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(51, 14); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; xls.SetCellFormat(51, 14, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(51, 15); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; xls.SetCellFormat(51, 15, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(51, 16); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; xls.SetCellFormat(51, 16, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(51, 17); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; xls.SetCellFormat(51, 17, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(51, 18); fmt.Font.Size20 = 200; xls.SetCellFormat(51, 18, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(51, 19); fmt.Font.Size20 = 200; xls.SetCellFormat(51, 19, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(52, 2); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; xls.SetCellFormat(52, 2, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(52, 3); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; xls.SetCellFormat(52, 3, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(52, 4); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; xls.SetCellFormat(52, 4, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(52, 5); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; xls.SetCellFormat(52, 5, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(52, 6); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; xls.SetCellFormat(52, 6, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(52, 7); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; xls.SetCellFormat(52, 7, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(52, 8); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; xls.SetCellFormat(52, 8, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(52, 9); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; xls.SetCellFormat(52, 9, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(52, 10); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; xls.SetCellFormat(52, 10, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(52, 11); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; xls.SetCellFormat(52, 11, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(52, 12); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; xls.SetCellFormat(52, 12, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(52, 13); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; xls.SetCellFormat(52, 13, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(52, 14); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; xls.SetCellFormat(52, 14, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(52, 15); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; xls.SetCellFormat(52, 15, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(52, 16); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; xls.SetCellFormat(52, 16, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(52, 17); fmt.Font.Size20 = 200; fmt.Font.Color = TExcelColor.Automatic; xls.SetCellFormat(52, 17, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(52, 18); fmt.Font.Size20 = 200; xls.SetCellFormat(52, 18, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(52, 19); fmt.Font.Size20 = 200; xls.SetCellFormat(52, 19, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(53, 2); fmt.Font.Color = TExcelColor.Automatic; xls.SetCellFormat(53, 2, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(53, 3); fmt.Font.Color = TExcelColor.Automatic; xls.SetCellFormat(53, 3, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(53, 4); fmt.Font.Color = TExcelColor.Automatic; xls.SetCellFormat(53, 4, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(53, 5); fmt.Font.Color = TExcelColor.Automatic; xls.SetCellFormat(53, 5, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(53, 6); fmt.Font.Color = TExcelColor.Automatic; xls.SetCellFormat(53, 6, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(53, 7); fmt.Font.Color = TExcelColor.Automatic; xls.SetCellFormat(53, 7, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(53, 8); fmt.Font.Color = TExcelColor.Automatic; xls.SetCellFormat(53, 8, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(53, 9); fmt.Font.Color = TExcelColor.Automatic; xls.SetCellFormat(53, 9, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(53, 10); fmt.Font.Color = TExcelColor.Automatic; xls.SetCellFormat(53, 10, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(53, 11); fmt.Font.Color = TExcelColor.Automatic; xls.SetCellFormat(53, 11, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(53, 12); fmt.Font.Color = TExcelColor.Automatic; xls.SetCellFormat(53, 12, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(53, 13); fmt.Font.Color = TExcelColor.Automatic; xls.SetCellFormat(53, 13, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(53, 14); fmt.Font.Color = TExcelColor.Automatic; xls.SetCellFormat(53, 14, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(53, 15); fmt.Font.Color = TExcelColor.Automatic; xls.SetCellFormat(53, 15, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(53, 16); fmt.Font.Color = TExcelColor.Automatic; xls.SetCellFormat(53, 16, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(53, 17); fmt.Font.Color = TExcelColor.Automatic; xls.SetCellFormat(53, 17, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(54, 2); fmt.Font.Color = TExcelColor.Automatic; xls.SetCellFormat(54, 2, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(54, 3); fmt.Font.Color = TExcelColor.Automatic; xls.SetCellFormat(54, 3, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(54, 4); fmt.Font.Color = TExcelColor.Automatic; xls.SetCellFormat(54, 4, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(54, 5); fmt.Font.Color = TExcelColor.Automatic; xls.SetCellFormat(54, 5, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(54, 6); fmt.Font.Color = TExcelColor.Automatic; xls.SetCellFormat(54, 6, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(54, 7); fmt.Font.Color = TExcelColor.Automatic; xls.SetCellFormat(54, 7, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(54, 8); fmt.Font.Color = TExcelColor.Automatic; xls.SetCellFormat(54, 8, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(54, 9); fmt.Font.Color = TExcelColor.Automatic; xls.SetCellFormat(54, 9, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(54, 10); fmt.Font.Color = TExcelColor.Automatic; xls.SetCellFormat(54, 10, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(54, 11); fmt.Font.Color = TExcelColor.Automatic; xls.SetCellFormat(54, 11, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(54, 12); fmt.Font.Color = TExcelColor.Automatic; xls.SetCellFormat(54, 12, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(54, 13); fmt.Font.Color = TExcelColor.Automatic; xls.SetCellFormat(54, 13, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(54, 14); fmt.Font.Color = TExcelColor.Automatic; xls.SetCellFormat(54, 14, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(54, 15); fmt.Font.Color = TExcelColor.Automatic; xls.SetCellFormat(54, 15, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(54, 16); fmt.Font.Color = TExcelColor.Automatic; xls.SetCellFormat(54, 16, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(54, 17); fmt.Font.Color = TExcelColor.Automatic; xls.SetCellFormat(54, 17, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(55, 2); fmt.Font.Color = TExcelColor.Automatic; xls.SetCellFormat(55, 2, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(55, 3); fmt.Font.Color = TExcelColor.Automatic; xls.SetCellFormat(55, 3, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(55, 4); fmt.Font.Color = TExcelColor.Automatic; xls.SetCellFormat(55, 4, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(55, 5); fmt.Font.Color = TExcelColor.Automatic; xls.SetCellFormat(55, 5, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(55, 6); fmt.Font.Color = TExcelColor.Automatic; xls.SetCellFormat(55, 6, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(55, 7); fmt.Font.Color = TExcelColor.Automatic; xls.SetCellFormat(55, 7, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(55, 8); fmt.Font.Color = TExcelColor.Automatic; xls.SetCellFormat(55, 8, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(55, 9); fmt.Font.Color = TExcelColor.Automatic; xls.SetCellFormat(55, 9, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(55, 10); fmt.Font.Color = TExcelColor.Automatic; xls.SetCellFormat(55, 10, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(55, 11); fmt.Font.Color = TExcelColor.Automatic; xls.SetCellFormat(55, 11, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(55, 12); fmt.Font.Color = TExcelColor.Automatic; xls.SetCellFormat(55, 12, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(55, 13); fmt.Font.Color = TExcelColor.Automatic; xls.SetCellFormat(55, 13, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(55, 14); fmt.Font.Color = TExcelColor.Automatic; xls.SetCellFormat(55, 14, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(55, 15); fmt.Font.Color = TExcelColor.Automatic; xls.SetCellFormat(55, 15, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(55, 16); fmt.Font.Color = TExcelColor.Automatic; xls.SetCellFormat(55, 16, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(55, 17); fmt.Font.Color = TExcelColor.Automatic; xls.SetCellFormat(55, 17, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(56, 2); fmt.Font.Color = TExcelColor.Automatic; xls.SetCellFormat(56, 2, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(56, 3); fmt.Font.Color = TExcelColor.Automatic; xls.SetCellFormat(56, 3, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(56, 4); fmt.Font.Color = TExcelColor.Automatic; xls.SetCellFormat(56, 4, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(56, 5); fmt.Font.Color = TExcelColor.Automatic; xls.SetCellFormat(56, 5, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(56, 6); fmt.Font.Color = TExcelColor.Automatic; xls.SetCellFormat(56, 6, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(56, 7); fmt.Font.Color = TExcelColor.Automatic; xls.SetCellFormat(56, 7, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(56, 8); fmt.Font.Color = TExcelColor.Automatic; xls.SetCellFormat(56, 8, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(56, 9); fmt.Font.Color = TExcelColor.Automatic; xls.SetCellFormat(56, 9, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(56, 10); fmt.Font.Color = TExcelColor.Automatic; xls.SetCellFormat(56, 10, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(56, 11); fmt.Font.Color = TExcelColor.Automatic; xls.SetCellFormat(56, 11, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(56, 12); fmt.Font.Color = TExcelColor.Automatic; xls.SetCellFormat(56, 12, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(56, 13); fmt.Font.Color = TExcelColor.Automatic; xls.SetCellFormat(56, 13, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(56, 14); fmt.Font.Color = TExcelColor.Automatic; xls.SetCellFormat(56, 14, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(56, 15); fmt.Font.Color = TExcelColor.Automatic; xls.SetCellFormat(56, 15, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(56, 16); fmt.Font.Color = TExcelColor.Automatic; xls.SetCellFormat(56, 16, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(56, 17); fmt.Font.Color = TExcelColor.Automatic; xls.SetCellFormat(56, 17, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(57, 2); fmt.Font.Color = TExcelColor.Automatic; xls.SetCellFormat(57, 2, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(57, 3); fmt.Font.Color = TExcelColor.Automatic; xls.SetCellFormat(57, 3, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(57, 4); fmt.Font.Color = TExcelColor.Automatic; xls.SetCellFormat(57, 4, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(57, 5); fmt.Font.Color = TExcelColor.Automatic; xls.SetCellFormat(57, 5, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(57, 6); fmt.Font.Color = TExcelColor.Automatic; xls.SetCellFormat(57, 6, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(57, 7); fmt.Font.Color = TExcelColor.Automatic; xls.SetCellFormat(57, 7, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(57, 8); fmt.Font.Color = TExcelColor.Automatic; xls.SetCellFormat(57, 8, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(57, 9); fmt.Font.Color = TExcelColor.Automatic; xls.SetCellFormat(57, 9, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(57, 10); fmt.Font.Color = TExcelColor.Automatic; xls.SetCellFormat(57, 10, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(57, 11); fmt.Font.Color = TExcelColor.Automatic; xls.SetCellFormat(57, 11, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(57, 12); fmt.Font.Color = TExcelColor.Automatic; xls.SetCellFormat(57, 12, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(57, 13); fmt.Font.Color = TExcelColor.Automatic; xls.SetCellFormat(57, 13, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(57, 14); fmt.Font.Color = TExcelColor.Automatic; xls.SetCellFormat(57, 14, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(57, 15); fmt.Font.Color = TExcelColor.Automatic; xls.SetCellFormat(57, 15, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(57, 16); fmt.Font.Color = TExcelColor.Automatic; xls.SetCellFormat(57, 16, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(57, 17); fmt.Font.Color = TExcelColor.Automatic; xls.SetCellFormat(57, 17, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(58, 2); fmt.Font.Color = TExcelColor.Automatic; xls.SetCellFormat(58, 2, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(58, 3); fmt.Font.Color = TExcelColor.Automatic; xls.SetCellFormat(58, 3, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(58, 4); fmt.Font.Color = TExcelColor.Automatic; xls.SetCellFormat(58, 4, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(58, 5); fmt.Font.Color = TExcelColor.Automatic; xls.SetCellFormat(58, 5, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(58, 6); fmt.Font.Color = TExcelColor.Automatic; xls.SetCellFormat(58, 6, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(58, 7); fmt.Font.Color = TExcelColor.Automatic; xls.SetCellFormat(58, 7, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(58, 8); fmt.Font.Color = TExcelColor.Automatic; xls.SetCellFormat(58, 8, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(58, 9); fmt.Font.Color = TExcelColor.Automatic; xls.SetCellFormat(58, 9, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(58, 10); fmt.Font.Color = TExcelColor.Automatic; xls.SetCellFormat(58, 10, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(58, 11); fmt.Font.Color = TExcelColor.Automatic; xls.SetCellFormat(58, 11, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(58, 12); fmt.Font.Color = TExcelColor.Automatic; xls.SetCellFormat(58, 12, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(58, 13); fmt.Font.Color = TExcelColor.Automatic; xls.SetCellFormat(58, 13, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(58, 14); fmt.Font.Color = TExcelColor.Automatic; xls.SetCellFormat(58, 14, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(58, 15); fmt.Font.Color = TExcelColor.Automatic; xls.SetCellFormat(58, 15, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(58, 16); fmt.Font.Color = TExcelColor.Automatic; xls.SetCellFormat(58, 16, xls.AddFormat(fmt)); fmt = xls.GetCellVisibleFormatDef(58, 17); fmt.Font.Color = TExcelColor.Automatic; xls.SetCellFormat(58, 17, xls.AddFormat(fmt)); //Images using (FileStream fs = new FileStream("imagename.png", FileMode.Open, FileAccess.Read, FileShare.ReadWrite)) { TImageProperties ImgProps = new TImageProperties(); ImgProps.Anchor = new TClientAnchor(TFlxAnchorType.MoveAndDontResize, 1, 0, 16, 588, 5, 154, 17, 1010); ImgProps.ShapeName = "Picture 4"; xls.AddImage(fs, ImgProps); } //Objects TShapeProperties ChartOptions1 = new TShapeProperties(); ChartOptions1.Anchor = new TClientAnchor(TFlxAnchorType.MoveAndResize, 1, 26, 1, 108, 24, 207, 17, 1024); ChartOptions1.ShapeName = "Chart 1"; ChartOptions1.Visible = true; ChartOptions1.ShapeOptions.SetValue(TShapeOption.fLockText, true); ChartOptions1.ShapeOptions.SetValue(TShapeOption.LockRotation, true); ChartOptions1.ShapeOptions.SetValue(TShapeOption.fAutoTextMargin, true); ChartOptions1.ShapeOptions.SetValue(TShapeOption.fillColor, 134217806); ChartOptions1.ShapeOptions.SetValue(TShapeOption.fFilled, true); ChartOptions1.ShapeOptions.SetValue(TShapeOption.wzName, "Chart 1"); ExcelChart Chart1 = xls.AddChart(ChartOptions1, TChartType.Bar, new ChartStyle(0), false); TDataLabel Title = new TDataLabel(); Title.PositionZeroBased = null; ChartFillOptions TextFillOptions = new ChartFillOptions(new TShapeFill(new TSolidFill(TDrawingColor.FromRgb(0x00, 0x00, 0x00)), true, TFormattingType.Subtle, null, false)); TChartTextOptions LabelTextOptions = new TChartTextOptions(null, THFlxAlignment.center, TVFlxAlignment.center, TBackgroundMode.Transparent, TextFillOptions); Title.TextOptions = LabelTextOptions; TDataLabelOptions LabelOptions = new TDataLabelOptions(); LabelOptions.DataType = TLabelDataValue.SeriesInfo; LabelOptions.Deleted = true; Title.LabelOptions = LabelOptions; Chart1.SetTitle(Title); Chart1.Background = new TChartFrameOptions(null, null, TDrawingColor.FromTheme(TThemeColor.Background1), false); Chart1.DefaultFont = new TFlxChartFont("Calibri", 200, TExcelColor.FromArgb(0x00, 0x00, 0x00), TFlxFontStyles.None, TFlxUnderline.None, TFontScheme.None); TChartFrameOptions PlotAreaFrame; PlotAreaFrame = new TChartFrameOptions(null, null, null, false); TChartPlotAreaPosition PlotAreaPos = new TChartPlotAreaPosition(false, new TChartRelativeRectangle(TChartLayoutMode.Edge, TChartLayoutMode.Edge, TChartLayoutMode.Factor, TChartLayoutMode.Factor, 0.0580071126360123, 0.201474389204072, 0.908351596809273, 0.729654791336201), TChartLayoutTarget.Inner, true); Chart1.PlotArea = new TChartPlotArea(PlotAreaFrame, PlotAreaPos, false); Chart1.SetChartOptions(1, new TBarChartOptions(false, 0, 1.5, false, TStackedMode.Clustered, null)); Chart1.PlotEmptyCells = TPlotEmptyCells.NotPlotted; Chart1.ShowDataInHiddenRowsAndCols = false; TFlxChartFont AxisFont = new TFlxChartFont("Calibri", 200, TExcelColor.FromArgb(0x00, 0x00, 0x00), TFlxFontStyles.None, TFlxUnderline.None, TFontScheme.None); TAxisLineOptions AxisLine = new TAxisLineOptions(); AxisLine.MainAxis = new ChartLineOptions(new TShapeLine(true, null, null, TFormattingType.Subtle)); AxisLine.DoNotDrawLabelsIfNotDrawingAxis = false; TAxisTickOptions AxisTicks = new TAxisTickOptions(TTickType.Outside, TTickType.None, TAxisLabelPosition.NextToAxis, TBackgroundMode.Transparent, null, TDrawingColor.FromRgb(0x00, 0x00, 0x00), 0); TAxisRangeOptions AxisRangeOptions = new TAxisRangeOptions(1, 1, true, false, false, true); TBaseAxis CatAxis = new TCategoryAxis(0, 0, 1, TDateUnits.Days, 1, TDateUnits.Days, TDateUnits.Days, 1, TCategoryAxisOptions.AutoMin | TCategoryAxisOptions.AutoMax | TCategoryAxisOptions.AutoMajor | TCategoryAxisOptions.AutoMinor | TCategoryAxisOptions.AutoBase | TCategoryAxisOptions.AutoCrossDate | TCategoryAxisOptions.AutoDate, AxisFont, null, true, AxisLine, AxisTicks, AxisRangeOptions, null, TChartAxisPos.Bottom, 100, 10); AxisFont = new TFlxChartFont("Calibri", 200, TExcelColor.FromArgb(0x00, 0x00, 0x00), TFlxFontStyles.None, TFlxUnderline.None, TFontScheme.None); AxisLine = new TAxisLineOptions(); AxisLine.MainAxis = new ChartLineOptions(new TShapeLine(true, null, null, TFormattingType.Subtle)); AxisLine.DoNotDrawLabelsIfNotDrawingAxis = false; AxisTicks = new TAxisTickOptions(TTickType.Outside, TTickType.None, TAxisLabelPosition.NextToAxis, TBackgroundMode.Transparent, null, TDrawingColor.FromRgb(0x00, 0x00, 0x00), 0); TBaseAxis ValAxis = new TValueAxis(0, 0, 0, 0, 0, TValueAxisOptions.AutoMin | TValueAxisOptions.AutoMax | TValueAxisOptions.AutoMajor | TValueAxisOptions.AutoMinor | TValueAxisOptions.AutoCross, AxisFont, null, true, AxisLine, AxisTicks, null, TChartAxisPos.Left, 10); Chart1.SetChartAxis(new TChartAxis(0, CatAxis, ValAxis)); TDataLabel[] DataLabels = new TDataLabel[10]; DataLabels[0] = new TDataLabel(); DataLabels[0].PositionZeroBased = new TChartRelativeRectangle(TChartLayoutMode.Factor, TChartLayoutMode.Factor, TChartLayoutMode.Auto, TChartLayoutMode.Auto, 0.00956947713544862, -0.00721617423064408, 0, 0); TextFillOptions = new ChartFillOptions(new TShapeFill(new TSolidFill(TDrawingColor.FromRgb(0x00, 0x00, 0x00)), true, TFormattingType.Subtle, null, false)); LabelTextOptions = new TChartTextOptions(new TFlxChartFont("Calibri", 700, TExcelColor.FromArgb(0x00, 0x00, 0x00), TFlxFontStyles.Bold, TFlxUnderline.None, TFontScheme.None), THFlxAlignment.center, TVFlxAlignment.center, TBackgroundMode.Transparent, TextFillOptions); DataLabels[0].TextOptions = LabelTextOptions; LabelOptions = new TDataLabelOptions(); LabelOptions.ShowValues = true; LabelOptions.DataType = TLabelDataValue.SeriesInfo; LabelOptions.Position = TDataLabelPosition.Any; DataLabels[0].LabelOptions = LabelOptions; DataLabels[0].Frame = new TChartFrameOptions(null, null, null, false); DataLabels[0].LinkedTo = TLinkOption.DataLabel; DataLabels[0].SeriesIndex = 0; DataLabels[0].DataPointIndex = 0; DataLabels[0].NumberFormat = "#,##0"; DataLabels[0].NumberFormatLinkedToSource = false; DataLabels[1] = new TDataLabel(); DataLabels[1].PositionZeroBased = new TChartRelativeRectangle(TChartLayoutMode.Factor, TChartLayoutMode.Factor, TChartLayoutMode.Auto, TChartLayoutMode.Auto, 0.0095694771354486, -0.0120269570510736, 0, 0); TextFillOptions = new ChartFillOptions(new TShapeFill(new TSolidFill(TDrawingColor.FromRgb(0x00, 0x00, 0x00)), true, TFormattingType.Subtle, null, false)); LabelTextOptions = new TChartTextOptions(new TFlxChartFont("Calibri", 320, TExcelColor.FromArgb(0x00, 0x00, 0x00), TFlxFontStyles.Bold, TFlxUnderline.None, TFontScheme.None), THFlxAlignment.center, TVFlxAlignment.center, TBackgroundMode.Transparent, TextFillOptions); DataLabels[1].TextOptions = LabelTextOptions; LabelOptions = new TDataLabelOptions(); LabelOptions.ShowValues = true; LabelOptions.DataType = TLabelDataValue.SeriesInfo; LabelOptions.Position = TDataLabelPosition.Any; DataLabels[1].LabelOptions = LabelOptions; DataLabels[1].Frame = new TChartFrameOptions(null, null, null, false); DataLabels[1].LinkedTo = TLinkOption.DataLabel; DataLabels[1].SeriesIndex = 0; DataLabels[1].DataPointIndex = 1; DataLabels[1].NumberFormat = "#,##0"; DataLabels[1].NumberFormatLinkedToSource = false; DataLabels[2] = new TDataLabel(); DataLabels[2].PositionZeroBased = new TChartRelativeRectangle(TChartLayoutMode.Factor, TChartLayoutMode.Factor, TChartLayoutMode.Auto, TChartLayoutMode.Auto, 0.00598092320965538, -0.00962156564085877, 0, 0); TextFillOptions = new ChartFillOptions(new TShapeFill(new TSolidFill(TDrawingColor.FromRgb(0x00, 0x00, 0x00)), true, TFormattingType.Subtle, null, false)); LabelTextOptions = new TChartTextOptions(new TFlxChartFont("Calibri", 320, TExcelColor.FromArgb(0x00, 0x00, 0x00), TFlxFontStyles.Bold, TFlxUnderline.None, TFontScheme.None), THFlxAlignment.center, TVFlxAlignment.center, TBackgroundMode.Transparent, TextFillOptions); DataLabels[2].TextOptions = LabelTextOptions; LabelOptions = new TDataLabelOptions(); LabelOptions.ShowValues = true; LabelOptions.DataType = TLabelDataValue.SeriesInfo; LabelOptions.Position = TDataLabelPosition.Any; DataLabels[2].LabelOptions = LabelOptions; DataLabels[2].Frame = new TChartFrameOptions(null, null, null, false); DataLabels[2].LinkedTo = TLinkOption.DataLabel; DataLabels[2].SeriesIndex = 0; DataLabels[2].DataPointIndex = 2; DataLabels[2].NumberFormat = "#,##0"; DataLabels[2].NumberFormatLinkedToSource = false; DataLabels[3] = new TDataLabel(); DataLabels[3].PositionZeroBased = new TChartRelativeRectangle(TChartLayoutMode.Factor, TChartLayoutMode.Factor, TChartLayoutMode.Auto, TChartLayoutMode.Auto, 0.00358855392579323, -0.00481078282042947, 0, 0); TextFillOptions = new ChartFillOptions(new TShapeFill(new TSolidFill(TDrawingColor.FromRgb(0x00, 0x00, 0x00)), true, TFormattingType.Subtle, null, false)); LabelTextOptions = new TChartTextOptions(new TFlxChartFont("Calibri", 320, TExcelColor.FromArgb(0x00, 0x00, 0x00), TFlxFontStyles.Bold, TFlxUnderline.None, TFontScheme.None), THFlxAlignment.center, TVFlxAlignment.center, TBackgroundMode.Transparent, TextFillOptions); DataLabels[3].TextOptions = LabelTextOptions; LabelOptions = new TDataLabelOptions(); LabelOptions.ShowValues = true; LabelOptions.DataType = TLabelDataValue.SeriesInfo; LabelOptions.Position = TDataLabelPosition.Any; DataLabels[3].LabelOptions = LabelOptions; DataLabels[3].Frame = new TChartFrameOptions(null, null, null, false); DataLabels[3].LinkedTo = TLinkOption.DataLabel; DataLabels[3].SeriesIndex = 0; DataLabels[3].DataPointIndex = 3; DataLabels[3].NumberFormat = "#,##0"; DataLabels[3].NumberFormatLinkedToSource = false; DataLabels[4] = new TDataLabel(); DataLabels[4].PositionZeroBased = new TChartRelativeRectangle(TChartLayoutMode.Factor, TChartLayoutMode.Factor, TChartLayoutMode.Auto, TChartLayoutMode.Auto, 0, -0.0048107828204293, 0, 0); TextFillOptions = new ChartFillOptions(new TShapeFill(new TSolidFill(TDrawingColor.FromRgb(0x00, 0x00, 0x00)), true, TFormattingType.Subtle, null, false)); LabelTextOptions = new TChartTextOptions(new TFlxChartFont("Calibri", 320, TExcelColor.FromArgb(0x00, 0x00, 0x00), TFlxFontStyles.Bold, TFlxUnderline.None, TFontScheme.None), THFlxAlignment.center, TVFlxAlignment.center, TBackgroundMode.Transparent, TextFillOptions); DataLabels[4].TextOptions = LabelTextOptions; LabelOptions = new TDataLabelOptions(); LabelOptions.ShowValues = true; LabelOptions.DataType = TLabelDataValue.SeriesInfo; LabelOptions.Position = TDataLabelPosition.Any; DataLabels[4].LabelOptions = LabelOptions; DataLabels[4].Frame = new TChartFrameOptions(null, null, null, false); DataLabels[4].LinkedTo = TLinkOption.DataLabel; DataLabels[4].SeriesIndex = 0; DataLabels[4].DataPointIndex = 4; DataLabels[4].NumberFormat = "#,##0"; DataLabels[4].NumberFormatLinkedToSource = false; DataLabels[5] = new TDataLabel(); DataLabels[5].PositionZeroBased = new TChartRelativeRectangle(TChartLayoutMode.Factor, TChartLayoutMode.Factor, TChartLayoutMode.Auto, TChartLayoutMode.Auto, 0.00119618464193108, -0.0120269570510734, 0, 0); TextFillOptions = new ChartFillOptions(new TShapeFill(new TSolidFill(TDrawingColor.FromRgb(0x00, 0x00, 0x00)), true, TFormattingType.Subtle, null, false)); LabelTextOptions = new TChartTextOptions(new TFlxChartFont("Calibri", 320, TExcelColor.FromArgb(0x00, 0x00, 0x00), TFlxFontStyles.Bold, TFlxUnderline.None, TFontScheme.None), THFlxAlignment.center, TVFlxAlignment.center, TBackgroundMode.Transparent, TextFillOptions); DataLabels[5].TextOptions = LabelTextOptions; LabelOptions = new TDataLabelOptions(); LabelOptions.ShowValues = true; LabelOptions.DataType = TLabelDataValue.SeriesInfo; LabelOptions.Position = TDataLabelPosition.Any; DataLabels[5].LabelOptions = LabelOptions; DataLabels[5].Frame = new TChartFrameOptions(null, null, null, false); DataLabels[5].LinkedTo = TLinkOption.DataLabel; DataLabels[5].SeriesIndex = 0; DataLabels[5].DataPointIndex = 5; DataLabels[5].NumberFormat = "#,##0"; DataLabels[5].NumberFormatLinkedToSource = false; DataLabels[6] = new TDataLabel(); DataLabels[6].PositionZeroBased = new TChartRelativeRectangle(TChartLayoutMode.Factor, TChartLayoutMode.Factor, TChartLayoutMode.Auto, TChartLayoutMode.Auto, 0.00119618464193108, -0.0120269570510735, 0, 0); TextFillOptions = new ChartFillOptions(new TShapeFill(new TSolidFill(TDrawingColor.FromRgb(0x00, 0x00, 0x00)), true, TFormattingType.Subtle, null, false)); LabelTextOptions = new TChartTextOptions(new TFlxChartFont("Calibri", 320, TExcelColor.FromArgb(0x00, 0x00, 0x00), TFlxFontStyles.Bold, TFlxUnderline.None, TFontScheme.None), THFlxAlignment.center, TVFlxAlignment.center, TBackgroundMode.Transparent, TextFillOptions); DataLabels[6].TextOptions = LabelTextOptions; LabelOptions = new TDataLabelOptions(); LabelOptions.ShowValues = true; LabelOptions.DataType = TLabelDataValue.SeriesInfo; LabelOptions.Position = TDataLabelPosition.Any; DataLabels[6].LabelOptions = LabelOptions; DataLabels[6].Frame = new TChartFrameOptions(null, null, null, false); DataLabels[6].LinkedTo = TLinkOption.DataLabel; DataLabels[6].SeriesIndex = 0; DataLabels[6].DataPointIndex = 6; DataLabels[6].NumberFormat = "#,##0"; DataLabels[6].NumberFormatLinkedToSource = false; DataLabels[7] = new TDataLabel(); DataLabels[7].PositionZeroBased = null; TextFillOptions = new ChartFillOptions(new TShapeFill(new TSolidFill(TDrawingColor.FromRgb(0x00, 0x00, 0x00)), true, TFormattingType.Subtle, null, false)); LabelTextOptions = new TChartTextOptions(new TFlxChartFont("Calibri", 1000, TExcelColor.FromArgb(0x00, 0x00, 0x00), TFlxFontStyles.Bold, TFlxUnderline.None, TFontScheme.None), THFlxAlignment.center, TVFlxAlignment.center, TBackgroundMode.Transparent, TextFillOptions); DataLabels[7].TextOptions = LabelTextOptions; LabelOptions = new TDataLabelOptions(); LabelOptions.ShowValues = true; LabelOptions.DataType = TLabelDataValue.SeriesInfo; DataLabels[7].LabelOptions = LabelOptions; DataLabels[7].LinkedTo = TLinkOption.DataLabel; DataLabels[7].SeriesIndex = 0; DataLabels[7].DataPointIndex = 7; DataLabels[7].NumberFormat = "#,##0"; DataLabels[7].NumberFormatLinkedToSource = false; DataLabels[8] = new TDataLabel(); DataLabels[8].PositionZeroBased = null; TextFillOptions = new ChartFillOptions(new TShapeFill(new TSolidFill(TDrawingColor.FromRgb(0x00, 0x00, 0x00)), true, TFormattingType.Subtle, null, false)); LabelTextOptions = new TChartTextOptions(new TFlxChartFont("Calibri", 900, TExcelColor.FromArgb(0x00, 0x00, 0x00), TFlxFontStyles.Bold, TFlxUnderline.None, TFontScheme.None), THFlxAlignment.center, TVFlxAlignment.center, TBackgroundMode.Transparent, TextFillOptions); DataLabels[8].TextOptions = LabelTextOptions; LabelOptions = new TDataLabelOptions(); LabelOptions.ShowValues = true; LabelOptions.DataType = TLabelDataValue.SeriesInfo; DataLabels[8].LabelOptions = LabelOptions; DataLabels[8].LinkedTo = TLinkOption.DataLabel; DataLabels[8].SeriesIndex = 0; DataLabels[8].DataPointIndex = 19; DataLabels[8].NumberFormat = "#,##0"; DataLabels[8].NumberFormatLinkedToSource = false; DataLabels[9] = new TDataLabel(); DataLabels[9].PositionZeroBased = null; TextFillOptions = new ChartFillOptions(new TShapeFill(new TSolidFill(TDrawingColor.FromRgb(0x00, 0x00, 0x00)), true, TFormattingType.Subtle, null, false)); LabelTextOptions = new TChartTextOptions(new TFlxChartFont("Calibri", 320, TExcelColor.FromArgb(0x00, 0x00, 0x00), TFlxFontStyles.Bold, TFlxUnderline.None, TFontScheme.None), THFlxAlignment.center, TVFlxAlignment.center, TBackgroundMode.Transparent, TextFillOptions); DataLabels[9].TextOptions = LabelTextOptions; LabelOptions = new TDataLabelOptions(); LabelOptions.ShowValues = true; LabelOptions.DataType = TLabelDataValue.SeriesInfo; DataLabels[9].LabelOptions = LabelOptions; DataLabels[9].LinkedTo = TLinkOption.DataLabel; DataLabels[9].SeriesIndex = 0; DataLabels[9].DataPointIndex = -1; DataLabels[9].NumberFormat = "#,##0"; DataLabels[9].NumberFormatLinkedToSource = false; Chart1.SetDataLabels(DataLabels); //Cell selection and scroll position. xls.SelectCell(47, 1, false); //Standard Document Properties - Most are only for xlsx files. In xls files FlexCel will only change the Creation Date and Modified Date. xls.DocumentProperties.SetStandardProperty(TPropertyId.Author, "Marko Puric"); //You will normally not set LastSavedBy, since this is a new file. //If you don't set it, FlexCel will use the creator instead. // xls.DocumentProperties.SetStandardProperty(TPropertyId.LastSavedBy, "Aliaksandr Marchuk"); //You will normally not set CreateDateTime, since this is a new file and FlexCel will automatically use the current datetime. //But if you are editing a file and want to preserve the original creation date, you need to either set PreserveCreationDate to true: // xls.DocumentProperties.PreserveCreationDate = true; //Or you can hardcode a creating date by setting it in UTC time, ISO8601 format: // xls.DocumentProperties.SetStandardProperty(TPropertyId.CreateTimeDate, "2025-09-23T14:15:42Z"); xls.DocumentProperties.SetStandardProperty(TPropertyId.Company, "Fiplan GmbH"); } }