C# Class OfficeOpenXml.Drawing.ExcelDrawing

Base class for twoanchored drawings. Drawings are Charts, shapes and Pictures.
Inheritance: XmlHelper, IDisposable
显示文件 Open project: ylatuya/EPPlus Class Usage Examples

Protected Properties

Property Type Description
_drawings OfficeOpenXml.Drawing.ExcelDrawings
_id int
_topNode System.Xml.XmlNode

Private Properties

Property Type Description
ExcelDrawing System
ExcelDrawing System
GetColumnWidth decimal
GetDrawing ExcelDrawing
GetPixelHeight int
GetPixelLeft int
GetPixelTop int
GetPixelWidth int
GetRowWidth double
GetTextAchoringEnum eTextAnchoringType
GetTextAchoringText string
GetTextVerticalEnum eTextVerticalType
GetTextVerticalText string
SetPixelHeight void
SetPixelHeight void
SetPixelLeft void
SetPixelTop void
SetPixelWidth void
SetPixelWidth void

Public Methods

Method Description
SetPosition ( int PixelTop, int PixelLeft ) : void

Set the top left corner of a drawing. Note that resizing columns / rows after using this function will effect the position of the drawing

SetPosition ( int Row, int RowOffsetPixels, int Column, int ColumnOffsetPixels ) : void

Set the top left corner of a drawing. Note that resizing columns / rows after using this function will effect the position of the drawing

SetSize ( int Percent ) : void

Set size in Percent Note that resizing columns / rows after using this function will effect the size of the drawing

SetSize ( int PixelWidth, int PixelHeight ) : void

Set size in pixels Note that resizing columns / rows after using this function will effect the size of the drawing

Private Methods

Method Description
ExcelDrawing ( OfficeOpenXml.Drawing.ExcelDrawings drawings, XmlNode node, string nameXPath ) : System
ExcelDrawing ( XmlNamespaceManager nameSpaceManager, XmlNode node ) : System
GetColumnWidth ( int col ) : decimal
GetDrawing ( OfficeOpenXml.Drawing.ExcelDrawings drawings, XmlNode node ) : ExcelDrawing

Add new Drawing types here

GetPixelHeight ( ) : int
GetPixelLeft ( ) : int
GetPixelTop ( ) : int
GetPixelWidth ( ) : int
GetRowWidth ( int row ) : double
GetTextAchoringEnum ( string text ) : eTextAnchoringType
GetTextAchoringText ( eTextAnchoringType value ) : string
GetTextVerticalEnum ( string text ) : eTextVerticalType
GetTextVerticalText ( eTextVerticalType value ) : string
SetPixelHeight ( int pixels ) : void
SetPixelHeight ( int pixels, float dpi ) : void
SetPixelLeft ( int pixels ) : void
SetPixelTop ( int pixels ) : void
SetPixelWidth ( int pixels ) : void
SetPixelWidth ( int pixels, float dpi ) : void

Method Details

SetPosition() public method

Set the top left corner of a drawing. Note that resizing columns / rows after using this function will effect the position of the drawing
public SetPosition ( int PixelTop, int PixelLeft ) : void
PixelTop int Top pixel
PixelLeft int Left pixel
return void

SetPosition() public method

Set the top left corner of a drawing. Note that resizing columns / rows after using this function will effect the position of the drawing
public SetPosition ( int Row, int RowOffsetPixels, int Column, int ColumnOffsetPixels ) : void
Row int Start row
RowOffsetPixels int Offset in pixels
Column int Start Column
ColumnOffsetPixels int Offset in pixels
return void

SetSize() public method

Set size in Percent Note that resizing columns / rows after using this function will effect the size of the drawing
public SetSize ( int Percent ) : void
Percent int
return void

SetSize() public method

Set size in pixels Note that resizing columns / rows after using this function will effect the size of the drawing
public SetSize ( int PixelWidth, int PixelHeight ) : void
PixelWidth int Width in pixels
PixelHeight int Height in pixels
return void

Property Details

_drawings protected_oe property

protected ExcelDrawings,OfficeOpenXml.Drawing _drawings
return OfficeOpenXml.Drawing.ExcelDrawings

_id protected_oe property

protected int _id
return int

_topNode protected_oe property

protected XmlNode,System.Xml _topNode
return System.Xml.XmlNode