Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Excerpt

To create and format spreadsheet headers and footers, use

...

the HeaderFooterSection

...

 object, which can be retrieved using

...

the PageSetup.GetHeader(HeaderFooterSection.Section)

...

 and PageSetup.GetFooter(HeaderFooterSection.Section)

...

 methods.

Info

To see spreadsheet headers and footers in Excel, open the File menu, select Page Setup, and select the Header/Footer tab.

...

When opening an existing Excel spreadsheet, ExcelWriter will preserve the header and footer formatting created in Excel. However, if you change the header/footer text in your ExcelWriter script and do not include Formatting Codes, the formatting created in Excel will be overwritten and default formatting will be applied. To preserve header/footer formatting created in Excel, do not change header/footer text in script.

...