A reference to the header and footer class which allows you to
set the header and footer for all odd, even and first pages of the worksheet
Namespace:
OfficeOpenXml
Assembly:
EPPlus (in EPPlus.dll) Version: 3.0.0.1 (3.0.0.1)
Syntax
| C# |
|---|
public ExcelHeaderFooter HeaderFooter { get; } |
| Visual Basic (Declaration) |
|---|
Public ReadOnly Property HeaderFooter As ExcelHeaderFooter |
| Visual C++ |
|---|
public: property ExcelHeaderFooter^ HeaderFooter { ExcelHeaderFooter^ get (); } |
Remarks
To format the text you can use the following format
| Prefix | Description |
|---|---|
| &U | Underlined |
| &E | Double Underline |
| &K:xxxxxx | Color. ex &K:FF0000 for red |
| &"Font,Regular Bold Italic" | Changes the font. Regular or Bold or Italic or Bold Italic can be used. ex &"Arial,Bold Italic" |
| &nn | Change font size. nn is an integer. ex &24 |
| &G | Placeholder for images. Images can not be added by the library, but its possible to use in a template. |
