Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Migrated to Confluence 4.0

...

  1. In Microsoft Excel, open the File menu and select Page Setup...
    #
  2. Select the Header/Footer tab.

  3. # Select a header and/or footer from the drop-down list.
    \\\

    *
    Or*, create a custom header/footer.
    \\\

    #
  4. Save the spreadsheet.

  5. # In an ExcelWriter script, open the spreadsheet containing headers/footers. Use either ExcelTemplate.Open or ExcelApplication.Open to open the spreadsheet.

  6. # 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.
    \\\