Managing Page Breaks in Python

Aspose.Cells - Managing Page Breaks

Adding Page Breaks

To add page breaks using Aspose.Cells Java for Python, call the add_page_breaks method of the pagebreaks module. Below is a code example.

Python Code

def add_page_breaks(self):
    # Instantiating a Workbook object
    workbook = self.Workbook(self.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 default (that is Excel 2003) format
    workbook.save(self.dataDir + "Add Page Breaks.xls")
    print "Add page breaks, please check the output file."

Clearing All Page Breaks

To clear all page breaks using Aspose.Cells Java for Python, call the clear_all_page_breaks method of the pagebreaks module. Below is a code example.

Python Code

def clear_all_page_breaks(self):
    # Instantiating a Workbook object
    workbook = self.Workbook(self.dataDir + "Book1.xls")

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

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

Removing Specific Page Break

To remove a specific page break using Aspose.Cells Java for Python, call the remove_page_break method of the pagebreaks module. Below is a code example.

Python Code

def remove_page_break(self):
    # Instantiating a Workbook object
    workbook = self.Workbook(self.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 default (that is Excel 2003) format
    workbook.save(self.dataDir + "Remove Page Break.xls")
    print "Remove page break, please check the output file."

Download Running Code

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

• GitHub