AddOleObject

AddOleObject(sImageSrc, nWidth, nHeight, sData, sAppId, nFromCol, nColOffset, nFromRow, nRowOffset) → { ApiOleObject }

Adds an OLE object to the current sheet with the parameters specified.

Parameters:

Name Type Description
sImageSrc string

The image source where the image to be inserted should be taken from (currently, only internet URL or Base64 encoded images are supported).

nWidth EMU

The OLE object width in English measure units.

nHeight EMU

The OLE object height in English measure units.

sData string

The OLE object string data.

sAppId string

The application ID associated with the current OLE object.

nFromCol number

The number of the column where the beginning of the OLE object will be placed.

nColOffset EMU

The offset from the nFromCol column to the left part of the OLE object measured in English measure units.

nFromRow number

The number of the row where the beginning of the OLE object will be placed.

nRowOffset EMU

The offset from the nFromRow row to the upper part of the OLE object measured in English measure units.

Returns:

Type
ApiOleObject

Example

Copy code
builder.CreateFile("xlsx");
var oWorksheet = Api.GetActiveSheet();
oWorksheet.AddOleObject("https://api.onlyoffice.com/content/img/docbuilder/examples/ole-object-image.png", 130 * 36000, 90 * 36000, "https://youtu.be/SKGz4pmnpgY", "asc.{38E022EA-AD92-45FC-B22B-49DF39746DB4}", 0, 2 * 36000, 4, 3 * 36000);
builder.SaveFile("xlsx", "AddOleObject.xlsx");
builder.CloseFile();

Resulting document