AddOleObject

function AddOleObject(
  sImageSrc: string = null,
  nWidth: EMU = null,
  nHeight: EMU = null,
  sData: string = null,
  sAppId: string = null,
  nFromCol: number = null,
  nColOffset: EMU = null,
  nFromRow: number = null,
  nRowOffset: EMU = null,
): ApiOleObject

Description

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

Parameters

sImageSrcstringdefault: null

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

nWidthEMUdefault: null

The OLE object width in English measure units.

nHeightEMUdefault: null

The OLE object height in English measure units.

sDatastringdefault: null

The OLE object string data.

sAppIdstringdefault: null

The application ID associated with the current OLE object.

nFromColnumberdefault: null

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

nColOffsetEMUdefault: null

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

nFromRownumberdefault: null

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

nRowOffsetEMUdefault: null

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

Returns

ApiOleObject

Try It

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);

Get Help

  • If you have any questions about ONLYOFFICE Docs, try the FAQ section first.
  • You can request a feature or report a bug by posting an issue on GitHub.
  • You can also ask our developers on ONLYOFFICE forum (registration required).