Module: Asposecellsjava::Protection

Defined in:
lib/asposecellsjava/protection.rb

Instance Method Summary collapse

Instance Method Details

#initialize ⇒ Object 



3
4
5
6
7
8
9
 
# File 'lib/asposecellsjava/protection.rb', line 3

def initialize()
    # Proctect a Worksheet
    protect_worksheet()

    # Unproctect a Worksheet
    unprotect_worksheet()
end

#protect_worksheet ⇒ Object 



11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
 
# File 'lib/asposecellsjava/protection.rb', line 11

def protect_worksheet()
    data_dir = File.dirname(File.dirname(File.dirname(__FILE__))) + '/data/'
    
    # Instantiating a Workbook object by excel file path
    workbook = Rjb::import('com.aspose.cells.Workbook').new(data_dir + 'Book1.xls')
    
    # Accessing the first worksheet in the Excel file
    worksheets = workbook.getWorksheets()
    worksheet = worksheets.get(0)

    protection = worksheet.getProtection()

    # The following 3 methods are only for Excel 2000 and earlier formats
    protection.setAllowEditingContent(false)
    protection.setAllowEditingObject(false)
    protection.setAllowEditingScenario(false)

    # Protects the first worksheet with a password "1234"
    protection.setPassword("1234")
    
    # Saving the modified Excel file in default (that is Excel 2003) format
    workbook.save(data_dir + "Protect Worksheet.xls")

    puts "Protect a Worksheet, please check the output file."
end

#unprotect_worksheet ⇒ Object 



37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
 
# File 'lib/asposecellsjava/protection.rb', line 37

def unprotect_worksheet()
    data_dir = File.dirname(File.dirname(File.dirname(__FILE__))) + '/data/'
    
    # Instantiating a Workbook object by excel file path
    workbook = Rjb::import('com.aspose.cells.Workbook').new(data_dir + 'Book1.xls')
    
    # Accessing the first worksheet in the Excel file
    worksheets = workbook.getWorksheets()
    worksheet = worksheets.get(0)

    protection = worksheet.getProtection()

    # The following 3 methods are only for Excel 2000 and earlier formats
    protection.setAllowEditingContent(false)
    protection.setAllowEditingObject(false)
    protection.setAllowEditingScenario(false)

    # Unprotecting the worksheet with a password
    worksheet.unprotect("1234")
    
    # Saving the modified Excel file in default (that is Excel 2003) format
    workbook.save(data_dir + "Unprotect Worksheet.xls")

    puts "Unprotect a Worksheet, please check the output file."
end