Delete Pivot Table from a Worksheet
Contents
[
Hide
]
Aspose.Cells for JavaScript via C++ provides a feature to delete or remove a pivot table from a worksheet. You can delete the pivot table using a pivot‑table object or its position. Please use the Worksheet.pivotTables.remove(pivotTable) method to delete the pivot table using a pivot‑table object and the Worksheet.pivotTables.removeAt(index, keepData) method to delete the pivot table using its position inside the pivot‑table collection.
How to Delete Pivot Table from Worksheet Using Aspose.Cells for JavaScript via C++
The following sample code deletes two pivot tables from the worksheet. First it removes the pivot table using the Worksheet.pivotTables.remove(pivotTable) method, and then it removes the pivot table using the Worksheet.pivotTables.removeAt(index, keepData) method.
<!DOCTYPE html>
<html>
<head>
<title>Aspose.Cells Example - Remove Pivot Table</title>
</head>
<body>
<h1>Remove Pivot Table 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');
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 Workbook from uploaded file
const workbook = new Workbook(new Uint8Array(arrayBuffer));
// Access the first worksheet
const worksheet = workbook.worksheets.get(0);
// Access the first pivot table object
const pivotTable = worksheet.pivotTables.get(0);
// Remove pivot table using pivot table object
worksheet.pivotTables.remove(pivotTable);
// OR remove by index:
// worksheet.pivotTables.removeAt(0);
// Saving the modified workbook
const outputData = workbook.save(SaveFormat.Xlsx);
const blob = new Blob([outputData]);
const downloadLink = document.getElementById('downloadLink');
downloadLink.href = URL.createObjectURL(blob);
downloadLink.download = 'output_out.xlsx';
downloadLink.style.display = 'block';
downloadLink.textContent = 'Download Modified Excel File';
document.getElementById('result').innerHTML = '<p style="color: green;">Pivot table removed successfully! Click the download link to get the modified file.</p>';
});
</script>
</html>