Managing Page Breaks in Jython

Aspose.Cells - Managing Page Breaks

To manage page breaks using Aspose.Cells Java for Jython. Below is example code.

Jython Code

  

```java
from asposecells import Settings

from com.aspose.cells import Workbook
from com.aspose.cells import SaveFormat


class ManagingPageBreaks:

    def __init__(self):
        # Adding Page Breaks
        self.add_page_breaks()
        # Clearing All Page Breaks
        self.clear_all_page_breaks()
        # Removing Specific Page Break
        self.remove_page_break()


    def add_page_breaks(dataDir):
        dataDir = Settings.dataDir + 'WorkingWithWorksheets/ManagingPageBreaks/'

        # Instantiating a Workbook object
        workbook = Workbook(dataDir + "Book1.xls")

        worksheets = workbook.getWorksheets()
        worksheet = worksheets.get(0)

        h_page_breaks = worksheet.getHorizontalPageBreaks()
        h_page_breaks.add("Y30")

        v_page_breaks = worksheet.getVerticalPageBreaks()
        v_page_breaks.add("Y30")

        # Saving the modified Excel file in the default (Excel 2003) format
        workbook.save(dataDir + "Add Page Breaks.xls")
        print "Added page breaks; please check the output file."


    def clear_all_page_breaks(dataDir):
        dataDir = Settings.dataDir + 'WorkingWithWorksheets/ManagingPageBreaks/'

        # Instantiating a Workbook object
        workbook = Workbook(dataDir + "Book1.xls")

        workbook.getWorksheets().get(0).getHorizontalPageBreaks().clear()
        workbook.getWorksheets().get(0).getVerticalPageBreaks().clear()

        # Saving the modified Excel file in the default (Excel 2003) format
        workbook.save(dataDir + "Clear All Page Breaks.xls")
        print "Cleared all page breaks; please check the output file."


    def remove_page_break(dataDir):
        dataDir = Settings.dataDir + 'WorkingWithWorksheets/ManagingPageBreaks/'

        # Instantiating a Workbook object
        workbook = Workbook(dataDir + "Book1.xls")
        worksheets = workbook.getWorksheets()
        worksheet = worksheets.get(0)

        h_page_breaks = worksheet.getHorizontalPageBreaks()
        h_page_breaks.removeAt(0)

        v_page_breaks = worksheet.getVerticalPageBreaks()
        v_page_breaks.removeAt(0)

        # Saving the modified Excel file in the default (Excel 2003) format
        workbook.save(dataDir + "Remove Page Break.xls")
        print "Removed page break; please check the output file."


if __name__ == '__main__':
    ManagingPageBreaks()
```  

Download Running Code

Download Managing Page Breaks (Aspose.Cells) from any of the below‑mentioned social coding sites:

• GitHub