Managing Page Breaks in Ruby

Aspose.Cells - Managing Page Breaks

Adding Page Breaks

To add page breaks using Aspose.Cells Java for Ruby, call add_page_breaks method of pagebreaks module. Below you can see code example.

Ruby Code

 def add_page_breaks(workbook)

    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(@data_dir + "Add Page Breaks.xls")

    puts "Add page breaks, please check the output file."

end   

Clearing All Page Breaks

To clear all page breaks using Aspose.Cells Java for Ruby, call clear_all_page_breaks method of pagebreaks module. Below you can see code example.

Ruby Code

 def clear_all_page_breaks(workbook)

    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(@data_dir + "Clear All Page Breaks.xls")

    puts "Clear all page breaks, please check the output file."

end 

Removeing Specific Page Break

To remove specific page break using Aspose.Cells Java for Ruby, call remove_page_break method of pagebreaks module. Below you can see code example.

Ruby Code

 def remove_page_break(workbook)

    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(@data_dir + "Remove Page Break.xls")

    puts "Remove page break, please check the output file."

end 

Download Running Code

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

• GitHub