Images in Excel headers/footers

Base extensions can be used to add images into the header and footer areas in Excel. This can be especially useful when applying a logo to a customers Excel workbooks.

CMD

<cmd case="BaseExtensions:xl-header-footer-image" path="x" position="x"/>

Parameters

path

Required parameter. Defines the path to the image that should be inserted. This can either be a full path ("C:\somefolder\ExcelLogo.png") or the path from the content folder as root.

position

Required parameter referring to the position in the header/footer that the image should be inserted into. This takes one of six values each corresponding to and individual position. These are:

LeftHeader

CenterHeader

RightHeader

LeftFooter

CenterFooter

RightFooter

allSheets

Optional parameter. Accepts either true or false as values. If set to true, the image will be inserted in all worksheets. If omitted or set to false, the image will be inserted only on the actively selected worksheets.