Interface IXLPicture

Namespace

SlapKit.Excel.Excel.Drawings

Assembly

SlapKit.Excel.dll

public interface IXLPicture : IDisposable

Inherited Members

IDisposable.Dispose()

Extension Methods

AttributeExtensions.GetMethod<T>(T, Expression<Action<T>>)

AttributeExtensions.GetMethod<T>(T, Expression<Func<T, object>>)

Properties

BottomRightCell

IXLCell BottomRightCell { get; }

Property Value

IXLCell

Format

Type of image. The supported formats are defined by OpenXML's ImagePartType. Default value is "jpeg"

XLPictureFormat Format { get; }

Property Value

XLPictureFormat

Height

Current height of the picture in pixels.

int Height { get; set; }

Property Value

int

Id

int Id { get; }

Property Value

int

ImageStream

MemoryStream ImageStream { get; }

Property Value

MemoryStream

Left

int Left { get; set; }

Property Value

int

Name

string Name { get; set; }

Property Value

string

OriginalHeight

Original height of the picture in pixels.

int OriginalHeight { get; }

Property Value

int

OriginalWidth

Original width of the picture in pixels.

int OriginalWidth { get; }

Property Value

int

Placement

XLPicturePlacement Placement { get; set; }

Property Value

XLPicturePlacement

Sheet

IXLSheet Sheet { get; }

Property Value

IXLSheet

Top

int Top { get; set; }

Property Value

int

TopLeftCell

IXLCell TopLeftCell { get; }

Property Value

IXLCell

Width

Current width of the picture in pixels.

int Width { get; set; }

Property Value

int

Worksheet

IXLWorksheet Worksheet { get; }

Property Value

IXLWorksheet

Methods

CopyTo(IXLSheet)

Create a copy of the picture on a different sheet.

IXLPicture CopyTo(IXLSheet targetSheet)

Parameters

targetSheet IXLSheet

The sheet to which the picture will be copied.

Returns

IXLPicture

A created copy of the picture.

CopyTo(IXLWorksheet)

Create a copy of the picture on a different worksheet.

IXLPicture CopyTo(IXLWorksheet targetSheet)

Parameters

targetSheet IXLWorksheet

The worksheet to which the picture will be copied.

Returns

IXLPicture

A created copy of the picture.

Delete()

Deletes this picture.

void Delete()

Duplicate()

Create a copy of the picture on the same worksheet.

IXLPicture Duplicate()

Returns

IXLPicture

A created copy of the picture.

GetOffset(XLMarkerPosition)

Point GetOffset(XLMarkerPosition position)

Parameters

position XLMarkerPosition

Returns

Point

MoveTo(IXLCell)

IXLPicture MoveTo(IXLCell cell)

Parameters

cell IXLCell

Returns

IXLPicture

MoveTo(IXLCell, IXLCell)

IXLPicture MoveTo(IXLCell fromCell, IXLCell toCell)

Parameters

fromCell IXLCell

toCell IXLCell

Returns

IXLPicture

MoveTo(IXLCell, Point)

IXLPicture MoveTo(IXLCell cell, Point offset)

Parameters

cell IXLCell

offset Point

Returns

IXLPicture

MoveTo(IXLCell, Point, IXLCell, Point)

IXLPicture MoveTo(IXLCell fromCell, Point fromOffset, IXLCell toCell, Point toOffset)

Parameters

fromCell IXLCell

fromOffset Point

toCell IXLCell

toOffset Point

Returns

IXLPicture

MoveTo(IXLCell, int, int)

IXLPicture MoveTo(IXLCell cell, int xOffset, int yOffset)

Parameters

cell IXLCell

xOffset int

yOffset int

Returns

IXLPicture

MoveTo(IXLCell, int, int, IXLCell, int, int)

IXLPicture MoveTo(IXLCell fromCell, int fromCellXOffset, int fromCellYOffset, IXLCell toCell, int toCellXOffset, int toCellYOffset)

Parameters

fromCell IXLCell

fromCellXOffset int

fromCellYOffset int

toCell IXLCell

toCellXOffset int

toCellYOffset int

Returns

IXLPicture

MoveTo(int, int)

IXLPicture MoveTo(int left, int top)

Parameters

left int

top int

Returns

IXLPicture

Scale(double, bool)

IXLPicture Scale(double factor, bool relativeToOriginal = false)

Parameters

factor double

relativeToOriginal bool

Returns

IXLPicture

ScaleHeight(double, bool)

IXLPicture ScaleHeight(double factor, bool relativeToOriginal = false)

Parameters

factor double

relativeToOriginal bool

Returns

IXLPicture

ScaleWidth(double, bool)

IXLPicture ScaleWidth(double factor, bool relativeToOriginal = false)

Parameters

factor double

relativeToOriginal bool

Returns

IXLPicture

WithPlacement(XLPicturePlacement)

IXLPicture WithPlacement(XLPicturePlacement value)

Parameters

value XLPicturePlacement

Returns

IXLPicture

WithSize(int, int)

IXLPicture WithSize(int width, int height)

Parameters

width int

height int

Returns

IXLPicture