Excel.Interfaces.HeaderFooterLoadOptions interface

Package:

excel

Remarks

[ API set: ExcelApi 1.9 ]

Properties

$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).
centerFooter	The center footer of the worksheet. To apply font formatting or insert a variable value, use format codes specified here: https://msdn.microsoft.com/library/bb225426.aspx.
centerHeader	The center header of the worksheet. To apply font formatting or insert a variable value, use format codes specified here: https://msdn.microsoft.com/library/bb225426.aspx.
leftFooter	The left footer of the worksheet. To apply font formatting or insert a variable value, use format codes specified here: https://msdn.microsoft.com/library/bb225426.aspx.
leftHeader	The left header of the worksheet. To apply font formatting or insert a variable value, use format codes specified here: https://msdn.microsoft.com/library/bb225426.aspx.
rightFooter	The right footer of the worksheet. To apply font formatting or insert a variable value, use format codes specified here: https://msdn.microsoft.com/library/bb225426.aspx.
rightHeader	The right header of the worksheet. To apply font formatting or insert a variable value, use format codes specified here: https://msdn.microsoft.com/library/bb225426.aspx.

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

centerFooter

The center footer of the worksheet. To apply font formatting or insert a variable value, use format codes specified here: https://msdn.microsoft.com/library/bb225426.aspx.

centerFooter?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.9 ]

centerHeader

The center header of the worksheet. To apply font formatting or insert a variable value, use format codes specified here: https://msdn.microsoft.com/library/bb225426.aspx.

centerHeader?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.9 ]

leftFooter

The left footer of the worksheet. To apply font formatting or insert a variable value, use format codes specified here: https://msdn.microsoft.com/library/bb225426.aspx.

leftFooter?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.9 ]

leftHeader

The left header of the worksheet. To apply font formatting or insert a variable value, use format codes specified here: https://msdn.microsoft.com/library/bb225426.aspx.

leftHeader?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.9 ]

rightFooter

The right footer of the worksheet. To apply font formatting or insert a variable value, use format codes specified here: https://msdn.microsoft.com/library/bb225426.aspx.

rightFooter?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.9 ]

rightHeader

The right header of the worksheet. To apply font formatting or insert a variable value, use format codes specified here: https://msdn.microsoft.com/library/bb225426.aspx.

rightHeader?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.9 ]