Excel.Interfaces.HeaderFooterGroupLoadOptions interface
Remarks
Properties
$all | Specifying |
default |
The general header/footer, used for all pages unless even/odd or first page is specified. |
even |
The header/footer to use for even pages, odd header/footer needs to be specified for odd pages. |
first |
The first page header/footer, for all other pages general or even/odd is used. |
odd |
The header/footer to use for odd pages, even header/footer needs to be specified for even pages. |
state | The state by which headers/footers are set. See |
use |
Gets or sets a flag indicating if headers/footers are aligned with the page margins set in the page layout options for the worksheet. |
use |
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. |
Property Details
$all
Specifying $all
for the LoadOptions loads all the scalar properties (e.g.: Range.address
) but not the navigational properties (e.g.: Range.format.fill.color
).
$all?: boolean;
Property Value
boolean
defaultForAllPages
The general header/footer, used for all pages unless even/odd or first page is specified.
defaultForAllPages?: Excel.Interfaces.HeaderFooterLoadOptions;
Property Value
Remarks
evenPages
The header/footer to use for even pages, odd header/footer needs to be specified for odd pages.
evenPages?: Excel.Interfaces.HeaderFooterLoadOptions;
Property Value
Remarks
firstPage
The first page header/footer, for all other pages general or even/odd is used.
firstPage?: Excel.Interfaces.HeaderFooterLoadOptions;
Property Value
Remarks
oddPages
The header/footer to use for odd pages, even header/footer needs to be specified for even pages.
oddPages?: Excel.Interfaces.HeaderFooterLoadOptions;
Property Value
Remarks
state
The state by which headers/footers are set. See Excel.HeaderFooterState
for details.
state?: boolean;
Property Value
boolean
Remarks
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.
useSheetMargins?: boolean;
Property Value
boolean
Remarks
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.
useSheetScale?: boolean;
Property Value
boolean
Remarks
Office Add-ins