Skip to content

Instantly share code, notes, and snippets.

@aspose-com-kb

aspose-com-kb/How to Delete Pivot Table in Excel using Python.py

Last active July 16, 2023 16:51
Download ZIP

Revisions

  1. aspose-com-kb revised this gist Jul 16, 2023. No changes.
  2. aspose-com-kb created this gist Jul 14, 2023.
    30 changes: 30 additions & 0 deletions How to Delete Pivot Table in Excel using Python.py
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,30 @@
    import jpype
    import asposecells
    jpype.startJVM()
    from asposecells.api import License, Workbook

    # Instantiate the license
    license = License()
    license.setLicense("Aspose.Total.lic")

    # Create a workbook object from the source Excel file
    workbook = Workbook("pivotTable.xls")

    # Access the first worksheet
    worksheet = workbook.getWorksheets().get(0)

    # Access the first pivot table object
    pivotTable = worksheet.getPivotTables().get(0)

    # Remove the pivot table using the pivot table object
    worksheet.getPivotTables().remove(pivotTable)

    # Second option is to delete the pivot table using its index
    # worksheet.getPivotTables().removeAt(0);

    # Save the workbook
    workbook.save("output_out.xlsx")

    print("Pivot Table removed successfully")

    jpype.shutdownJVM()