Table of Contents

Class ExcelHeaderFooterText

Namespace
OfficeOpenXml
Assembly
EPPlus.dll

Print header and footer

public class ExcelHeaderFooterText
Inheritance
ExcelHeaderFooterText
Inherited Members

Properties

CenteredText

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

public string CenteredText { get; set; }

Property Value

string

LeftAlignedText

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

public string LeftAlignedText { get; set; }

Property Value

string

RightAlignedText

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

public string RightAlignedText { get; set; }

Property Value

string

Methods

InsertPicture(FileInfo, PictureAlignment)

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

public ExcelVmlDrawingPicture InsertPicture(FileInfo PictureFile, PictureAlignment Alignment)

Parameters

PictureFile FileInfo

The image object containing the Picture

Alignment PictureAlignment

Alignment. The image object will be inserted at the end of the Text.

Returns

ExcelVmlDrawingPicture

InsertPicture(Stream, ePictureType, PictureAlignment)

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

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

Parameters

PictureStream Stream

The stream containing the picture

pictureType ePictureType

The image format of the picture stream

Alignment PictureAlignment

Alignment. The image object will be inserted at the end of the Text.

Returns

ExcelVmlDrawingPicture