Class ExcelDrawings

Collection for Drawing objects.

Inheritance

System.Object

ExcelDrawings

Implements

System.Collections.Generic.IEnumerable<ExcelDrawing>

System.Collections.IEnumerable

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 ExcelDrawings : IEnumerable<ExcelDrawing>, IEnumerable

Properties

Count

Declaration

public int Count { get; }

Property Value

Type	Description
System.Int32

DrawingXml

A reference to the drawing xml document

Declaration

public XmlDocument DrawingXml { get; }

Property Value

Type	Description
System.Xml.XmlDocument

Item[Int32]

Returns the drawing at the specified position.

Declaration

public ExcelDrawing this[int PositionID] { get; }

Parameters

Type	Name	Description
System.Int32	PositionID	The position of the drawing. 0-base

Property Value

Type	Description
ExcelDrawing

Item[String]

Returns the drawing matching the specified name

Declaration

public ExcelDrawing this[string Name] { get; }

Parameters

Type	Name	Description
System.String	Name	The name of the worksheet

Property Value

Type	Description
ExcelDrawing

NameSpaceManager

Declaration

public XmlNamespaceManager NameSpaceManager { get; }

Property Value

Type	Description
System.Xml.XmlNamespaceManager

UriDrawing

Declaration

public Uri UriDrawing { get; }

Property Value

Type	Description
System.Uri

Methods

AddChart(String, eChartType)

Add a new chart to the worksheet. Do not support Bubble-, Radar-, Stock- or Surface charts.

Declaration

public ExcelChart AddChart(string Name, eChartType ChartType)

Parameters

Type	Name	Description
System.String	Name
eChartType	ChartType	Type of chart

Returns

Type	Description
ExcelChart	The chart

AddChart(String, eChartType, ExcelPivotTable)

Add a new chart to the worksheet. Do not support Bubble-, Radar-, Stock- or Surface charts.

Declaration

public ExcelChart AddChart(string Name, eChartType ChartType, ExcelPivotTable PivotTableSource)

Parameters

Type	Name	Description
System.String	Name
eChartType	ChartType	Type of chart
ExcelPivotTable	PivotTableSource	The pivottable source for a pivotchart

Returns

Type	Description
ExcelChart	The chart

AddPicture(String, Image)

Add a picure to the worksheet

Declaration

public ExcelPicture AddPicture(string Name, Image image)

Parameters

Type	Name	Description
System.String	Name
System.Drawing.Image	image	An image. Allways saved in then JPeg format

Returns

Type	Description
ExcelPicture

AddPicture(String, Image, Uri)

Add a picure to the worksheet

Declaration

public ExcelPicture AddPicture(string Name, Image image, Uri Hyperlink)

Parameters

Type	Name	Description
System.String	Name
System.Drawing.Image	image	An image. Allways saved in then JPeg format
System.Uri	Hyperlink	Picture Hyperlink

Returns

Type	Description
ExcelPicture

AddPicture(String, FileInfo)

Add a picure to the worksheet

Declaration

public ExcelPicture AddPicture(string Name, FileInfo ImageFile)

Parameters

Type	Name	Description
System.String	Name
System.IO.FileInfo	ImageFile	The image file

Returns

Type	Description
ExcelPicture

AddPicture(String, FileInfo, Uri)

Add a picure to the worksheet

Declaration

public ExcelPicture AddPicture(string Name, FileInfo ImageFile, Uri Hyperlink)

Parameters

Type	Name	Description
System.String	Name
System.IO.FileInfo	ImageFile	The image file
System.Uri	Hyperlink	Picture Hyperlink

Returns

Type	Description
ExcelPicture

AddShape(String, eShapeStyle)

Add a new shape to the worksheet

Declaration

public ExcelShape AddShape(string Name, eShapeStyle Style)

Parameters

Type	Name	Description
System.String	Name	Name
eShapeStyle	Style	Shape style

Returns

Type	Description
ExcelShape	The shape object

Clear()

Removes all drawings from the collection

Declaration

public void Clear()

GetEnumerator()

Declaration

public IEnumerator GetEnumerator()

Returns

Type	Description
System.Collections.IEnumerator

Remove(ExcelDrawing)

Removes a drawing.

Declaration

public void Remove(ExcelDrawing Drawing)

Parameters

Type	Name	Description
ExcelDrawing	Drawing	The drawing

Remove(Int32)

Removes a drawing.

Declaration

public void Remove(int Index)

Parameters

Type	Name	Description
System.Int32	Index	The index of the drawing

Remove(String)

Removes a drawing.

Declaration

public void Remove(string Name)

Parameters

Type	Name	Description
System.String	Name	The name of the drawing

Explicit Interface Implementations

IEnumerable<ExcelDrawing>.GetEnumerator()

Declaration

IEnumerator<ExcelDrawing> IEnumerable<ExcelDrawing>.GetEnumerator()

Returns

Type	Description
System.Collections.Generic.IEnumerator<ExcelDrawing>

Implements

System.Collections.Generic.IEnumerable<T>

System.Collections.IEnumerable