private PageSetup GetPageSetup() { PageSetup pageSetup = worksheet.GetFirstChild <PageSetup>(); if (pageSetup == null) { pageSetup = new PageSetup(); // ищем куда вставить ConditionalFormatting conditionalFormatting = null; var conditionalFormattings = worksheet.Elements <ConditionalFormatting>(); if (conditionalFormattings != null && conditionalFormattings.Count <ConditionalFormatting>() > 0) { conditionalFormatting = conditionalFormattings.Last <ConditionalFormatting>(); } if (conditionalFormatting != null) { conditionalFormatting.InsertAfterSelf <PageSetup>(pageSetup); } else { MergeCells mergeCells = worksheet.GetFirstChild <MergeCells>(); if (mergeCells != null) { mergeCells.InsertAfterSelf <PageSetup>(pageSetup); } else { SheetData sheetData = worksheet.GetFirstChild <SheetData>(); if (sheetData != null) { sheetData.InsertAfterSelf <PageSetup>(pageSetup); } } } } return(pageSetup); }