Managing Page Breaks in Ruby

Aspose.Cells - Managing Page Breaks

Adding Page Breaks

To add page breaks using Aspose.Cells Java for Ruby, call the add_page_breaks method of the pagebreaks module. Below you can see a 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 the 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 the clear_all_page_breaks method of the pagebreaks module. Below you can see a 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 the 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  

Removing Specific Page Break

To remove a specific page break using Aspose.Cells Java for Ruby, call the remove_page_break method of the pagebreaks module. Below you can see a 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 the 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