Excel.Interfaces.HeaderFooterLoadOptions interface
Remarks
Properties
| $all | Specifying |
| center |
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. |
| center |
Gets a |
| center |
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. |
| center |
Gets a |
| left |
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. |
| left |
Gets a |
| left |
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. |
| left |
Gets a |
| right |
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. |
| right |
Gets a |
| right |
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. |
| right |
Gets a |
Property Details
$all
Specifying $all for the load options loads all the scalar properties (such as Range.address) but not the navigational properties (such as 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
centerFooterPicture
Gets a HeaderFooterPicture object that represents the picture for the center section of the footer.
centerFooterPicture?: Excel.Interfaces.HeaderFooterPictureLoadOptions;Property Value
Remarks
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
centerHeaderPicture
Gets a HeaderFooterPicture object that represents the picture for the center section of the header.
centerHeaderPicture?: Excel.Interfaces.HeaderFooterPictureLoadOptions;Property Value
Remarks
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
leftFooterPicture
Gets a HeaderFooterPicture object that represents the picture for the left section of the footer.
leftFooterPicture?: Excel.Interfaces.HeaderFooterPictureLoadOptions;Property Value
Remarks
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
leftHeaderPicture
Gets a HeaderFooterPicture object that represents the picture for the left section of the header.
leftHeaderPicture?: Excel.Interfaces.HeaderFooterPictureLoadOptions;Property Value
Remarks
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
rightFooterPicture
Gets a HeaderFooterPicture object that represents the picture for the right section of the footer.
rightFooterPicture?: Excel.Interfaces.HeaderFooterPictureLoadOptions;Property Value
Remarks
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
rightHeaderPicture
Gets a HeaderFooterPicture object that represents the picture for the right section of the header.
rightHeaderPicture?: Excel.Interfaces.HeaderFooterPictureLoadOptions;