Working with Headers and Footers in XLS(x) files

[zpredojevic]

Hi!

I’m using Cells 22.12 for Java and I need to access and modify header and footer values ​​in an xls(x) documents.

I noticed that there are HeaderFooterCommand and HeaderFooterCommandType classes that can be used to define header/footer type and to access to their properties such as font and content (text), but I haven’t found a way to access them (either using the Worksheet instance or even using the Workbook instance).

If you have developed support for working with headers and footers, please provide me with an example or direct me to the same where I could see access to them and their content and manipulation of them.

Thanks in advance!

Best regards!
Nenad

[John.He]

@zpredojevic,
Would you like to refer to the following links？

Page Setup Features

Header and Footers

[zpredojevic]

@John.He

Thanks a lot!

Nenad

[amjad.sahi]

@zpredojevic,

Good to know that the suggested documents (having examples) give you all the details for your requirements. If you still have any issue or confusion, feel free to write us back and we will be happy to assist you soon.