Access and Modify the Display Label of the Linked Ole Object with JavaScript via C++
Contents
[
Hide
]
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
<!DOCTYPE html>
<html>
<head>
<title>Aspose.Cells Example</title>
</head>
<body>
<h1>Access and Modify Label of Ole Object Example</h1>
<input type="file" id="fileInput" accept=".xls,.xlsx,.csv" />
<button id="runExample">Run Example</button>
<a id="downloadLink" style="display: none;">Download Result</a>
<div id="result"></div>
</body>
<script src="aspose.cells.js.min.js"></script>
<script type="text/javascript">
const { Workbook, SaveFormat } = AsposeCells;
AsposeCells.onReady({
license: "/lic/aspose.cells.enc",
fontPath: "/fonts/",
fontList: [
"arial.ttf",
"NotoSansSC-Regular.ttf"
]
}).then(() => {
console.log("Aspose.Cells initialized");
});
document.getElementById('runExample').addEventListener('click', async () => {
const fileInput = document.getElementById('fileInput');
const resultDiv = document.getElementById('result');
resultDiv.innerHTML = '';
if (!fileInput.files.length) {
resultDiv.innerHTML = '<p style="color: red;">Please select an Excel file.</p>';
return;
}
const file = fileInput.files[0];
const arrayBuffer = await file.arrayBuffer();
// Load the sample Excel file
const wb = new Workbook(new Uint8Array(arrayBuffer));
// Access first worksheet
const ws = wb.worksheets.get(0);
// Access first Ole Object
let oleObject = ws.oleObjects.get(0);
// Display the Label of the Ole Object
const beforeLabel = oleObject.label;
console.log("Ole Object Label - Before: " + beforeLabel);
// Modify the Label of the Ole Object
oleObject.label = "Aspose APIs";
// Save workbook to memory stream
const ms = wb.save(SaveFormat.Xlsx);
// Set the workbook reference to null / dispose
wb.dispose();
// Load workbook from memory stream
const wbFromStream = new Workbook(ms);
// Access first worksheet
const wsFromStream = wbFromStream.worksheets.get(0);
// Access first Ole Object
oleObject = wsFromStream.oleObjects.get(0);
// Display the Label of the Ole Object that has been modified earlier
const afterLabel = oleObject.label;
console.log("Ole Object Label - After: " + afterLabel);
// Prepare download
const blob = new Blob([ms]);
const downloadLink = document.getElementById('downloadLink');
downloadLink.href = URL.createObjectURL(blob);
downloadLink.download = 'modified.xlsx';
downloadLink.style.display = 'block';
downloadLink.textContent = 'Download Modified Excel File';
resultDiv.innerHTML = `<p style="color: green;">Operation completed successfully!</p>
<p>Ole Object Label - Before: ${beforeLabel}</p>
<p>Ole Object Label - After: ${afterLabel}</p>`;
});
</script>
</html>
Console Output
Ole Object Label - Before: Sample APIs
Ole Object Label - After: Aspose APIs