GetAllOleObjects
Returns all OLE objects from the current sheet.
Parameters:
This method doesn't have any parameters.
Returns:
- Type
-
Array.<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);
var aOleObjects = oWorksheet.GetAllOleObjects();
var sAppId = aOleObjects[0].GetApplicationId();
oWorksheet.GetRange("A1").SetValue("The application ID for the current OLE object: " + sAppId);
builder.SaveFile("xlsx", "GetAllOleObjects.xlsx");
builder.CloseFile();
Resulting document