ImageGear .NET
Headers and Footers
| User Guide > How to Work with... > Formats with Additional Functionality > Office > Excel Documents > Supported SpreadsheetML Groups > Headers and Footers |
Headers and footers refer to text, graphics, or data fields (such as page number, date, sheet tab name, and so on) that can appear at the top or bottom of each page in a SpreadsheetML document. A header appears in the top margin (above the main document content on the page), while a footer appears in the bottom margin of a document page (below the main document content on the page).
Since SpreadsheetML is a flow-based format, headers and footers are applied by specifying the headers and footers for all pages in a particular section of a document. Within each section of a document, there can be up to three different types of headers and footers, and within each header/footer type there are three locations: "left", "center", and "right".
First page header/footer
First page headers and footers specify up to three headers and footers which shall appear on left, center, and right sides of the first page of a section.
Odd page header/footer
Odd page headers and footers specify up to three headers and footers which shall appear on left, center, and right sides of all odd-numbered pages in a given section.
Even page header/footer
Even page headers and footers specify up to three headers and footers which shall appear on left, center, and right sides of all even-numbered pages in a given section.
The following header/footer attributes are supported by ImageGear:
|
Feature |
Description |
Comment |
|
Different First |
This attribute specifies the header and footer are different for the first page. |
Fully supported. |
|
Different Odd Even |
This attribute specifies the header and footer are different on odd-numbered pages and even-numbered pages. |
Fully supported. |
|
Align With Margins |
This attribute specifies the header and footer should align with the left and right margins of the chart. |
Fully supported. |
|
Scale With Document |
This attribute specifies the header and footer should be scaled with document. |
Fully supported. |
The following data fields are supported in header/footer by ImageGear:
|
Feature |
Description |
Comment | ||
|
Current Page |
This header/footer data field specifies the current page number. |
ImageGear supports the numbers in decimal format. | ||
|
Total Pages |
This header/footer data field describes the number of pages of the document. |
ImageGear supports the numbers in decimal format. | ||
|
Date |
This header/footer data field describes the date. |
ImageGear supports the data in Short Date Pattern. | ||
|
Time |
This header/footer data field describes the time. |
ImageGear supports the time in Short Time Pattern. | ||
|
Workbook’s File Path |
This header/footer data field describes the workbook’s file path. |
ImageGear supports the file path in system-specific format. | ||
|
Workbook’s File Name |
This header/footer data field describes the workbook’s file name. |
ImageGear supports the file name without file extension. | ||
|
Sheet Tab Name |
This header/footer data field describes current sheet tab name. |
ImageGear supports the sheet tab name, which should be unique. | ||
|
Picture |
This header/footer data field describes a background picture. |
ImageGear supports the picture with following parameters (Format Picture dialog in MS Excel):
|
The following style attributes are supported in header/footer by ImageGear:
|
Feature |
Description |
Comment |
|
Fonts |
This style attribute defines the properties for one of the fonts used in header/footer. |
The following font attributes are supported:
|
|
Font Color |
This style attribute describes the font color of the header/footer. |
ImageGear supports the font color in RGB and Theme Color formats:
|
