private void addHeaderFooter() { if (!string.IsNullOrEmpty(Header)) _worksheet.HeaderFooter.OddHeader.CenteredText = Header; if (!string.IsNullOrEmpty(Footer)) _worksheet.HeaderFooter.OddFooter.CenteredText = Footer; }