ExcelScript.HeaderFooterGroup interface

The general header/footer, used for all pages unless even/odd or first page is specified.

getDefaultForAllPages(): HeaderFooter;

Returns

The header/footer to use for even pages, odd header/footer needs to be specified for odd pages.

getEvenPages(): HeaderFooter;

Returns

The first page header/footer, for all other pages general or even/odd is used.

getFirstPage(): HeaderFooter;

Returns

The header/footer to use for odd pages, even header/footer needs to be specified for even pages.

getOddPages(): HeaderFooter;

Returns

The state by which headers/footers are set. See ExcelScript.HeaderFooterState for details.

getState(): HeaderFooterState;

Returns

Gets or sets a flag indicating if headers/footers are aligned with the page margins set in the page layout options for the worksheet.

getUseSheetMargins(): boolean;

Returns

Gets or sets a flag indicating if headers/footers should be scaled by the page percentage scale set in the page layout options for the worksheet.

getUseSheetScale(): boolean;

Returns

The state by which headers/footers are set. See ExcelScript.HeaderFooterState for details.

setState(state: HeaderFooterState): void;

Parameters

Returns

Gets or sets a flag indicating if headers/footers are aligned with the page margins set in the page layout options for the worksheet.

setUseSheetMargins(useSheetMargins: boolean): void;

Parameters

Returns

Gets or sets a flag indicating if headers/footers should be scaled by the page percentage scale set in the page layout options for the worksheet.

setUseSheetScale(useSheetScale: boolean): void;

Parameters

Returns