# Configure Page Header and Footer

Learn how to set a different header and footer for the first page and even pages.

## Content

In DsExcel Java, you can use the [setLeftHeader](/document-solutions/java-excel-api/api/online/com/grapecity/documents/excel/IPageSetup.html#setLeftHeader), [setRightHeader](/document-solutions/java-excel-api/api/online/com/grapecity/documents/excel/IPageSetup.html#setRightHeader), [setLeftFooter](/document-solutions/java-excel-api/api/online/com/grapecity/documents/excel/IPageSetup.html#setLeftFooter), [setRightFooter](/document-solutions/java-excel-api/api/online/com/grapecity/documents/excel/IPageSetup.html#setRightFooter), [setCenterHeader](/document-solutions/java-excel-api/api/online/com/grapecity/documents/excel/IPageSetup.html#setCenterHeader) and [setCenterFooter](/document-solutions/java-excel-api/api/online/com/grapecity/documents/excel/IPageSetup.html#setCenterFooter) methods of the [IPageSetup](/document-solutions/java-excel-api/api/online/com/grapecity/documents/excel/IPageSetup.html) interface in order to configure header and footer for a page.

```Java
// Configure PageHeader and PageFooter
// Set header for the page
worksheet.getPageSetup().setLeftHeader("&\"Arial,Italic\"LeftHeader");
worksheet.getPageSetup().setCenterHeader("&P");

// Set header and footer graphic for the page
worksheet.getPageSetup().setCenterFooter("&G");
InputStream stream = ClassLoader.getSystemResourceAsStream("logo.png");
worksheet.getPageSetup().getCenterFooterPicture().setGraphicStream(stream, ImageType.PNG);
```

For special settings, you can also perform the following tasks in order to customize the configuration of the header and footer of your page:

* [Configure First Page](/document-solutions/java-excel-api/docs/online/Features/ConfigurePrintSettingsviaPageSetup/ConfigurePageHeaderandFooter#configure-first-page)
* [Configure Even Page](/document-solutions/java-excel-api/docs/online/Features/ConfigurePrintSettingsviaPageSetup/ConfigurePageHeaderandFooter#configure-even-page)
* [Set Page and Total Page Number Calculation](/document-solutions/java-excel-api/docs/online/Features/ConfigurePrintSettingsviaPageSetup/ConfigurePageHeaderandFooter#set-page-and-total-page-number-calculation)

## Configure First Page

If you want a different header and footer in your first page, you first need to set the [setDifferentFirstPageHeaderFooter](/document-solutions/java-excel-api/api/online/com/grapecity/documents/excel/IPageSetup.html#setDifferentFirstPageHeaderFooter) method of the IPageSetup interface to true. When this is done, you can use the method of the IPageSetup interface in order to configure the first page header and footer.

```Java
//Set first page header and footer
worksheet.getPageSetup().setDifferentFirstPageHeaderFooter(true);
worksheet.getPageSetup().getFirstPage().getCenterHeader().setText("&T");
worksheet.getPageSetup().getFirstPage().getRightFooter().setText("&D");

//Set first page header and footer graphic
worksheet.getPageSetup().getFirstPage().getLeftFooter().setText("&G");
InputStream stream = ClassLoader.getSystemResourceAsStream("logo.png");
worksheet.getPageSetup().getFirstPage().getLeftFooter().getPicture().setGraphicStream(stream, ImageType.PNG);
worksheet.getPageSetup().getFirstPage().getLeftFooter().getPicture().setWidth(100);
worksheet.getPageSetup().getFirstPage().getLeftFooter().getPicture().setHeight(13);
```

## Configure Even Page

If you want a different header and footer for all the even pages, you first need to set the [setOddAndEvenPagesHeaderFooter](/document-solutions/java-excel-api/api/online/com/grapecity/documents/excel/IPageSetup.html#setOddAndEvenPagesHeaderFooter) method to true. When this is done, you can use other methods of the IPageSetup interface in order to configure the even page header and footer.

```Java
// Set even page header and footer
worksheet.getPageSetup().setOddAndEvenPagesHeaderFooter(true);
worksheet.getPageSetup().getEvenPage().getCenterHeader().setText("&T");
worksheet.getPageSetup().getEvenPage().getRightFooter().setText("&D");

// Set even page header and footer graphic
worksheet.getPageSetup().getEvenPage().getLeftFooter().setText("&G");
InputStream stream = ClassLoader.getSystemResourceAsStream("logo.png");
worksheet.getPageSetup().getEvenPage().getLeftFooter().getPicture().setGraphicStream(stream, ImageType.PNG);
```

## Set Page and Total Page Number Calculation

DsExcel supports Addition (+) and Subtraction (-) operators for page and total page number calculations in custom page headers and footers. These operators function in all paginated outputs that respect custom headers and footers in [getPageSetup](/document-solutions/java-excel-api/api/online/com/grapecity/documents/excel/IWorksheet.html#getPageSetup) method of [IWorksheet](/document-solutions/java-excel-api/api/online/com/grapecity/documents/excel/IWorksheet.html) interface, such as PDFs and print to physical printers.
DsExcel supports the following formulas for page and total page number calculations:

| **Formula** | **Description** |
| ------- | ----------- |
| &P+number | Prints the page number plus the specified number. |
| &P-number | Prints the page number minus the specified number. |
| &N+number | Prints the total number of pages plus the specified number. |
| &N-number | Prints the total number of pages minus the specified number. |

> !type=note
> **Note**: "number"can be any 32-bit positive integer.

```Java
// Create a new workbook.
var workbook = new Workbook();

// Open Excel document.
workbook.open("PageSetup Demo.xlsx");

// Access first worksheet.
IWorksheet worksheet = workbook.getWorksheets().get(0);

// Set page headerfooter.
/* Use &P+1 to display the page number plus one.
   Use &N+1 to display the total page number plus one. */
worksheet.getPageSetup().setRightHeader("Page header example &P+1 of &N+1");
worksheet.getPageSetup().setRightFooter("Page footer example &P+2 of &N+2");
worksheet.getPageSetup().customPaperSize(8.5,6);

// Save workbook to a PDF document.
workbook.save("ConfigHeaderFooterPageNumberCalc.pdf");
```

![](https://cdn.mescius.io/document-site-files/images/dd59ea42-cd61-4fa6-a018-6231c2a9c598/images/page-number-calc.png)