Excel.Interfaces.HeaderFooterGroupData interface

An interface describing the data returned by calling "headerFooterGroup.toJSON()".

Properties

defaultForAllPages

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

[ API set: ExcelApi 1.9 ]

evenPages

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

[ API set: ExcelApi 1.9 ]

firstPage

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

[ API set: ExcelApi 1.9 ]

oddPages

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

[ API set: ExcelApi 1.9 ]

state

Gets or sets the state of which headers/footers are set. See Excel.HeaderFooterState for details.

[ API set: ExcelApi 1.9 ]

useSheetMargins

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

[ API set: ExcelApi 1.9 ]

useSheetScale

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.

[ API set: ExcelApi 1.9 ]

Property Details

defaultForAllPages

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

[ API set: ExcelApi 1.9 ]

defaultForAllPages?: Excel.Interfaces.HeaderFooterData;

Property Value

evenPages

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

[ API set: ExcelApi 1.9 ]

evenPages?: Excel.Interfaces.HeaderFooterData;

Property Value

firstPage

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

[ API set: ExcelApi 1.9 ]

firstPage?: Excel.Interfaces.HeaderFooterData;

Property Value

oddPages

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

[ API set: ExcelApi 1.9 ]

oddPages?: Excel.Interfaces.HeaderFooterData;

Property Value

state

Gets or sets the state of which headers/footers are set. See Excel.HeaderFooterState for details.

[ API set: ExcelApi 1.9 ]

state?: Excel.HeaderFooterState | "Default" | "FirstAndDefault" | "OddAndEven" | "FirstOddAndEven";

Property Value

Excel.HeaderFooterState | "Default" | "FirstAndDefault" | "OddAndEven" | "FirstOddAndEven"

useSheetMargins

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

[ API set: ExcelApi 1.9 ]

useSheetMargins?: boolean;

Property Value

boolean

useSheetScale

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.

[ API set: ExcelApi 1.9 ]

useSheetScale?: boolean;

Property Value

boolean