Setting Different Headers and Footers For Different Pages

Setting Different Headers and Footers in MS Excel

Setting Different Headers and Footers

  1. Click page Layout > Print Titles > Header/Footer.
  2. Check Different Odd and Even Pages or Different fir page.
  3. Enter different headers and footers.

Setting Different Headers and Footers with Aspose.Cells

Aspose.Cells behaves the same as Excel.

  1. Sets the flags PageSetup.IsHFDiffOddEven and PageSetup.IsHFDiffFirst
  2. Enter different headers and footers.
    //Creates a new file.
    var wb = new Workbook();
    //Gets the setting of page setup.
    PageSetup pageSetup = wb.Worksheets[0].PageSetup;
    //Sets different odd and even pages
    pageSetup.IsHFDiffOddEven = true;
    pageSetup.SetHeader(1, "I am the header of the Odd page.");
    pageSetup.SetEvenHeader(1, "I am the header of the Even page.");
    //Sets different first page
    pageSetup.IsHFDiffFirst = true;
    pageSetup.SetFirstPageHeader(1, "I am the header of the First page.");