Skip to main content

GetData

Returns the string data from the current OLE object.

Syntax​

expression.GetData();

expression - A variable that represents a ApiOleObject class.

Parameters​

This method doesn't have any parameters.

Returns​

string

Example​

Read the content stored inside an embedded object in a spreadsheet.

// How do I retrieve the data held by an embedded object in a spreadsheet?

// Extract the stored value from an embedded object to display or reuse it in a spreadsheet.

let worksheet = Api.GetActiveSheet();
let oleObject = worksheet.AddOleObject(
	'https://static.onlyoffice.com/assets/docs/samples/img/onlyoffice_logo.png',
	60 * 36000, 60 * 36000,
	'https://youtu.be/SKGz4pmnpgY',
	'asc.{38E022EA-AD92-45FC-B22B-49DF39746DB4}',
	0, 2 * 36000, 4, 3 * 36000
);
let data = oleObject.GetData();
worksheet.GetRange('A1').SetValue('The OLE object data: ' + data);