访问和修改链接 Ole 对象的显示标签

可能的使用场景

Microsoft Excel 允许您更改 Ole 对象的显示标签，如以下屏幕截图所示。您还可以使用 Aspose.Cells API 访问或修改 Ole 对象的显示标签OleObject.标签财产。

访问和修改链接 Ole 对象的显示标签

请看下面的示例代码，它加载了示例 Excel 文件包含 Ole 对象。该代码访问 Ole 对象并将其标签从示例 API 更改为 Aspose API。请查看下面给出的控制台输出，其中显示了示例代码对示例 Excel 文件的影响，以供参考。

示例代码

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

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

//Access first worksheet
Worksheet ws = wb.getWorksheets().get(0);

//Access first Ole Object
OleObject oleObject = ws.getOleObjects().get(0);

//Display the Label of the Ole Object
System.out.println("Ole Object Label - Before: " + oleObject.getLabel());

//Modify the Label of the Ole Object
oleObject.setLabel("Aspose APIs");

//Save workbook to byte array output stream
ByteArrayOutputStream baos = new ByteArrayOutputStream();
wb.save(baos, SaveFormat.XLSX);

//Convert output to input stream
ByteArrayInputStream bais = new ByteArrayInputStream(baos.toByteArray());

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

//Load workbook from byte array input stream
wb = new Workbook(bais);

//Access first worksheet
ws = wb.getWorksheets().get(0);

//Access first Ole Object
oleObject = ws.getOleObjects().get(0);

//Display the Label of the Ole Object that has been modified earlier
System.out.println("Ole Object Label - After: " + oleObject.getLabel());

控制台输出

Ole Object Label - Before: Sample APIs

Ole Object Label - After: Aspose APIs