Class PicturesCollection

Namespace

Spire.Xls.Collections

Assembly

Spire.XLS.dll

public class PicturesCollection : XlsPicturesCollection, IList<IPictureShape>, ICollection<IPictureShape>, IEnumerable<IPictureShape>, ICloneParent, IPictures, IExcelApplication, IEnumerable, IDisposable

Inheritance

object

CollectionBase<IPictureShape>

CollectionExtended<IPictureShape>

XlsPicturesCollection

PicturesCollection

Implements

IList<IPictureShape>

ICollection<IPictureShape>

IEnumerable<IPictureShape>

ICloneParent

IPictures

IExcelApplication

IEnumerable

IDisposable

Inherited Members

XlsPicturesCollection.Clear()

CollectionExtended<IPictureShape>.OnClear()

CollectionExtended<IPictureShape>.OnClearComplete()

CollectionExtended<IPictureShape>.OnInsert(int, IPictureShape)

CollectionExtended<IPictureShape>.OnInsertComplete(int, IPictureShape)

CollectionExtended<IPictureShape>.OnRemove(int, IPictureShape)

CollectionExtended<IPictureShape>.OnRemoveComplete(int, IPictureShape)

CollectionExtended<IPictureShape>.OnSet(int, IPictureShape, IPictureShape)

CollectionExtended<IPictureShape>.OnSetComplete(int, IPictureShape, IPictureShape)

CollectionExtended<IPictureShape>.FindParent(Type)

CollectionExtended<IPictureShape>.FindParent(Type, bool)

CollectionExtended<IPictureShape>.SetParent(object)

CollectionExtended<IPictureShape>.Clone(object)

CollectionExtended<IPictureShape>.EnsureCapacity(int)

CollectionExtended<IPictureShape>.GenerateDefaultName(ICollection<IPictureShape>, string)

CollectionExtended<IPictureShape>.GenerateDefaultName(ICollection, string)

CollectionExtended<IPictureShape>.GenerateDefaultName(string, params ICollection[])

CollectionExtended<IPictureShape>.ChangeName(IDictionary, XlsEventArgs)

CollectionExtended<IPictureShape>.Parent

CollectionExtended<IPictureShape>.Changed

CollectionBase<IPictureShape>.Insert(int, IPictureShape)

CollectionBase<IPictureShape>.GetEnumerator()

CollectionBase<IPictureShape>.RemoveAt(int)

CollectionBase<IPictureShape>.IndexOf(IPictureShape)

CollectionBase<IPictureShape>.Add(IPictureShape)

CollectionBase<IPictureShape>.Contains(IPictureShape)

CollectionBase<IPictureShape>.CopyTo(IPictureShape[], int)

CollectionBase<IPictureShape>.Remove(IPictureShape)

CollectionBase<IPictureShape>.Capacity

CollectionBase<IPictureShape>.Count

CollectionBase<IPictureShape>.InnerList

CollectionBase<IPictureShape>.List

CollectionBase<IPictureShape>.IsReadOnly

object.GetType()

object.MemberwiseClone()

object.ToString()

object.Equals(object)

object.Equals(object, object)

object.ReferenceEquals(object, object)

object.GetHashCode()

Properties

this[int]

public ExcelPicture this[int Index] { get; }

Parameters

Index int

Property Value

ExcelPicture

Methods

Add(Stream, string)

Adds picture to the collection.

public ExcelPicture Add(Stream image, string pictureName)

Parameters

image Stream

Picture to add.

pictureName string

Picture name.

Returns

ExcelPicture

Added picture.

Add(Stream, string, ImageFormatType)

public ExcelPicture Add(Stream image, string pictureName, ImageFormatType imageFormat)

Parameters

image Stream

pictureName string

imageFormat ImageFormatType

Returns

ExcelPicture

Add(int, int, SKBitmap)

public ExcelPicture Add(int topRow, int leftColumn, SKBitmap image)

Parameters

topRow int

leftColumn int

image SKBitmap

Returns

ExcelPicture

Add(int, int, SKBitmap, ImageFormatType)

public ExcelPicture Add(int topRow, int leftColumn, SKBitmap image, ImageFormatType imageFormat)

Parameters

topRow int

leftColumn int

image SKBitmap

imageFormat ImageFormatType

Returns

ExcelPicture

Add(int, int, Stream)

Adds image to the collection.

public ExcelPicture Add(int topRow, int leftColumn, Stream stream)

Parameters

topRow int

Top row of a new picture.

leftColumn int

Left column.

stream Stream

Stream object.

Returns

ExcelPicture

Added picture.

Add(int, int, Stream, ImageFormatType)

Adds image to the collection.

public ExcelPicture Add(int topRow, int leftColumn, Stream stream, ImageFormatType imageFormat)

Parameters

topRow int

Top row of a new picture.

leftColumn int

Left column.

stream Stream

Stream with the picture.

imageFormat ImageFormatType

Image format.

Returns

ExcelPicture

Added picture.

Add(int, int, Stream, int, int)

Adds image to the collection.

public ExcelPicture Add(int topRow, int leftColumn, Stream stream, int scaleWidth, int scaleHeight)

Parameters

topRow int

Top row of a new picture.

leftColumn int

Left column.

stream Stream

Stream with the picture.

scaleWidth int

Width scale in percents.

scaleHeight int

Height scale in percents.

Returns

ExcelPicture

Added picture.

Add(int, int, Stream, int, int, ImageFormatType)

Adds image to the collection.

public ExcelPicture Add(int topRow, int leftColumn, Stream stream, int scaleWidth, int scaleHeight, ImageFormatType imageFormat)

Parameters

topRow int

Top row of a new picture.

leftColumn int

Left column.

stream Stream

Stream with the picture.

scaleWidth int

Width scale in percents.

scaleHeight int

Height scale in percents.

imageFormat ImageFormatType

Image format.

Returns

ExcelPicture

Added picture.

Add(int, int, int, int, Stream)

Adds image to the collection.

public ExcelPicture Add(int topRow, int leftColumn, int bottomRow, int rightColumn, Stream stream)

Parameters

topRow int

Top row of a new picture.

leftColumn int

Left column.

bottomRow int

Bottom row.

rightColumn int

Right column.

stream Stream

Stream.

Returns

ExcelPicture

Added picture.

Add(int, int, int, int, Stream, ImageFormatType)

Adds image to the collection.

public ExcelPicture Add(int topRow, int leftColumn, int bottomRow, int rightColumn, Stream stream, ImageFormatType imageFormat)

Parameters

topRow int

Top row of a new picture.

leftColumn int

Left column.

bottomRow int

Bottom row.

rightColumn int

Right column.

stream Stream

Stream with the picture.

imageFormat ImageFormatType

Image format.

Returns

ExcelPicture

Added picture.

Add(int, int, int, int, string)

Adds image to the collection.

public ExcelPicture Add(int topRow, int leftColumn, int bottomRow, int rightColumn, string fileName)

Parameters

topRow int

Top row of a new picture.

leftColumn int

Left column.

bottomRow int

Bottom row.

rightColumn int

Right column.

fileName string

File name.

Returns

ExcelPicture

Added picture.

Add(int, int, int, int, string, ImageFormatType)

Adds image to the collection.

public ExcelPicture Add(int topRow, int leftColumn, int bottomRow, int rightColumn, string fileName, ImageFormatType imageFormat)

Parameters

topRow int

Top row of a new picture.

leftColumn int

Left column.

bottomRow int

Bottom row.

rightColumn int

Right column.

fileName string

File name.

imageFormat ImageFormatType

Image format.

Returns

ExcelPicture

Added picture.

Add(int, int, string)

Adds image to the collection.

public ExcelPicture Add(int topRow, int leftColumn, string fileName)

Parameters

topRow int

Top row of a new picture.

leftColumn int

Left column.

fileName string

File name.

Returns

ExcelPicture

Added picture.

Add(int, int, string, ImageFormatType)

Adds image to the collection.

public ExcelPicture Add(int topRow, int leftColumn, string fileName, ImageFormatType imageFormat)

Parameters

topRow int

Top row of a new picture.

leftColumn int

Left column.

fileName string

File name.

imageFormat ImageFormatType

Image format.

Returns

ExcelPicture

Added picture.

Add(int, int, string, int, int)

Adds image to the collection.

public ExcelPicture Add(int topRow, int leftColumn, string fileName, int scaleWidth, int scaleHeight)

Parameters

topRow int

Top row of a new picture.

leftColumn int

Left column.

fileName string

File name.

scaleWidth int

Width scale in percents.

scaleHeight int

Height scale in percents.

Returns

ExcelPicture

Added picture.

Add(int, int, string, int, int, ImageFormatType)

Adds image to the collection.

public ExcelPicture Add(int topRow, int leftColumn, string fileName, int scaleWidth, int scaleHeight, ImageFormatType imageFormat)

Parameters

topRow int

Top row of a new picture.

leftColumn int

Left column.

fileName string

Name of the shape.

scaleWidth int

Width scale in percents.

scaleHeight int

Height scale in percents.

imageFormat ImageFormatType

Image format to use for picture storing.

Returns

ExcelPicture

Added picture.

Add(string)

Adds picture from the specified file.

public ExcelPicture Add(string fileName)

Parameters

fileName string

File name.

Returns

ExcelPicture

Added picture.

Add(string, ImageFormatType)

Adds picture from the specified file.

public ExcelPicture Add(string fileName, ImageFormatType imageFormat)

Parameters

fileName string

imageFormat ImageFormatType

Image format.

Returns

ExcelPicture

Added picture.

AddLinkPic(int, int, int, int, string)

public ExcelPicture AddLinkPic(int topRow, int leftColumn, int height, int width, string linktarget)

Parameters

topRow int

leftColumn int

height int

width int

linktarget string

Returns

ExcelPicture