...
- In Microsoft Excel, open the File menu and select Page Setup...
# - Select the Header/Footer tab.
- # Select a header and/or footer from the drop-down list.
\\\
*
Or*, create a custom header/footer.
\\\
# - Save the spreadsheet.
- # In an ExcelWriter script, open the spreadsheet containing headers/footers. Use either ExcelTemplate.Open or ExcelApplication.Open to open the spreadsheet.
- # Modify the spreadsheet in script. Do not change the text of headers and footers; if you do, the original formatting will be overwritten and default formatting will be applied.
\\\