AddOleObject
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://i.ytimg.com/vi_webp/SKGz4pmnpgY/sddefault.webp", 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