C# Class OfficeOpenXml.ExcelHeaderFooterText

Print header and footer
ファイルを表示 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_oe 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_oe 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_oe 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