OleObjectCollection.AddLinkedOleObject(Single, Single, Single, Single, String, OleObjectType, SpreadsheetImageSource) Method

Inserts a linked OLE object from a file into the specified position.

Namespace: DevExpress.Spreadsheet

Assembly: DevExpress.Spreadsheet.v25.1.Core.dll

NuGet Package: DevExpress.Spreadsheet.Core

Declaration

C#

OleObject AddLinkedOleObject(
    float x,
    float y,
    float width,
    float height,
    string fileName,
    OleObjectType oleObjectType,
    SpreadsheetImageSource objectRepresentation = null
)

VB.NET

Function AddLinkedOleObject(
    x As Single,
    y As Single,
    width As Single,
    height As Single,
    fileName As String,
    oleObjectType As OleObjectType,
    objectRepresentation As SpreadsheetImageSource = Nothing
) As OleObject

Parameters

Name	Type	Description
x	Single	The horizontal coordinate of the OLE object’s image top-left corner, in pixels. The origin point (0,0) is the worksheet’s top-left corner.
y	Single	The vertical coordinate of the OLE object’s image top-left corner, in pixels. The origin point (0,0) is the worksheet’s top-left corner.
width	Single	The OLE object’s image width.
height	Single	The OLE object’s image height.
fileName	String	A path (including the file name) of the file to link.
oleObjectType	OleObjectType	OLE object content type.

Optional Parameters

Name	Type	Default	Description
objectRepresentation	SpreadsheetImageSource	null	Specifies the image to depict the OLE object on the worksheet. If null, a white boilerplate image is used.

Returns

Type	Description
OleObject	The created OLE object.