Using Aspose.Cells Placeholders in Excel Header or Footer

Aspose.Cells Product Family
1

Hi, is it possible to use aspose.cell placeholders in the excel header or footer?
It is currently not working for me. The placeholder variables work in spreadsheet but not in the header. Does anyone have a solution for this?
Thanks, Lisa Bildschirmfoto 2022-03-18 um 08.09.01.png (62.4 KB)

2

@lbreitenfellner,

We are afraid, you cannot set Header and Footer using Smart Marker tags/placeholders. Please note,
headers/footers are added with the help of script commands, so you will have to set them separately in you code. Please see the following documentation article that illustrates how to set Header and Footer using Aspose.Cells API: