JavaScript API
An Office service that supports add-ins to interact with objects in Office client applications.
1,035 questions
Can I use the Excel JavaScript API to a header image in the page layout?
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(64, 53%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EI%3C/text%3E%3C/svg%3E)
Ian
0
Reputation points
I am trying to add a watermark using the header in the page layout of an Excel sheet.
In API reference for Excel.HeaderFooter class there are properties for each header and footer section that can be set with the API. The API reference for the header properties has a link to format codes that can be set. One of those format codes is &G which has the description "Inserts and image.", but I have not had any luck using it.
If I manually add an image to the worksheet header it appears as &[Picture] in the worksheet, and the property for the HeaderFooter class is &G. If I set the property to an empty string then the image disappears, but if I try to add &G back the image does not reappear.
I am guessing that the image needs to be passed in somehow, and I have tried doing that several way with no success. Does anyone know if there is way to set the header image using the javascript api?
Sign in to answer