Class ExcelHeaderFooterText

Print header and footer

Inheritance

object

ExcelHeaderFooterText

Inherited Members

object.Equals(object)

object.Equals(object, object)

object.GetHashCode()

object.GetType()

object.MemberwiseClone()

object.ReferenceEquals(object, object)

object.ToString()

Namespace: OfficeOpenXml

Assembly: EPPlus.dll

Syntax

public class ExcelHeaderFooterText

Properties

Centered

The text collection of the centered part of the header or footer.

Declaration

public ExcelHeaderFooterTextCollection Centered { get; }

Property Value

Type	Description
ExcelHeaderFooterTextCollection

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
string

LeftAligned

The text collection of the left part of the header or footer.

Declaration

public ExcelHeaderFooterTextCollection LeftAligned { get; }

Property Value

Type	Description
ExcelHeaderFooterTextCollection

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
string

RightAligned

The text collection of the right part of the header or footer.

Declaration

public ExcelHeaderFooterTextCollection RightAligned { get; }

Property Value

Type	Description
ExcelHeaderFooterTextCollection

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
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
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
Stream	PictureStream	The stream containing the picture
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

RemoveImage(ExcelVmlDrawingPicture)

Remove the specified item from the collection.

Declaration

public void RemoveImage(ExcelVmlDrawingPicture item)

Parameters

Type	Name	Description
ExcelVmlDrawingPicture	item	The item to remove.