Supprimer le contrôle ActiveX avec JavaScript via C++
Contents
[
Hide
]
Supprimer le contrôle ActiveX
Aspose.Cells offre la possibilité de supprimer un contrôle ActiveX des classeurs. Pour cela, l’API fournit la méthode Shape.removeActiveXControl(). L’extrait de code suivant démontre l’utilisation de la méthode Shape.removeActiveXControl() pour supprimer un contrôle ActiveX.
Code d’exemple
<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8" />
<title>Remove ActiveX Control Example</title>
</head>
<body>
<h1>Remove ActiveX Control 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, Utils } = 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');
const downloadLink = document.getElementById('downloadLink');
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();
// Instantiating a Workbook object from the uploaded file
const workbook = new Workbook(new Uint8Array(arrayBuffer));
// Accessing the first worksheet in the Excel file
const worksheet = workbook.worksheets.get(0);
// Access first shape from first worksheet
const shape = worksheet.shapes.get(0);
// Access ActiveX ComboBox Control and update its value / remove it
if (shape && shape.activeXControl != null) {
// Remove Shape ActiveX Control
shape.removeActiveXControl();
}
// Saving the modified Excel file
const outputData = workbook.save(SaveFormat.Xlsx);
const blob = new Blob([outputData]);
downloadLink.href = URL.createObjectURL(blob);
downloadLink.download = 'RemoveActiveXControl_our.xlsx';
downloadLink.style.display = 'block';
downloadLink.textContent = 'Download Modified Excel File';
resultDiv.innerHTML = '<p style="color: green;">ActiveX control removed (if present). Click the download link to get the modified file.</p>';
});
</script>
</html>