module Asposecellsjava::PageBreaks
Public Class Methods
new()
click to toggle source
# File lib/asposecellsjava/pagebreaks.rb, line 3 def initialize() @data_dir = File.dirname(File.dirname(File.dirname(__FILE__))) + '/data/' # Instantiating a Workbook object workbook = Rjb::import('com.aspose.cells.Workbook').new # Adding Page Breaks add_page_breaks(workbook) # Clearing All Page Breaks clear_all_page_breaks(workbook) # Removing Specific Page Break remove_page_break(workbook) end
Public Instance Methods
add_page_breaks(workbook)
click to toggle source
# File lib/asposecellsjava/pagebreaks.rb, line 19 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
clear_all_page_breaks(workbook)
click to toggle source
# File lib/asposecellsjava/pagebreaks.rb, line 35 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
remove_page_break(workbook)
click to toggle source
# File lib/asposecellsjava/pagebreaks.rb, line 45 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