Rimuovi controlli ActiveX con JavaScript tramite C++
Contents
[
Hide
]
Rimuovi controllo ActiveX
Aspose.Cells fornisce la possibilità di rimuovere il controllo ActiveX dai workbook. Per farlo, l’API offre il metodo Shape.removeActiveXControl(). Il seguente esempio di codice dimostra l’uso del metodo Shape.removeActiveXControl() per rimuovere il controllo ActiveX.
Codice di Esempio
<!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>