Skip to main content

GetEvenPage

Returns the header and footer of the even pages of the worksheet. The returned object is meaningful when ApiPageSetup#GetOddAndEvenPagesHeaderFooter is enabled.

Syntax​

expression.GetEvenPage();

expression - A variable that represents an ApiPageSetup class.

Parameters​

This method doesn't have any parameters.

Returns​

ApiPage

Example​

Get the even-page header/footer object to customize printing in a spreadsheet.

// How do I set a separate header or footer for even pages in a spreadsheet?

// Access the even pages' header and footer to give them their own content in a spreadsheet.

let worksheet = Api.GetActiveSheet();
let pageSetup = worksheet.GetPageSetup();
pageSetup.SetOddAndEvenPagesHeaderFooter(true);
let evenPage = pageSetup.GetEvenPage();
evenPage.GetCenterHeader().SetText("Even page &P");