Class ExcelHeaderFooterText

Print header and footer

Inheritance

System.Object

ExcelHeaderFooterText

Inherited Members

System.Object.Equals(System.Object)

System.Object.Equals(System.Object, System.Object)

System.Object.GetHashCode()

System.Object.GetType()

System.Object.MemberwiseClone()

System.Object.ReferenceEquals(System.Object, System.Object)

System.Object.ToString()

Namespace: OfficeOpenXml

Assembly: EPPlus.dll

Syntax

public class ExcelHeaderFooterText

Properties

CenteredText

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

Declaration

public string CenteredText { get; set; }

Property Value

Type	Description
System.String

LeftAlignedText

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

Declaration

public string LeftAlignedText { get; set; }

Property Value

Type	Description
System.String

RightAlignedText

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

Declaration

public string RightAlignedText { get; set; }

Property Value

Type	Description
System.String

Methods

InsertPicture(FileInfo, PictureAlignment)

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

Declaration

public ExcelVmlDrawingPicture InsertPicture(FileInfo PictureFile, PictureAlignment Alignment)

Parameters

Type	Name	Description
System.IO.FileInfo	PictureFile	The image object containing the Picture
PictureAlignment	Alignment	Alignment. The image object will be inserted at the end of the Text.

Returns

Type	Description
ExcelVmlDrawingPicture

InsertPicture(Stream, ePictureType, PictureAlignment)

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

Declaration

public ExcelVmlDrawingPicture InsertPicture(Stream PictureStream, ePictureType pictureType, PictureAlignment Alignment)

Parameters

Type	Name	Description
System.IO.Stream	PictureStream	The stream containing the picture
OfficeOpenXml.Drawing.ePictureType	pictureType	The image format of the picture stream
PictureAlignment	Alignment	Alignment. The image object will be inserted at the end of the Text.

Returns

Type	Description
ExcelVmlDrawingPicture