How to Delete Pivot Table from Excel Sheet in Python

delete-pivot-table-from-excel-in-python.md

Learn How to Delete Pivot Table from Excel Sheet in Python

delete-pivot-table-from-excel-in-python_code.py

from aspose.cells import Workbook

# Load the Excel workbook
workbook = Workbook("sample1.xlsx")

# Access the first worksheet
worksheet = workbook.worksheets[0]

# Access the Pivot Table collection
pivot_tables = worksheet.pivot_tables

# Access the Pivot Table
pivot_table = worksheet.pivot_tables[0]

# Remove the first Pivot Table
pivot_tables.remove_pivot_table(pivot_table)

# Save the updated workbook
workbook.save("pivot_table_deleted.xlsx")