Class ExcelDrawing

Base class for drawings. Drawings are Charts, shapes and Pictures.

Inheritance
System.Object
XmlHelper
ExcelDrawing
ExcelChart
ExcelPicture
ExcelShape
Inherited Members
System.Object.ToString()
System.Object.Equals(System.Object)
System.Object.Equals(System.Object, System.Object)
System.Object.ReferenceEquals(System.Object, System.Object)
System.Object.GetHashCode()
System.Object.GetType()
System.Object.MemberwiseClone()
Namespace: Experior.Core.Data.OfficeOpenXml.Drawing
Assembly: Experior.Core.dll
Syntax
public class ExcelDrawing : XmlHelper

Fields

_drawings

Declaration
protected ExcelDrawings _drawings
Field Value
Type Description
ExcelDrawings

_id

Declaration
protected int _id
Field Value
Type Description
System.Int32

_topNode

Declaration
protected XmlNode _topNode
Field Value
Type Description
System.Xml.XmlNode

EMU_PER_PIXEL

Declaration
public const int EMU_PER_PIXEL = 9525
Field Value
Type Description
System.Int32

Properties

EditAs

How Excel resize drawings when the column width is changed within Excel. The width of drawings are currently NOT resized in EPPLus when the column width changes

Declaration
public eEditAs EditAs { get; set; }
Property Value
Type Description
eEditAs

From

Declaration
public ExcelDrawing.ExcelPosition From { get; set; }
Property Value
Type Description
ExcelDrawing.ExcelPosition

Locked

Lock drawing

Declaration
public bool Locked { get; set; }
Property Value
Type Description
System.Boolean

Name

The name of the drawing object

Declaration
public string Name { get; set; }
Property Value
Type Description
System.String

Print

Print drawing with sheet

Declaration
public bool Print { get; set; }
Property Value
Type Description
System.Boolean

To

Bottom right position

Declaration
public ExcelDrawing.ExcelPosition To { get; set; }
Property Value
Type Description
ExcelDrawing.ExcelPosition

Methods

SetPosition(Int32, Int32)

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

Declaration
public void SetPosition(int PixelTop, int PixelLeft)
Parameters
Type Name Description
System.Int32 PixelTop

Top pixel
System.Int32 PixelLeft

Left pixel

SetPosition(Int32, Int32, Int32, Int32)

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

Declaration
public void SetPosition(int Row, int RowOffsetPixels, int Column, int ColumnOffsetPixels)
Parameters
Type Name Description
System.Int32 Row

Start row
System.Int32 RowOffsetPixels

Offset in pixels
System.Int32 Column

Start Column
System.Int32 ColumnOffsetPixels

Offset in pixels

SetSize(Int32)

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

Declaration
public virtual void SetSize(int Percent)
Parameters
Type Name Description
System.Int32 Percent

SetSize(Int32, Int32)

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

Declaration
public void SetSize(int PixelWidth, int PixelHeight)
Parameters
Type Name Description
System.Int32 PixelWidth

Width in pixels
System.Int32 PixelHeight

Height in pixels