Update ActiveX ComboBox Control with JavaScript via C++
Contents
[
Hide
]
Possible Usage Scenarios
You can read or write the values of ActiveX ComboBox Control using Aspose.Cells for JavaScript via C++. Please access the ActiveX Control via Shape.activeXControl property and check its type via ActiveXControlBase.type property, it should return ControlType.ComboBox value and then typecast it into ComboBoxActiveXControl object and read or modify its various properties.
Please download the sample excel file used in the following sample code.
Update ActiveX ComboBox Control
The following screenshot shows the effect of the sample code on the sample excel file. As you can see, the ActiveX ComboBox value has been updated to “This is combo box control”.
 |
|---|
Sample Code
The following sample code updates the value of ActiveX ComboBox Control present inside the sample excel file.
<!DOCTYPE html>
<html>
<head>
<title>Aspose.Cells Example - Update ActiveX ComboBox</title>
</head>
<body>
<h1>Update ActiveX ComboBox in Workbook</h1>
<input type="file" id="fileInput" accept=".xls,.xlsx,.xlsm" />
<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');
if (!fileInput.files.length) {
document.getElementById('result').innerHTML = '<p style="color: red;">Please select an Excel file.</p>';
return;
}
const file = fileInput.files[0];
const arrayBuffer = await file.arrayBuffer();
// Instantiate a Workbook from the uploaded file
const workbook = new Workbook(new Uint8Array(arrayBuffer));
// Access first worksheet and first shape
const worksheet = workbook.worksheets.get(0);
const shape = worksheet.shapes.get(0);
// Access ActiveX ComboBox Control and update its value
if (shape.activeXControl != null) {
const c = shape.activeXControl;
if (c instanceof AsposeCells.ComboBoxActiveXControl) {
// Type cast ActiveXControl into ComboBoxActiveXControl and change its value
const comboBoxActiveX = new AsposeCells.ComboBoxActiveXControl(c);
comboBoxActiveX.value = "This is combo box control with updated value.";
}
}
// Save the workbook and provide download link
const outputData = workbook.save(SaveFormat.Xlsx);
const blob = new Blob([outputData]);
const downloadLink = document.getElementById('downloadLink');
downloadLink.href = URL.createObjectURL(blob);
downloadLink.download = 'OutputFile_out.xlsx';
downloadLink.style.display = 'block';
downloadLink.textContent = 'Download Modified Excel File';
document.getElementById('result').innerHTML = '<p style="color: green;">Operation completed successfully! Click the download link to get the modified file.</p>';
});
</script>
</html>