Access and Modify the Display Label of the Linked Ole Object

Possible Usage Scenarios

Microsoft Excel allows you to change the display label of the Ole Object as shown in the following screenshot. You can also access or modify the display label of the Ole object using Aspose.Cells APIs with the OleObject.Label property.

Access and Modify the Display Label of the Linked Ole Object

Please see the following sample code, it loads the sample Excel file that contains the Ole Object. The code accesses the Ole Object and changes its Label from Sample APIs to Aspose APIs. Please see the console output given below that shows the effect of the sample code on the sample Excel file for a reference.

Sample Code

// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET

//Load the sample Excel file 
Workbook wb = new Workbook("sampleAccessAndModifyLabelOfOleObject.xlsx");

//Access first worksheet
Worksheet ws = wb.Worksheets[0];

//Access first Ole Object
Aspose.Cells.Drawing.OleObject oleObject = ws.OleObjects[0];

//Display the Label of the Ole Object
Console.WriteLine("Ole Object Label - Before: " + oleObject.Label);

//Modify the Label of the Ole Object
oleObject.Label = "Aspose APIs";

//Save workbook to memory stream
MemoryStream ms = new MemoryStream();
wb.Save(ms, SaveFormat.Xlsx);

//Set the workbook reference to null
wb = null;

//Load workbook from memory stream
wb = new Workbook(ms);

//Access first worksheet
ws = wb.Worksheets[0];

//Access first Ole Object
oleObject = ws.OleObjects[0];

//Display the Label of the Ole Object that has been modified earlier
Console.WriteLine("Ole Object Label - After: " + oleObject.Label);

Console Output

Ole Object Label - Before: Sample APIs

Ole Object Label - After: Aspose APIs