module Asposecellsjava::Document

Public Class Methods

new() click to toggle source
# File lib/asposecellsjava/document.rb, line 3
def initialize()
    # Accessing Document Properties
    get_properties()

    # Adding Custom Property
    add_custom_property()

    # Removing Custom Properties
    remove_custom_property()
end

Public Instance Methods

add_custom_property() click to toggle source
# File lib/asposecellsjava/document.rb, line 30
def add_custom_property()
    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')

    # Retrieve a list of all custom document properties of the Excel file
    #custom_properties = Rjb::import('java.util.ArrayList').new
    custom_properties = workbook.getWorksheets().getCustomDocumentProperties()

    # Adding a custom document property to the Excel file
    custom_properties.add("Publisher", "Aspose")

    # Save the document in PDF format
    workbook.save(data_dir + "Add_Property.xls")

    puts "Added custom property successfully."
end
get_properties() click to toggle source
# File lib/asposecellsjava/document.rb, line 14
def get_properties()
    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')

    # Retrieve a list of all custom document properties of the Excel file
    custom_properties = workbook.getWorksheets().getCustomDocumentProperties()

    # Accessng a custom document property by using the property index
    puts "Property By Index: " +  custom_properties.get(1).to_string

    # Accessng a custom document property by using the property name
    puts "Property By Name: " + custom_properties.get("Publisher").to_string
end
remove_custom_property() click to toggle source
# File lib/asposecellsjava/document.rb, line 49
def remove_custom_property()
    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')

    # Retrieve a list of all custom document properties of the Excel file
    custom_properties = workbook.getWorksheets().getCustomDocumentProperties()

    # Adding a custom document property to the Excel file
    custom_properties.remove("Publisher")

    # Save the document in PDF format
    workbook.save(data_dir + "Removed_Property.xls")

    puts "Removed custom property successfully."
end