C# Class OfficeOpenXml.ExcelHeaderFooterText

Print header and footer
Show file Open project: pruiz/EPPlus Class Usage Examples

Public Properties

Property Type Description
CenteredText string
LeftAlignedText string
RightAlignedText string

Public Methods

Method Description
InsertPicture ( FileInfo PictureFile, PictureAlignment Alignment ) : OfficeOpenXml.Drawing.Vml.ExcelVmlDrawingPicture

Inserts a picture at the end of the text in the header or footer
InsertPicture ( Image Picture, PictureAlignment Alignment ) : OfficeOpenXml.Drawing.Vml.ExcelVmlDrawingPicture

Inserts a picture at the end of the text in the header or footer

Private Methods

Method Description
AddImage ( Image Picture, string id, ExcelPackage ii ) : OfficeOpenXml.Drawing.Vml.ExcelVmlDrawingPicture
ExcelHeaderFooterText ( XmlNode TextNode, OfficeOpenXml.ExcelWorksheet ws, string hf ) : System
SetText ( string code, string text ) : void
ValidateImage ( PictureAlignment Alignment ) : string

Method Details

InsertPicture() public method

Inserts a picture at the end of the text in the header or footer
public InsertPicture ( FileInfo PictureFile, PictureAlignment Alignment ) : OfficeOpenXml.Drawing.Vml.ExcelVmlDrawingPicture
PictureFile System.IO.FileInfo The image object containing the Picture
Alignment PictureAlignment Alignment. The image object will be inserted at the end of the Text.
return OfficeOpenXml.Drawing.Vml.ExcelVmlDrawingPicture

InsertPicture() public method

Inserts a picture at the end of the text in the header or footer
public InsertPicture ( Image Picture, PictureAlignment Alignment ) : OfficeOpenXml.Drawing.Vml.ExcelVmlDrawingPicture
Picture Image The image object containing the Picture
Alignment PictureAlignment Alignment. The image object will be inserted at the end of the Text.
return OfficeOpenXml.Drawing.Vml.ExcelVmlDrawingPicture

Property Details

CenteredText public property

Get/set the text to appear in the center of the header (or footer) on the worksheet.
public string CenteredText
return string

LeftAlignedText public property

Get/set the text to appear on the left hand side of the header (or footer) on the worksheet.
public string LeftAlignedText
return string

RightAlignedText public property

Get/set the text to appear on the right hand side of the header (or footer) on the worksheet.
public string RightAlignedText
return string