Module: Asposecellsjava::PageBreaks

Defined in:
lib/asposecellsjava/pagebreaks.rb

Instance Method Summary collapse

Instance Method Details

#add_page_breaks(workbook) ⇒ Object 



19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
 
# 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) ⇒ Object 



35
36
37
38
39
40
41
42
43
 
# 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

#initialize ⇒ Object 



3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
 
# 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

#remove_page_break(workbook) ⇒ Object 



45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
 
# 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