class Aspose::Cloud::Cells::Workbook
Public Class Methods
new(filename)
click to toggle source
# File lib/Cells/workbook.rb, line 5 def initialize filename @filename = filename end
Public Instance Methods
add_worksheet(worksheet_name='')
click to toggle source
# File lib/Cells/workbook.rb, line 376 def add_worksheet worksheet_name='' begin if @filename == '' raise 'Base file name not specified' end str_uri = $product_uri + '/cells/' + @filename + '/worksheets/' + worksheet_name signed_uri = Aspose::Cloud::Common::Utils.sign(str_uri) response = RestClient.put(signed_uri, '',:accept => 'application/json') json = JSON.parse(response) if json['Code']==201 return true else return false end rescue Exception=>e print e end end
clear_modify_password(password='')
click to toggle source
# File lib/Cells/workbook.rb, line 331 def clear_modify_password password='' begin if @filename == '' raise 'Base file name not specified' end fields_array = Hash.new fields_array['Password'] = password json_data = fields_array.to_json str_uri = $product_uri + '/cells/' + @filename + '/writeProtection' signed_uri = Aspose::Cloud::Common::Utils.sign(str_uri) response = RestClient.delete(signed_uri,json_data, json_data,:accept => 'application/json') json = JSON.parse(response) if json['Code']==200 return true else return false end rescue Exception=>e print e end end
create_empty_workbook()
click to toggle source
# File lib/Cells/workbook.rb, line 131 def create_empty_workbook begin str_uri = $product_uri + '/cells/' + @filename signed_uri = Aspose::Cloud::Common::Utils.sign(str_uri) response = RestClient.put(signed_uri,'', :accept => 'application/json') json = JSON.parse(response) return json rescue Exception=>e print e end end
create_workbook_from_smart_marker_template(template_file_name ='',data_file='')
click to toggle source
# File lib/Cells/workbook.rb, line 160 def create_workbook_from_smart_marker_template template_file_name ='',data_file='' begin if template_file_name == '' raise 'Template file not specified' end if data_file == '' raise 'Data file not specified' end str_uri = $product_uri + '/cells/' + @filename + '?templatefile=' + template_file_name + '&dataFile=' + data_file signed_uri = Aspose::Cloud::Common::Utils.sign(str_uri) response = RestClient.put(signed_uri,'', :accept => 'application/json') json = JSON.parse(response) return json rescue Exception=>e print e end end
create_workbook_from_template(template_file_name)
click to toggle source
# File lib/Cells/workbook.rb, line 144 def create_workbook_from_template template_file_name begin if template_file_name == '' raise 'Template file not specified' end str_uri = $product_uri + '/cells/' + @filename + '?templatefile=' + template_file_name signed_uri = Aspose::Cloud::Common::Utils.sign(str_uri) response = RestClient.put(signed_uri,'', :accept => 'application/json') json = JSON.parse(response) return json rescue Exception=>e print e end end
decrypt_password(password)
click to toggle source
# File lib/Cells/workbook.rb, line 354 def decrypt_password password begin if @filename == '' raise 'Base file name not specified' end fields_array = Hash.new fields_array['Password'] = password json_data = fields_array.to_json str_uri = $product_uri + '/cells/' + @filename + '/encryption' signed_uri = Aspose::Cloud::Common::Utils.sign(str_uri) response = RestClient.delete(signed_uri,json_data,:accept => 'application/json') json = JSON.parse(response) if json['Code']==200 return true else return false end rescue Exception=>e print e end end
encrypt_workbook(encryption_type='XOR',password='',key_length='')
click to toggle source
# File lib/Cells/workbook.rb, line 240 def encrypt_workbook encryption_type='XOR',password='',key_length='' begin if @filename == '' raise 'Base file name not specified' end fields_array = Hash.new fields_array['EncriptionType'] = encryption_type fields_array['KeyLength'] = key_length fields_array['Password'] = password json_data = fields_array.to_json str_uri = $product_uri + '/cells/' + @filename + '/encryption' signed_uri = Aspose::Cloud::Common::Utils.sign(str_uri) response = RestClient.post(signed_uri, json_data,:accept => 'application/json') json = JSON.parse(response) if json['Code']==200 return true else return false end rescue Exception=>e print e end end
get_default_style()
click to toggle source
# File lib/Cells/workbook.rb, line 225 def get_default_style begin if @filename == '' raise 'Base file name not specified' end str_uri = $product_uri + '/cells/' + @filename + '/defaultStyle' signed_uri = Aspose::Cloud::Common::Utils.sign(str_uri) response = RestClient.get(signed_uri, :accept => 'application/json') json = JSON.parse(response) return json['Style'] rescue Exception=>e print e end end
get_name_count()
click to toggle source
# File lib/Cells/workbook.rb, line 210 def get_name_count begin if @filename == '' raise 'Base file name not specified' end str_uri = $product_uri + '/cells/' + @filename + '/names' signed_uri = Aspose::Cloud::Common::Utils.sign(str_uri) response = RestClient.get(signed_uri, :accept => 'application/json') json = JSON.parse(response) return json['Names'].count rescue Exception=>e print e end end
get_properties()
click to toggle source
# File lib/Cells/workbook.rb, line 9 def get_properties begin if @filename == '' raise 'Base file name not specified.' end str_uri = $product_uri + '/cells/' + @filename + '/documentProperties' signed_uri = Aspose::Cloud::Common::Utils.sign(str_uri) response = RestClient.get(signed_uri, :accept => 'application/json') json = JSON.parse(response) if json['Code'] == 200 return json['DocumentProperties']['DocumentPropertyList'] else return false end rescue Exception=>e print e end end
get_property(property_name)
click to toggle source
# File lib/Cells/workbook.rb, line 30 def get_property property_name begin if @filename == '' raise 'Base file name not specified.' end if property_name == '' raise 'Property name is not specified.' end str_uri = $product_uri + '/cells/' + @filename + '/documentProperties/' + property_name signed_uri = Aspose::Cloud::Common::Utils.sign(str_uri) response = RestClient.get(signed_uri, :accept => 'application/json') json = JSON.parse(response) if json['Code'] == 200 return json['DocumentProperty'] else return false end rescue Exception=>e print e end end
get_worksheets_count()
click to toggle source
# File lib/Cells/workbook.rb, line 195 def get_worksheets_count begin if @filename == '' raise 'Base file name not specified' end str_uri = $product_uri + '/cells/' + @filename + '/worksheets' signed_uri = Aspose::Cloud::Common::Utils.sign(str_uri) response = RestClient.get(signed_uri, :accept => 'application/json') json = JSON.parse(response) return json['Worksheets']['WorksheetList'].size rescue Exception=>e print e end end
merge_workbook(merge_file_name ='')
click to toggle source
# File lib/Cells/workbook.rb, line 414 def merge_workbook merge_file_name ='' begin if @filename == '' raise 'Base file name not specified' end str_uri = $product_uri + '/cells/' + @filename + '/merge?mergeWith=' + merge_file_name signed_uri = Aspose::Cloud::Common::Utils.sign(str_uri) response = RestClient.post(signed_uri,'',:accept => 'application/json') json = JSON.parse(response) if json['Code']==200 return true else return false end rescue Exception=>e print e end end
process_smart_marker(data_file='')
click to toggle source
# File lib/Cells/workbook.rb, line 179 def process_smart_marker data_file='' begin if data_file == '' raise 'Data file not specified' end str_uri = $product_uri + '/cells/' + @filename + '/smartmarker?xmlFile=' + data_file signed_uri = Aspose::Cloud::Common::Utils.sign(str_uri) response = RestClient.post(signed_uri,'', :accept => 'application/json') json = JSON.parse(response) return json rescue Exception=>e print e end end
protect_workbook(protection_type = 'all',password='')
click to toggle source
# File lib/Cells/workbook.rb, line 264 def protect_workbook protection_type = 'all',password='' begin if @filename == '' raise 'Base file name not specified' end fields_array = Hash.new fields_array['ProtectionType'] = protection_type fields_array['Password'] = password json_data = fields_array.to_json str_uri = $product_uri + '/cells/' + @filename + '/protection' signed_uri = Aspose::Cloud::Common::Utils.sign(str_uri) response = RestClient.post(signed_uri, json_data,:accept => 'application/json') json = JSON.parse(response) if json['Code']==200 return true else return false end rescue Exception=>e print e end end
remove_all_properties()
click to toggle source
# File lib/Cells/workbook.rb, line 86 def remove_all_properties begin if @filename == '' raise 'Base file name not specified.' end str_uri = $product_uri + '/cells/' + @filename + '/documentProperties' signed_uri = Aspose::Cloud::Common::Utils.sign(str_uri) response = RestClient.delete(signed_uri, :accept=>'application/json') json = JSON.parse(response) if json['Code'] == 200 return true else return false end rescue Exception=>e print e end end
remove_property(property_name)
click to toggle source
# File lib/Cells/workbook.rb, line 107 def remove_property property_name begin if @filename == '' raise 'Base file name not specified.' end if property_name == '' raise 'Property name is not specified.' end str_uri = $product_uri + '/cells/' + @filename + '/documentProperties/' + property_name signed_uri = Aspose::Cloud::Common::Utils.sign(str_uri) response = RestClient.delete(signed_uri, :accept => 'application/json') json = JSON.parse(response) if json['Code'] == 200 return true else return false end rescue Exception=>e print e end end
remove_worksheet(worksheet_name='')
click to toggle source
# File lib/Cells/workbook.rb, line 395 def remove_worksheet worksheet_name='' begin if @filename == '' raise 'Base file name not specified' end str_uri = $product_uri + '/cells/' + @filename + '/worksheets/' + worksheet_name signed_uri = Aspose::Cloud::Common::Utils.sign(str_uri) response = RestClient.delete(signed_uri,:accept => 'application/json') json = JSON.parse(response) if json['Code']==200 return true else return false end rescue Exception=>e print e end end
set_modify_password(password='')
click to toggle source
# File lib/Cells/workbook.rb, line 309 def set_modify_password password='' begin if @filename == '' raise 'Base file name not specified' end fields_array = Hash.new fields_array['Password'] = password json_data = fields_array.to_json str_uri = $product_uri + '/cells/' + @filename + '/writeProtection' signed_uri = Aspose::Cloud::Common::Utils.sign(str_uri) response = RestClient.put(signed_uri, json_data,:accept => 'application/json') json = JSON.parse(response) if json['Code']==200 return true else return false end rescue Exception=>e print e end end
set_property(property_name='',property_value='')
click to toggle source
# File lib/Cells/workbook.rb, line 54 def set_property property_name='',property_value='' begin if @filename == '' raise 'Base file name not specified.' end if property_name == '' raise 'Property name is not specified.' end if property_value == '' raise 'Property Value is not specified.' end str_uri = $product_uri + '/cells/' + @filename + '/documentProperties/' + property_name put_data_arr = Hash.new put_data_arr['Link'] = nil put_data_arr['Name'] = property_name put_data_arr['Value'] = property_value put_data_arr['BuiltIn'] = 'False' json_data = put_data_arr.to_json signed_uri = Aspose::Cloud::Common::Utils.sign(str_uri) response = RestClient.put(signed_uri,json_data, :accept => 'application/json') json = JSON.parse(response) if json['Code'] == 200 return json['DocumentProperty'] else return false end rescue Exception=>e print e end end
unprotect_workbook(password)
click to toggle source
# File lib/Cells/workbook.rb, line 287 def unprotect_workbook password begin if @filename == '' raise 'Base file name not specified' end fields_array = Hash.new fields_array['Password'] = password json_data = fields_array.to_json str_uri = $product_uri + '/cells/' + @filename + '/protection' signed_uri = Aspose::Cloud::Common::Utils.sign(str_uri) response = RestClient.delete(signed_uri,json_data,:accept=>'application/json') json = JSON.parse(response) if json['Code']==200 return true else return false end rescue Exception=>e print e end end