class Aspose::Cloud::Cells::Worksheet

Public Class Methods

new(filename, worksheet_name) click to toggle source
# File lib/Cells/worksheet.rb, line 22
def initialize(filename, worksheet_name)
  @filename = filename
  @worksheet_name = worksheet_name
  raise 'filename not specified.' if filename.empty?
  raise 'worksheet_name not specified.' if worksheet_name.empty?
  @base_uri = "#{Aspose::Cloud::Common::Product.product_uri}/cells/#{@filename}/worksheets/#{@worksheet_name}"
end

Public Instance Methods

add_empty_row(row_id, folder_name = '', storage_type = 'Aspose', storage_name = '') click to toggle source
# File lib/Cells/worksheet.rb, line 679
def add_empty_row(row_id, folder_name = '', storage_type = 'Aspose', storage_name = '')
  raise 'row_id not specified.' if row_id.nil?

  str_uri = "#{@base_uri}/cells/rows/#{row_id}"
  str_uri = Aspose::Cloud::Common::Utils.append_storage(str_uri,folder_name,storage_name,storage_type)
  signed_str_uri = Aspose::Cloud::Common::Utils.sign(str_uri)

  response_stream = RestClient.put(signed_str_uri, '', {:accept=>'application/json'})
  valid_output = Aspose::Cloud::Common::Utils.validate_output(response_stream)
  valid_output.empty? ? Aspose::Cloud::Common::Utils.download_file(@filename,@filename,folder_name,storage_name,storage_type) : valid_output
end
add_oleobject(ole_file, image_file, upper_left_row, upper_left_column, height, width, folder_name = '', storage_type = 'Aspose', storage_name = '') click to toggle source
# File lib/Cells/worksheet.rb, line 322
def add_oleobject(ole_file, image_file, upper_left_row, upper_left_column, height, width, folder_name = '', storage_type = 'Aspose', storage_name = '')
  raise 'ole_file not specified.' if ole_file.empty?
  raise 'image_file not specified.' if image_file.empty?
  raise 'upper_left_row not specified.' if upper_left_row.nil?
  raise 'upper_left_column not specified.' if upper_left_column.nil?
  raise 'height not specified.' if height.nil?
  raise 'width not specified.' if width.nil?

  str_uri = "#{@base_uri}/oleobjects"
  qry = Hash.new
  qry[:oleFile] = ole_file
  qry[:imageFile] = image_file
  qry[:upperLeftRow] = upper_left_row
  qry[:upperLeftColumn] = upper_left_column
  qry[:height] = height
  qry[:width] = width
  str_uri = Aspose::Cloud::Common::Utils.build_uri(str_uri,qry)
  str_uri = Aspose::Cloud::Common::Utils.append_storage(str_uri,folder_name,storage_name,storage_type)
  signed_str_uri = Aspose::Cloud::Common::Utils.sign(str_uri)
  JSON.parse(RestClient.put(signed_str_uri, '', {:accept=>'application/json'}))['Code'] == 200 ? true : false
end
add_picture(picture_path, upper_left_row, upper_left_column, lower_right_row, lower_right_column, folder_name = '', storage_type = 'Aspose', storage_name = '') click to toggle source
# File lib/Cells/worksheet.rb, line 555
def add_picture(picture_path, upper_left_row, upper_left_column, lower_right_row, lower_right_column, folder_name = '', storage_type = 'Aspose', storage_name = '')
  raise 'picture_path not specified.' if picture_path.empty?
  raise 'upper_left_row not specified.' if upper_left_row.nil?
  raise 'upper_left_column not specified.' if upper_left_column.nil?
  raise 'lower_right_row not specified.' if lower_right_row.nil?
  raise 'lower_right_column not specified.' if lower_right_column.nil?

  qry = { :upperLeftRow => upper_left_row, :upperLeftColumn => upper_left_column, :lowerRightRow => lower_right_row,
  :lowerRightColumn => lower_right_column, :picturePath => picture_path}
  str_uri = "#{@base_uri}/pictures"
  str_uri = Aspose::Cloud::Common::Utils.build_uri(str_uri,qry)
  str_uri = Aspose::Cloud::Common::Utils.append_storage(str_uri,folder_name,storage_name,storage_type)
  signed_str_uri = Aspose::Cloud::Common::Utils.sign(str_uri)
  JSON.parse(RestClient.put(signed_str_uri, '', { :accept=>'application/json'}))['Code'] == 200 ? true : false
end
calculate_formula(formula, folder_name = '', storage_type = 'Aspose', storage_name = '') click to toggle source
# File lib/Cells/worksheet.rb, line 523
def calculate_formula(formula, folder_name = '', storage_type = 'Aspose', storage_name = '')
  raise 'formula not specified.' if formula.empty?

  str_uri = "#{@base_uri}/formulaResult?formula=#{formula}"
  str_uri = Aspose::Cloud::Common::Utils.append_storage(str_uri,folder_name,storage_name,storage_type)
  signed_str_uri = Aspose::Cloud::Common::Utils.sign(str_uri)
  JSON.parse(RestClient.get(signed_str_uri, {:accept=>'application/json'}))['Value']
end
clear_cells_contents(range, folder_name = '', storage_type = 'Aspose', storage_name = '') click to toggle source
# File lib/Cells/worksheet.rb, line 802
def clear_cells_contents(range, folder_name = '', storage_type = 'Aspose', storage_name = '')
  raise 'range not specified.' if range.empty?          

  str_uri = "#{@base_uri}/cells/clearcontents?range=#{range}"
  str_uri = Aspose::Cloud::Common::Utils.append_storage(str_uri,folder_name,storage_name,storage_type)
  signed_str_uri = Aspose::Cloud::Common::Utils.sign(str_uri)

  response_stream = RestClient.post(signed_str_uri, '', {:accept=>'application/json'})
  valid_output = Aspose::Cloud::Common::Utils.validate_output(response_stream)
  valid_output.empty? ? Aspose::Cloud::Common::Utils.download_file(@filename,@filename,folder_name,storage_name,storage_type) : valid_output
end
clear_cells_formatting(start_row, start_column, end_row, end_column, folder_name = '', storage_type = 'Aspose', storage_name = '') click to toggle source
# File lib/Cells/worksheet.rb, line 787
def clear_cells_formatting(start_row, start_column, end_row, end_column, folder_name = '', storage_type = 'Aspose', storage_name = '')
  raise 'start_row not specified.' if start_row.nil?
  raise 'start_column not specified.' if start_column.nil?
  raise 'end_row not specified.' if end_row.nil?
  raise 'end_column not specified.' if end_column.nil?

  str_uri = "#{@base_uri}/cells/ClearFormats?startRow=#{start_row}&startColumn=#{start_column}&endRow=#{end_row}&endColumn=#{end_column}"
  str_uri = Aspose::Cloud::Common::Utils.append_storage(str_uri,folder_name,storage_name,storage_type)
  signed_str_uri = Aspose::Cloud::Common::Utils.sign(str_uri)

  response_stream = RestClient.post(signed_str_uri, '', {:accept=>'application/json'})
  valid_output = Aspose::Cloud::Common::Utils.validate_output(response_stream)
  valid_output.empty? ? Aspose::Cloud::Common::Utils.download_file(@filename,@filename,folder_name,storage_name,storage_type) : valid_output
end
copy_row(source_row_index, destination_row_index, row_number, folder_name = '', storage_type = 'Aspose', storage_name = '') click to toggle source
# File lib/Cells/worksheet.rb, line 691
def copy_row(source_row_index, destination_row_index, row_number, folder_name = '', storage_type = 'Aspose', storage_name = '')
  raise 'source_row_index not specified.' if source_row_index.nil?
  raise 'destination_row_index not specified.' if destination_row_index.nil?
  raise 'row_number not specified.' if row_number.nil?

  str_uri = "#{@base_uri}/cells/rows/copy?sourceRowIndex=#{source_row_index}&destinationRowIndex=#{destination_row_index}&rowNumber=#{row_number}"
  str_uri = Aspose::Cloud::Common::Utils.append_storage(str_uri,folder_name,storage_name,storage_type)
  signed_str_uri = Aspose::Cloud::Common::Utils.sign(str_uri)

  response_stream = RestClient.post(signed_str_uri, '', {:accept=>'application/json'})
  valid_output = Aspose::Cloud::Common::Utils.validate_output(response_stream)
  valid_output.empty? ? Aspose::Cloud::Common::Utils.download_file(@filename,@filename,folder_name,storage_name,storage_type) : valid_output
end
copy_worksheet(new_worksheet_name, folder_name = '', storage_type = 'Aspose', storage_name = '') click to toggle source
# File lib/Cells/worksheet.rb, line 603
def copy_worksheet(new_worksheet_name, folder_name = '', storage_type = 'Aspose', storage_name = '')
  raise 'new_worksheet_name not specified.' if new_worksheet_name.empty?      

  str_uri = "#{Aspose::Cloud::Common::Product.product_uri}/cells/#{@filename}/worksheets/#{new_worksheet_name}/copy?sourcesheet=#{@worksheet_name}"          
  str_uri = Aspose::Cloud::Common::Utils.append_storage(str_uri,folder_name,storage_name,storage_type)
  signed_str_uri = Aspose::Cloud::Common::Utils.sign(str_uri)

  response_stream = RestClient.post(signed_str_uri, '', {:accept=>'application/json'})
  valid_output = Aspose::Cloud::Common::Utils.validate_output(response_stream)
  valid_output.empty? ? Aspose::Cloud::Common::Utils.download_file(@filename,@filename,folder_name,storage_name,storage_type) : valid_output
end
delete_all_oleobjects(folder_name = '', storage_type = 'Aspose', storage_name = '') click to toggle source
# File lib/Cells/worksheet.rb, line 363
def delete_all_oleobjects(folder_name = '', storage_type = 'Aspose', storage_name = '')
  str_uri = "#{@base_uri}/oleobjects"
  str_uri = Aspose::Cloud::Common::Utils.append_storage(str_uri,folder_name,storage_name,storage_type)
  signed_str_uri = Aspose::Cloud::Common::Utils.sign(str_uri)
  JSON.parse(RestClient.delete(signed_str_uri, {:accept=>'application/json'}))['Code'] == 200 ? true : false
end
delete_background(folder_name = '', storage_type = 'Aspose', storage_name = '') click to toggle source
# File lib/Cells/worksheet.rb, line 639
def delete_background(folder_name = '', storage_type = 'Aspose', storage_name = '')
  str_uri = "#{@base_uri}/Background"
  str_uri = Aspose::Cloud::Common::Utils.append_storage(str_uri,folder_name,storage_name,storage_type)
  signed_str_uri = Aspose::Cloud::Common::Utils.sign(str_uri)

  response_stream = RestClient.delete(signed_str_uri, {:accept=>'application/json'})
  valid_output = Aspose::Cloud::Common::Utils.validate_output(response_stream)
  valid_output.empty? ? Aspose::Cloud::Common::Utils.download_file(@filename,@filename,folder_name,storage_name,storage_type) : valid_output
end
delete_oleobject(index, folder_name = '', storage_type = 'Aspose', storage_name = '') click to toggle source
# File lib/Cells/worksheet.rb, line 354
def delete_oleobject(index, folder_name = '', storage_type = 'Aspose', storage_name = '')
  raise 'index not specified.' if index.nil?

  str_uri = "#{@base_uri}/oleobjects/#{index}"
  str_uri = Aspose::Cloud::Common::Utils.append_storage(str_uri,folder_name,storage_name,storage_type)
  signed_str_uri = Aspose::Cloud::Common::Utils.sign(str_uri)
  JSON.parse(RestClient.delete(signed_str_uri, {:accept=>'application/json'}))['Code'] == 200 ? true : false
end
delete_picture(picture_index, folder_name = '', storage_type = 'Aspose', storage_name = '') click to toggle source
# File lib/Cells/worksheet.rb, line 591
def delete_picture(picture_index, folder_name = '', storage_type = 'Aspose', storage_name = '')
  raise 'picture_index not specified.' if picture_index.nil?

  str_uri = "#{@base_uri}/pictures/#{picture_index}"
  str_uri = Aspose::Cloud::Common::Utils.append_storage(str_uri,folder_name,storage_name,storage_type)
  signed_str_uri = Aspose::Cloud::Common::Utils.sign(str_uri)

  response_stream = RestClient.delete(signed_str_uri, {:accept=>'application/json'})
  valid_output = Aspose::Cloud::Common::Utils.validate_output(response_stream)
  valid_output.empty? ? Aspose::Cloud::Common::Utils.download_file(@filename,@filename,folder_name,storage_name,storage_type) : valid_output
end
delete_pictures(folder_name = '', storage_type = 'Aspose', storage_name = '') click to toggle source
# File lib/Cells/worksheet.rb, line 581
def delete_pictures(folder_name = '', storage_type = 'Aspose', storage_name = '')
  str_uri = "#{@base_uri}/pictures"
  str_uri = Aspose::Cloud::Common::Utils.append_storage(str_uri,folder_name,storage_name,storage_type)
  signed_str_uri = Aspose::Cloud::Common::Utils.sign(str_uri)

  response_stream = RestClient.delete(signed_str_uri, {:accept=>'application/json'})
  valid_output = Aspose::Cloud::Common::Utils.validate_output(response_stream)
  valid_output.empty? ? Aspose::Cloud::Common::Utils.download_file(@filename,@filename,folder_name,storage_name,storage_type) : valid_output
end
delete_row(index, folder_name = '', storage_type = 'Aspose', storage_name = '') click to toggle source
# File lib/Cells/worksheet.rb, line 481
def delete_row(index, folder_name = '', storage_type = 'Aspose', storage_name = '')
  raise 'index not specified.' if index.nil?

  str_uri = "#{@base_uri}/cells/rows/#{index}"
  str_uri = Aspose::Cloud::Common::Utils.append_storage(str_uri,folder_name,storage_name,storage_type)
  signed_str_uri = Aspose::Cloud::Common::Utils.sign(str_uri)
  JSON.parse(RestClient.delete(signed_str_uri, {:accept=>'application/json'}))['Code'] == 200 ? true : false
end
freeze_panes(row, column, freezed_rows, freezed_columns, folder_name = '', storage_type = 'Aspose', storage_name = '') click to toggle source
# File lib/Cells/worksheet.rb, line 649
def freeze_panes(row, column, freezed_rows, freezed_columns, folder_name = '', storage_type = 'Aspose', storage_name = '')
  raise 'row not specified.' if row.nil?
  raise 'column not specified.' if column.nil?
  raise 'freezed_rows not specified.' if freezed_rows.nil?
  raise 'freezed_columns not specified.' if freezed_columns.nil?

  str_uri = "#{@base_uri}/FreezePanes?row=#{row}&column=#{column}&freezedRows=#{freezed_rows}&freezedColumns=#{freezed_columns}"
  str_uri = Aspose::Cloud::Common::Utils.append_storage(str_uri,folder_name,storage_name,storage_type)
  signed_str_uri = Aspose::Cloud::Common::Utils.sign(str_uri)

  response_stream = RestClient.put(signed_str_uri, '', {:accept=>'application/json'})
  valid_output = Aspose::Cloud::Common::Utils.validate_output(response_stream)
  valid_output.empty? ? Aspose::Cloud::Common::Utils.download_file(@filename,@filename,folder_name,storage_name,storage_type) : valid_output
end
get_auto_shapes_by_index(shape_index, folder_name = '', storage_type = 'Aspose', storage_name = '') click to toggle source
# File lib/Cells/worksheet.rb, line 205
def get_auto_shapes_by_index(shape_index, folder_name = '', storage_type = 'Aspose', storage_name = '')
  raise 'shape_index not specified.' if shape_index.nil?

  str_uri = "#{@base_uri}/autoshapes/#{shape_index}"
  str_uri = Aspose::Cloud::Common::Utils.append_storage(str_uri,folder_name,storage_name,storage_type)
  signed_str_uri = Aspose::Cloud::Common::Utils.sign(str_uri)
  JSON.parse(RestClient.get(signed_str_uri, {:accept=>'application/json'}))['AutoShapes']
end
get_auto_shapes_count(folder_name = '', storage_type = 'Aspose', storage_name = '') click to toggle source
# File lib/Cells/worksheet.rb, line 198
def get_auto_shapes_count(folder_name = '', storage_type = 'Aspose', storage_name = '')
  str_uri = "#{@base_uri}/autoshapes"
  str_uri = Aspose::Cloud::Common::Utils.append_storage(str_uri,folder_name,storage_name,storage_type)
  signed_str_uri = Aspose::Cloud::Common::Utils.sign(str_uri)
  JSON.parse(RestClient.get(signed_str_uri, {:accept=>'application/json'}))['AutoShapes']['AuotShapeList'].length
end
get_cell(cell_name, folder_name = '', storage_type = 'Aspose', storage_name = '') click to toggle source
# File lib/Cells/worksheet.rb, line 214
def get_cell(cell_name, folder_name = '', storage_type = 'Aspose', storage_name = '')
  raise 'cell_name not specified.' if cell_name.empty?

  str_uri = "#{@base_uri}/cells/#{cell_name}"
  str_uri = Aspose::Cloud::Common::Utils.append_storage(str_uri,folder_name,storage_name,storage_type)
  signed_str_uri = Aspose::Cloud::Common::Utils.sign(str_uri)
  JSON.parse(RestClient.get(signed_str_uri, {:accept=>'application/json'}))['Cell']
end
get_cell_style(cell_name, folder_name = '', storage_type = 'Aspose', storage_name = '') click to toggle source
# File lib/Cells/worksheet.rb, line 223
def get_cell_style(cell_name, folder_name = '', storage_type = 'Aspose', storage_name = '')
  raise 'cell_name not specified.' if cell_name.empty?

  str_uri = "#{@base_uri}/cells/#{cell_name}/style"
  str_uri = Aspose::Cloud::Common::Utils.append_storage(str_uri,folder_name,storage_name,storage_type)
  signed_str_uri = Aspose::Cloud::Common::Utils.sign(str_uri)
  JSON.parse(RestClient.get(signed_str_uri, {:accept=>'application/json'}))['Style']
end
get_cells_count(offset, count, folder_name = '', storage_type = 'Aspose', storage_name = '') click to toggle source
# File lib/Cells/worksheet.rb, line 186
def get_cells_count(offset, count, folder_name = '', storage_type = 'Aspose', storage_name = '')
  raise 'offset not specified.' if offset.nil?
  raise 'count not specified.' if count.nil?

  str_uri = "#{@base_uri}/cells"
  qry = { :offset => offset, :count => count}
  str_uri = Aspose::Cloud::Common::Utils.build_uri(str_uri,qry)
  str_uri = Aspose::Cloud::Common::Utils.append_storage(str_uri,folder_name,storage_name,storage_type)
  signed_str_uri = Aspose::Cloud::Common::Utils.sign(str_uri)
  JSON.parse(RestClient.get(signed_str_uri, {:accept=>'application/json'}))['Cells']['CellCount']
end
get_cells_list(offset, count, folder_name = '', storage_type = 'Aspose', storage_name = '') click to toggle source
# File lib/Cells/worksheet.rb, line 30
def get_cells_list(offset, count, folder_name = '', storage_type = 'Aspose', storage_name = '')
  raise 'offset not specified.' if offset.nil?
  raise 'count not specified.' if count.nil?

  str_uri = "#{@base_uri}/cells"
  qry = { :offset => offset, :count => count}
  str_uri = Aspose::Cloud::Common::Utils.build_uri(str_uri,qry)
  str_uri = Aspose::Cloud::Common::Utils.append_storage(str_uri,folder_name,storage_name,storage_type)
  signed_str_uri = Aspose::Cloud::Common::Utils.sign(str_uri)
  JSON.parse(RestClient.get(signed_str_uri, {:accept=>'application/json'}))['Cells']['CellList']
end
get_chart_by_index(chart_index, folder_name = '', storage_type = 'Aspose', storage_name = '') click to toggle source
# File lib/Cells/worksheet.rb, line 242
def get_chart_by_index(chart_index, folder_name = '', storage_type = 'Aspose', storage_name = '')
  raise 'chart_index not specified.' if chart_index.nil?

  str_uri = "#{@base_uri}/charts/#{chart_index}"
  str_uri = Aspose::Cloud::Common::Utils.append_storage(str_uri,folder_name,storage_name,storage_type)
  signed_str_uri = Aspose::Cloud::Common::Utils.sign(str_uri)
  JSON.parse(RestClient.get(signed_str_uri, {:accept=>'application/json'}))['Chart']
end
get_charts_count(folder_name = '', storage_type = 'Aspose', storage_name = '') click to toggle source
# File lib/Cells/worksheet.rb, line 425
def get_charts_count(folder_name = '', storage_type = 'Aspose', storage_name = '')
  str_uri = "#{@base_uri}/charts"
  str_uri = Aspose::Cloud::Common::Utils.append_storage(str_uri,folder_name,storage_name,storage_type)
  signed_str_uri = Aspose::Cloud::Common::Utils.sign(str_uri)
  JSON.parse(RestClient.get(signed_str_uri, {:accept=>'application/json'}))['Charts']['ChartList'].length
end
get_column(index, folder_name = '', storage_type = 'Aspose', storage_name = '') click to toggle source
# File lib/Cells/worksheet.rb, line 503
def get_column(index, folder_name = '', storage_type = 'Aspose', storage_name = '')
  raise 'index not specified.' if index.nil?

  str_uri = "#{@base_uri}/cells/columns/#{index}"
  str_uri = Aspose::Cloud::Common::Utils.append_storage(str_uri,folder_name,storage_name,storage_type)
  signed_str_uri = Aspose::Cloud::Common::Utils.sign(str_uri)
  JSON.parse(RestClient.get(signed_str_uri, {:accept=>'application/json'}))['Column']
end
get_columns_list(offset, count, folder_name = '', storage_type = 'Aspose', storage_name = '') click to toggle source
# File lib/Cells/worksheet.rb, line 54
def get_columns_list(offset, count, folder_name = '', storage_type = 'Aspose', storage_name = '')
  raise 'offset not specified.' if offset.nil?
  raise 'count not specified.' if count.nil?

  str_uri = "#{@base_uri}/cells/columns"
  qry = { :offset => offset, :count => count}
  str_uri = Aspose::Cloud::Common::Utils.build_uri(str_uri,qry)
  str_uri = Aspose::Cloud::Common::Utils.append_storage(str_uri,folder_name,storage_name,storage_type)
  signed_str_uri = Aspose::Cloud::Common::Utils.sign(str_uri)
  JSON.parse(RestClient.get(signed_str_uri, {:accept=>'application/json'}))['Columns']['ColumnsList']
end
get_comment(cell_name, folder_name = '', storage_type = 'Aspose', storage_name = '') click to toggle source
# File lib/Cells/worksheet.rb, line 304
def get_comment(cell_name, folder_name = '', storage_type = 'Aspose', storage_name = '')
  raise 'cell_name not specified.' if cell_name.empty?

  str_uri = "#{@base_uri}/comments/#{cell_name}"
  str_uri = Aspose::Cloud::Common::Utils.append_storage(str_uri,folder_name,storage_name,storage_type)
  signed_str_uri = Aspose::Cloud::Common::Utils.sign(str_uri)
  JSON.parse(RestClient.get(signed_str_uri, {:accept=>'application/json'}))['Comment']
end
get_comments_count(folder_name = '', storage_type = 'Aspose', storage_name = '') click to toggle source
# File lib/Cells/worksheet.rb, line 432
def get_comments_count(folder_name = '', storage_type = 'Aspose', storage_name = '')
  str_uri = "#{@base_uri}/comments"
  str_uri = Aspose::Cloud::Common::Utils.append_storage(str_uri,folder_name,storage_name,storage_type)
  signed_str_uri = Aspose::Cloud::Common::Utils.sign(str_uri)
  JSON.parse(RestClient.get(signed_str_uri, {:accept=>'application/json'}))['Comments']['CommentList'].length
end
get_first_cell(offset, count, folder_name = '', storage_type = 'Aspose', storage_name = '') click to toggle source
# File lib/Cells/worksheet.rb, line 90
def get_first_cell(offset, count, folder_name = '', storage_type = 'Aspose', storage_name = '')
  raise 'offset not specified.' if offset.nil?
  raise 'count not specified.' if count.nil?

  str_uri = "#{@base_uri}/cells/firstcell"
  qry = { :offset => offset, :count => count}
  str_uri = Aspose::Cloud::Common::Utils.build_uri(str_uri,qry)
  str_uri = Aspose::Cloud::Common::Utils.append_storage(str_uri,folder_name,storage_name,storage_type)
  signed_str_uri = Aspose::Cloud::Common::Utils.sign(str_uri)
  JSON.parse(RestClient.get(signed_str_uri, {:accept=>'application/json'}))['Cell']
end
get_last_cell(offset, count, folder_name = '', storage_type = 'Aspose', storage_name = '') click to toggle source
# File lib/Cells/worksheet.rb, line 102
def get_last_cell(offset, count, folder_name = '', storage_type = 'Aspose', storage_name = '')
  raise 'offset not specified.' if offset.nil?
  raise 'count not specified.' if count.nil?

  str_uri = "#{@base_uri}/cells/endcell"
  qry = { :offset => offset, :count => count}
  str_uri = Aspose::Cloud::Common::Utils.build_uri(str_uri,qry)
  str_uri = Aspose::Cloud::Common::Utils.append_storage(str_uri,folder_name,storage_name,storage_type)
  signed_str_uri = Aspose::Cloud::Common::Utils.sign(str_uri)
  JSON.parse(RestClient.get(signed_str_uri, {:accept=>'application/json'}))['Cell']
end
get_max_columns(offset, count, folder_name = '', storage_type = 'Aspose', storage_name = '') click to toggle source
# File lib/Cells/worksheet.rb, line 66
def get_max_columns(offset, count, folder_name = '', storage_type = 'Aspose', storage_name = '')
  raise 'offset not specified.' if offset.nil?
  raise 'count not specified.' if count.nil?

  str_uri = "#{@base_uri}/cells"
  qry = { :offset => offset, :count => count}
  str_uri = Aspose::Cloud::Common::Utils.build_uri(str_uri,qry)
  str_uri = Aspose::Cloud::Common::Utils.append_storage(str_uri,folder_name,storage_name,storage_type)
  signed_str_uri = Aspose::Cloud::Common::Utils.sign(str_uri)
  JSON.parse(RestClient.get(signed_str_uri, {:accept=>'application/json'}))['Cells']['MaxColumn']
end
get_max_data_column(offset, count, folder_name = '', storage_type = 'Aspose', storage_name = '') click to toggle source
# File lib/Cells/worksheet.rb, line 126
def get_max_data_column(offset, count, folder_name = '', storage_type = 'Aspose', storage_name = '')
  raise 'offset not specified.' if offset.nil?
  raise 'count not specified.' if count.nil?

  str_uri = "#{@base_uri}/cells/maxdatacolumn"
  qry = { :offset => offset, :count => count}
  str_uri = Aspose::Cloud::Common::Utils.build_uri(str_uri,qry)
  str_uri = Aspose::Cloud::Common::Utils.append_storage(str_uri,folder_name,storage_name,storage_type)
  signed_str_uri = Aspose::Cloud::Common::Utils.sign(str_uri)          
  RestClient.get(signed_str_uri, {:accept=>'application/json'})
end
get_max_data_row(offset, count, folder_name = '', storage_type = 'Aspose', storage_name = '') click to toggle source
# File lib/Cells/worksheet.rb, line 114
def get_max_data_row(offset, count, folder_name = '', storage_type = 'Aspose', storage_name = '')
  raise 'offset not specified.' if offset.nil?
  raise 'count not specified.' if count.nil?

  str_uri = "#{@base_uri}/cells/maxdatarow"
  qry = { :offset => offset, :count => count}
  str_uri = Aspose::Cloud::Common::Utils.build_uri(str_uri,qry)
  str_uri = Aspose::Cloud::Common::Utils.append_storage(str_uri,folder_name,storage_name,storage_type)
  signed_str_uri = Aspose::Cloud::Common::Utils.sign(str_uri)
  RestClient.get(signed_str_uri, {:accept=>'application/json'})
end
get_max_row(offset, count, folder_name = '', storage_type = 'Aspose', storage_name = '') click to toggle source
# File lib/Cells/worksheet.rb, line 78
def get_max_row(offset, count, folder_name = '', storage_type = 'Aspose', storage_name = '')
  raise 'offset not specified.' if offset.nil?
  raise 'count not specified.' if count.nil?

  str_uri = "#{@base_uri}/cells"
  qry = { :offset => offset, :count => count}
  str_uri = Aspose::Cloud::Common::Utils.build_uri(str_uri,qry)
  str_uri = Aspose::Cloud::Common::Utils.append_storage(str_uri,folder_name,storage_name,storage_type)
  signed_str_uri = Aspose::Cloud::Common::Utils.sign(str_uri)
  JSON.parse(RestClient.get(signed_str_uri, {:accept=>'application/json'}))['Cells']['MaxRow']
end
get_mergedcell_by_index(index, folder_name = '', storage_type = 'Aspose', storage_name = '') click to toggle source
# File lib/Cells/worksheet.rb, line 388
def get_mergedcell_by_index(index, folder_name = '', storage_type = 'Aspose', storage_name = '')
  raise 'index not specified.' if index.nil?

  str_uri = "#{@base_uri}/mergedCells/#{index}"
  str_uri = Aspose::Cloud::Common::Utils.append_storage(str_uri,folder_name,storage_name,storage_type)
  signed_str_uri = Aspose::Cloud::Common::Utils.sign(str_uri)
  JSON.parse(RestClient.get(signed_str_uri, {:accept=>'application/json'}))['MergedCell']
end
get_mergedcells_count(folder_name = '', storage_type = 'Aspose', storage_name = '') click to toggle source
# File lib/Cells/worksheet.rb, line 397
def get_mergedcells_count(folder_name = '', storage_type = 'Aspose', storage_name = '')
  str_uri = "#{@base_uri}/mergedCells"
  str_uri = Aspose::Cloud::Common::Utils.append_storage(str_uri,folder_name,storage_name,storage_type)
  signed_str_uri = Aspose::Cloud::Common::Utils.sign(str_uri)
  JSON.parse(RestClient.get(signed_str_uri, {:accept=>'application/json'}))['MergedCells']['Count']
end
get_min_column(offset, count, folder_name = '', storage_type = 'Aspose', storage_name = '') click to toggle source
# File lib/Cells/worksheet.rb, line 162
def get_min_column(offset, count, folder_name = '', storage_type = 'Aspose', storage_name = '')
  raise 'offset not specified.' if offset.nil?
  raise 'count not specified.' if count.nil?

  str_uri = "#{@base_uri}/cells/mincolumn"
  qry = { :offset => offset, :count => count}
  str_uri = Aspose::Cloud::Common::Utils.build_uri(str_uri,qry)
  str_uri = Aspose::Cloud::Common::Utils.append_storage(str_uri,folder_name,storage_name,storage_type)
  signed_str_uri = Aspose::Cloud::Common::Utils.sign(str_uri)          
  RestClient.get(signed_str_uri, {:accept=>'application/json'})
end
get_min_data_column(offset, count, folder_name = '', storage_type = 'Aspose', storage_name = '') click to toggle source
# File lib/Cells/worksheet.rb, line 174
def get_min_data_column(offset, count, folder_name = '', storage_type = 'Aspose', storage_name = '')
  raise 'offset not specified.' if offset.nil?
  raise 'count not specified.' if count.nil?

  str_uri = "#{@base_uri}/cells/mindatacolumn"
  qry = { :offset => offset, :count => count}
  str_uri = Aspose::Cloud::Common::Utils.build_uri(str_uri,qry)
  str_uri = Aspose::Cloud::Common::Utils.append_storage(str_uri,folder_name,storage_name,storage_type)
  signed_str_uri = Aspose::Cloud::Common::Utils.sign(str_uri)          
  RestClient.get(signed_str_uri, {:accept=>'application/json'})
end
get_min_data_row(offset, count, folder_name = '', storage_type = 'Aspose', storage_name = '') click to toggle source
# File lib/Cells/worksheet.rb, line 150
def get_min_data_row(offset, count, folder_name = '', storage_type = 'Aspose', storage_name = '')
  raise 'offset not specified.' if offset.nil?
  raise 'count not specified.' if count.nil?

  str_uri = "#{@base_uri}/cells/mindatarow"
  qry = { :offset => offset, :count => count}
  str_uri = Aspose::Cloud::Common::Utils.build_uri(str_uri,qry)
  str_uri = Aspose::Cloud::Common::Utils.append_storage(str_uri,folder_name,storage_name,storage_type)
  signed_str_uri = Aspose::Cloud::Common::Utils.sign(str_uri)          
  RestClient.get(signed_str_uri, {:accept=>'application/json'})
end
get_min_row(offset, count, folder_name = '', storage_type = 'Aspose', storage_name = '') click to toggle source
# File lib/Cells/worksheet.rb, line 138
def get_min_row(offset, count, folder_name = '', storage_type = 'Aspose', storage_name = '')
  raise 'offset not specified.' if offset.nil?
  raise 'count not specified.' if count.nil?

  str_uri = "#{@base_uri}/cells/minrow"
  qry = { :offset => offset, :count => count}
  str_uri = Aspose::Cloud::Common::Utils.build_uri(str_uri,qry)
  str_uri = Aspose::Cloud::Common::Utils.append_storage(str_uri,folder_name,storage_name,storage_type)
  signed_str_uri = Aspose::Cloud::Common::Utils.sign(str_uri)          
  RestClient.get(signed_str_uri, {:accept=>'application/json'})
end
get_oleobject_by_index(ole_index, folder_name = '', storage_type = 'Aspose', storage_name = '') click to toggle source
# File lib/Cells/worksheet.rb, line 313
def get_oleobject_by_index(ole_index, folder_name = '', storage_type = 'Aspose', storage_name = '')
  raise 'ole_index not specified.' if ole_index.nil?

  str_uri = "#{@base_uri}/oleobjects/#{ole_index}"
  str_uri = Aspose::Cloud::Common::Utils.append_storage(str_uri,folder_name,storage_name,storage_type)
  signed_str_uri = Aspose::Cloud::Common::Utils.sign(str_uri)
  JSON.parse(RestClient.get(signed_str_uri, {:accept=>'application/json'}))['OleObject']
end
get_oleobjects_count(folder_name = '', storage_type = 'Aspose', storage_name = '') click to toggle source
# File lib/Cells/worksheet.rb, line 418
def get_oleobjects_count(folder_name = '', storage_type = 'Aspose', storage_name = '')
  str_uri = "#{@base_uri}/oleobjects"
  str_uri = Aspose::Cloud::Common::Utils.append_storage(str_uri,folder_name,storage_name,storage_type)
  signed_str_uri = Aspose::Cloud::Common::Utils.sign(str_uri)
  JSON.parse(RestClient.get(signed_str_uri, {:accept=>'application/json'}))['OleObjects']['OleOjectList'].length
end
get_picture_by_index(image_index, folder_name = '', storage_type = 'Aspose', storage_name = '') click to toggle source
# File lib/Cells/worksheet.rb, line 370
def get_picture_by_index(image_index, folder_name = '', storage_type = 'Aspose', storage_name = '')
  raise 'image_index not specified.' if image_index.nil?

  str_uri = "#{@base_uri}/pictures/#{image_index}"
  str_uri = Aspose::Cloud::Common::Utils.append_storage(str_uri,folder_name,storage_name,storage_type)
  signed_str_uri = Aspose::Cloud::Common::Utils.sign(str_uri)
  JSON.parse(RestClient.get(signed_str_uri, {:accept=>'application/json'}))['Picture']
end
get_pictures_count(folder_name = '', storage_type = 'Aspose', storage_name = '') click to toggle source
# File lib/Cells/worksheet.rb, line 411
def get_pictures_count(folder_name = '', storage_type = 'Aspose', storage_name = '')
  str_uri = "#{@base_uri}/pictures"
  str_uri = Aspose::Cloud::Common::Utils.append_storage(str_uri,folder_name,storage_name,storage_type)
  signed_str_uri = Aspose::Cloud::Common::Utils.sign(str_uri)
  JSON.parse(RestClient.get(signed_str_uri, {:accept=>'application/json'}))['Pictures']['PictureList'].length
end
get_row(index, folder_name = '', storage_type = 'Aspose', storage_name = '') click to toggle source
# File lib/Cells/worksheet.rb, line 472
def get_row(index, folder_name = '', storage_type = 'Aspose', storage_name = '')
  raise 'index not specified.' if index.nil?

  str_uri = "#{@base_uri}/cells/rows/#{index}"
  str_uri = Aspose::Cloud::Common::Utils.append_storage(str_uri,folder_name,storage_name,storage_type)
  signed_str_uri = Aspose::Cloud::Common::Utils.sign(str_uri)
  JSON.parse(RestClient.get(signed_str_uri, {:accept=>'application/json'}))['Row']
end
get_row_list(offset, count, folder_name = '', storage_type = 'Aspose', storage_name = '') click to toggle source
# File lib/Cells/worksheet.rb, line 42
def get_row_list(offset, count, folder_name = '', storage_type = 'Aspose', storage_name = '')
  raise 'offset not specified.' if offset.nil?
  raise 'count not specified.' if count.nil?

  str_uri = "#{@base_uri}/cells/rows"
  qry = { :offset => offset, :count => count}
  str_uri = Aspose::Cloud::Common::Utils.build_uri(str_uri,qry)
  str_uri = Aspose::Cloud::Common::Utils.append_storage(str_uri,folder_name,storage_name,storage_type)
  signed_str_uri = Aspose::Cloud::Common::Utils.sign(str_uri)
  JSON.parse(RestClient.get(signed_str_uri, {:accept=>'application/json'}))['Rows']['RowsList']
end
get_rows_count(offset, count, folder_name = '', storage_type = 'Aspose', storage_name = '') click to toggle source
# File lib/Cells/worksheet.rb, line 460
def get_rows_count(offset, count, folder_name = '', storage_type = 'Aspose', storage_name = '')
  raise 'offset not specified.' if offset.nil?
  raise 'count not specified.' if count.nil?

  str_uri = "#{@base_uri}/cells/rows"
  qry = { :offset => offset, :count => count}
  str_uri = Aspose::Cloud::Common::Utils.build_uri(str_uri,qry)
  str_uri = Aspose::Cloud::Common::Utils.append_storage(str_uri,folder_name,storage_name,storage_type)
  signed_str_uri = Aspose::Cloud::Common::Utils.sign(str_uri)
  JSON.parse(RestClient.get(signed_str_uri, {:accept=>'application/json'}))['Rows']['RowsCount']
end
get_validation_by_index(index, folder_name = '', storage_type = 'Aspose', storage_name = '') click to toggle source
# File lib/Cells/worksheet.rb, line 379
def get_validation_by_index(index, folder_name = '', storage_type = 'Aspose', storage_name = '')
  raise 'index not specified.' if index.nil?

  str_uri = "#{@base_uri}/validations/#{index}"
  str_uri = Aspose::Cloud::Common::Utils.append_storage(str_uri,folder_name,storage_name,storage_type)
  signed_str_uri = Aspose::Cloud::Common::Utils.sign(str_uri)          
  JSON.parse(RestClient.get(signed_str_uri, {:accept=>'application/json'}))['Validation']
end
get_validations_count(folder_name = '', storage_type = 'Aspose', storage_name = '') click to toggle source
# File lib/Cells/worksheet.rb, line 404
def get_validations_count(folder_name = '', storage_type = 'Aspose', storage_name = '')
  str_uri = "#{@base_uri}/validations"
  str_uri = Aspose::Cloud::Common::Utils.append_storage(str_uri,folder_name,storage_name,storage_type)
  signed_str_uri = Aspose::Cloud::Common::Utils.sign(str_uri)
  JSON.parse(RestClient.get(signed_str_uri, {:accept=>'application/json'}))['Validations']['Count']
end
group_rows(first_index, last_index, folder_name = '', storage_type = 'Aspose', storage_name = '') click to toggle source
# File lib/Cells/worksheet.rb, line 731
def group_rows(first_index, last_index, folder_name = '', storage_type = 'Aspose', storage_name = '')
  raise 'first_index not specified.' if first_index.nil?
  raise 'last_index not specified.' if last_index.nil?          

  str_uri = "#{@base_uri}/cells/rows/group?firstIndex=#{first_index}&lastIndex=#{last_index}"
  str_uri = Aspose::Cloud::Common::Utils.append_storage(str_uri,folder_name,storage_name,storage_type)
  signed_str_uri = Aspose::Cloud::Common::Utils.sign(str_uri)

  response_stream = RestClient.post(signed_str_uri, '', {:accept=>'application/json'})
  valid_output = Aspose::Cloud::Common::Utils.validate_output(response_stream)
  valid_output.empty? ? Aspose::Cloud::Common::Utils.download_file(@filename,@filename,folder_name,storage_name,storage_type) : valid_output
end
hide_rows(start_row, total_rows, folder_name = '', storage_type = 'Aspose', storage_name = '') click to toggle source
# File lib/Cells/worksheet.rb, line 705
def hide_rows(start_row, total_rows, folder_name = '', storage_type = 'Aspose', storage_name = '')
  raise 'start_row not specified.' if start_row.nil?
  raise 'total_rows not specified.' if total_rows.nil?          

  str_uri = "#{@base_uri}/cells/rows/hide?startrow=#{start_row}&totalRows=#{total_rows}"
  str_uri = Aspose::Cloud::Common::Utils.append_storage(str_uri,folder_name,storage_name,storage_type)
  signed_str_uri = Aspose::Cloud::Common::Utils.sign(str_uri)

  response_stream = RestClient.post(signed_str_uri, '', {:accept=>'application/json'})
  valid_output = Aspose::Cloud::Common::Utils.validate_output(response_stream)
  valid_output.empty? ? Aspose::Cloud::Common::Utils.download_file(@filename,@filename,folder_name,storage_name,storage_type) : valid_output
end
hide_worksheet(folder_name = '', storage_type = 'Aspose', storage_name = '') click to toggle source
# File lib/Cells/worksheet.rb, line 446
def hide_worksheet(folder_name = '', storage_type = 'Aspose', storage_name = '')
  str_uri = "#{@base_uri}/visible?isVisible=false"
  str_uri = Aspose::Cloud::Common::Utils.append_storage(str_uri,folder_name,storage_name,storage_type)
  signed_str_uri = Aspose::Cloud::Common::Utils.sign(str_uri)
  JSON.parse(RestClient.put(signed_str_uri, '', {:accept=>'application/json'}))['Code'] == 200 ? true : false
end
merge_cells(start_row, start_column, total_rows, total_colunms, folder_name = '', storage_type = 'Aspose', storage_name = '') click to toggle source
# File lib/Cells/worksheet.rb, line 757
def merge_cells(start_row, start_column, total_rows, total_colunms, folder_name = '', storage_type = 'Aspose', storage_name = '')
  raise 'start_row not specified.' if start_row.nil?
  raise 'start_column not specified.' if start_column.nil?
  raise 'total_rows not specified.' if total_rows.nil?
  raise 'total_colunms not specified.' if total_colunms.nil?

  str_uri = "#{@base_uri}/cells/merge?startrow=#{start_row}&startcolumn=#{start_column}&totalrows=#{total_rows}&totalcolumns=#{total_colunms}"
  str_uri = Aspose::Cloud::Common::Utils.append_storage(str_uri,folder_name,storage_name,storage_type)
  signed_str_uri = Aspose::Cloud::Common::Utils.sign(str_uri)

  response_stream = RestClient.post(signed_str_uri, '', {:accept=>'application/json'})
  valid_output = Aspose::Cloud::Common::Utils.validate_output(response_stream)
  valid_output.empty? ? Aspose::Cloud::Common::Utils.download_file(@filename,@filename,folder_name,storage_name,storage_type) : valid_output
end
move_worksheet(position, folder_name = '', storage_type = 'Aspose', storage_name = '') click to toggle source
# File lib/Cells/worksheet.rb, line 513
def move_worksheet(position, folder_name = '', storage_type = 'Aspose', storage_name = '')
  raise 'position not specified.' if position.nil?

  json_data = { :DestinationWorksheet => @worksheet_name, :Position => position }
  str_uri = "#{@base_uri}/position"
  str_uri = Aspose::Cloud::Common::Utils.append_storage(str_uri,folder_name,storage_name,storage_type)
  signed_str_uri = Aspose::Cloud::Common::Utils.sign(str_uri)
  JSON.parse(RestClient.post(signed_str_uri, json_data, { :content_type => :json, :accept=>'application/json'}))['Code'] == 200 ? true : false
end
rename_worksheet(new_worksheet_name, folder_name = '', storage_type = 'Aspose', storage_name = '') click to toggle source
# File lib/Cells/worksheet.rb, line 615
def rename_worksheet(new_worksheet_name, folder_name = '', storage_type = 'Aspose', storage_name = '')
  raise 'new_worksheet_name not specified.' if new_worksheet_name.empty?      

  str_uri = "#{@base_uri}/Rename?newname=#{new_worksheet_name}"
  str_uri = Aspose::Cloud::Common::Utils.append_storage(str_uri,folder_name,storage_name,storage_type)
  signed_str_uri = Aspose::Cloud::Common::Utils.sign(str_uri)

  response_stream = RestClient.post(signed_str_uri, '', {:accept=>'application/json'})
  valid_output = Aspose::Cloud::Common::Utils.validate_output(response_stream)
  valid_output.empty? ? Aspose::Cloud::Common::Utils.download_file(@filename,@filename,folder_name,storage_name,storage_type) : valid_output
end
set_background(background_image, folder_name = '', storage_type = 'Aspose', storage_name = '') click to toggle source
# File lib/Cells/worksheet.rb, line 627
def set_background(background_image, folder_name = '', storage_type = 'Aspose', storage_name = '')
  raise 'background_image not specified.' if background_image.empty?      

  str_uri = "#{@base_uri}/Background?imageFile=#{background_image}"
  str_uri = Aspose::Cloud::Common::Utils.append_storage(str_uri,folder_name,storage_name,storage_type)
  signed_str_uri = Aspose::Cloud::Common::Utils.sign(str_uri)

  response_stream = RestClient.post(signed_str_uri, '', {:accept=>'application/json'})
  valid_output = Aspose::Cloud::Common::Utils.validate_output(response_stream)
  valid_output.empty? ? Aspose::Cloud::Common::Utils.download_file(@filename,@filename,folder_name,storage_name,storage_type) : valid_output
end
set_cell_style(cell_name, style, folder_name = '', storage_type = 'Aspose', storage_name = '') click to toggle source
# File lib/Cells/worksheet.rb, line 232
def set_cell_style(cell_name, style, folder_name = '', storage_type = 'Aspose', storage_name = '')
  raise 'cell_name not specified.' if cell_name.empty?
  raise 'style not specified.' if style.empty?

  str_uri = "#{@base_uri}/cells/#{cell_name}/style"
  str_uri = Aspose::Cloud::Common::Utils.append_storage(str_uri,folder_name,storage_name,storage_type)
  signed_str_uri = Aspose::Cloud::Common::Utils.sign(str_uri)
  JSON.parse(RestClient.post(signed_str_uri, style.to_json, { :content_type => :json, :accept=>'application/json'}))['Code'] == 200 ? true : false
end
set_cell_value(cell_name, value_type, value, folder_name = '', storage_type = 'Aspose', storage_name = '') click to toggle source
# File lib/Cells/worksheet.rb, line 542
def set_cell_value(cell_name, value_type, value, folder_name = '', storage_type = 'Aspose', storage_name = '')
  raise 'cell_name not specified.' if cell_name.empty?
  raise 'value_type not specified.' if value_type.empty?
  raise 'value not specified.' if value.empty?

  str_uri = "#{@base_uri}/cells/#{cell_name}"
  qry = { :value => value, :type => value_type }
  str_uri = Aspose::Cloud::Common::Utils.build_uri(str_uri,qry)
  str_uri = Aspose::Cloud::Common::Utils.append_storage(str_uri,folder_name,storage_name,storage_type)
  signed_str_uri = Aspose::Cloud::Common::Utils.sign(str_uri)
  JSON.parse(RestClient.post(signed_str_uri, '', { :accept=>'application/json'}))['Code'] == 200 ? true : false
end
set_formula(cell_name, formula, folder_name = '', storage_type = 'Aspose', storage_name = '') click to toggle source
# File lib/Cells/worksheet.rb, line 532
def set_formula(cell_name, formula, folder_name = '', storage_type = 'Aspose', storage_name = '')
  raise 'cell_name not specified.' if cell_name.empty?
  raise 'formula not specified.' if formula.empty?          

  str_uri = "#{@base_uri}/cells/#{cell_name}?formula=#{formula}"
  str_uri = Aspose::Cloud::Common::Utils.append_storage(str_uri,folder_name,storage_name,storage_type)
  signed_str_uri = Aspose::Cloud::Common::Utils.sign(str_uri)
  JSON.parse(RestClient.post(signed_str_uri, '', { :accept=>'application/json'}))['Code'] == 200 ? true : false
end
set_range_value(cellarea, value, type, folder_name = '', storage_type = 'Aspose', storage_name = '') click to toggle source
# File lib/Cells/worksheet.rb, line 814
def set_range_value(cellarea, value, type, folder_name = '', storage_type = 'Aspose', storage_name = '')
  raise 'cellarea not specified.' if cellarea.empty?
  raise 'value not specified.' if value.empty?
  raise 'type not specified.' if type.empty?

  str_uri = "#{@base_uri}/cells?cellarea=#{cellarea}&value=#{value}&type=#{type}"
  str_uri = Aspose::Cloud::Common::Utils.append_storage(str_uri,folder_name,storage_name,storage_type)
  signed_str_uri = Aspose::Cloud::Common::Utils.sign(str_uri)

  response_stream = RestClient.post(signed_str_uri, '', {:accept=>'application/json'})
  valid_output = Aspose::Cloud::Common::Utils.validate_output(response_stream)
  valid_output.empty? ? Aspose::Cloud::Common::Utils.download_file(@filename,@filename,folder_name,storage_name,storage_type) : valid_output
end
sort_data(data_sort, cell_area, folder_name = '', storage_type = 'Aspose', storage_name = '') click to toggle source
# File lib/Cells/worksheet.rb, line 490
def sort_data(data_sort, cell_area, folder_name = '', storage_type = 'Aspose', storage_name = '')
  raise 'data_sort not specified.' if data_sort.nil?
  raise 'cell_area not specified.' if cell_area.nil?

  str_uri = "#{@base_uri}/sort"
  qry = { :CellArea => cell_area }

  str_uri = Aspose::Cloud::Common::Utils.build_uri(str_uri,qry)
  str_uri = Aspose::Cloud::Common::Utils.append_storage(str_uri,folder_name,storage_name,storage_type)
  signed_str_uri = Aspose::Cloud::Common::Utils.sign(str_uri)
  JSON.parse(RestClient.post(signed_str_uri, data_sort.to_json, { :content_type => :json, :accept=>'application/json'}))['Code'] == 200 ? true : false
end
unfreeze_panes(row, column, freezed_rows, freezed_columns, folder_name = '', storage_type = 'Aspose', storage_name = '') click to toggle source
# File lib/Cells/worksheet.rb, line 664
def unfreeze_panes(row, column, freezed_rows, freezed_columns, folder_name = '', storage_type = 'Aspose', storage_name = '')
  raise 'row not specified.' if row.nil?
  raise 'column not specified.' if column.nil?
  raise 'freezed_rows not specified.' if freezed_rows.nil?
  raise 'freezed_columns not specified.' if freezed_columns.nil?

  str_uri = "#{@base_uri}/FreezePanes?row=#{row}&column=#{column}&freezedRows=#{freezed_rows}&freezedColumns=#{freezed_columns}"
  str_uri = Aspose::Cloud::Common::Utils.append_storage(str_uri,folder_name,storage_name,storage_type)
  signed_str_uri = Aspose::Cloud::Common::Utils.sign(str_uri)

  response_stream = RestClient.delete(signed_str_uri, {:accept=>'application/json'})
  valid_output = Aspose::Cloud::Common::Utils.validate_output(response_stream)
  valid_output.empty? ? Aspose::Cloud::Common::Utils.download_file(@filename,@filename,folder_name,storage_name,storage_type) : valid_output
end
ungroup_rows(first_index, last_index, folder_name = '', storage_type = 'Aspose', storage_name = '') click to toggle source
# File lib/Cells/worksheet.rb, line 744
def ungroup_rows(first_index, last_index, folder_name = '', storage_type = 'Aspose', storage_name = '')
  raise 'first_index not specified.' if first_index.nil?
  raise 'last_index not specified.' if last_index.nil?          

  str_uri = "#{@base_uri}/cells/rows/ungroup?firstIndex=#{first_index}&lastIndex=#{last_index}"
  str_uri = Aspose::Cloud::Common::Utils.append_storage(str_uri,folder_name,storage_name,storage_type)
  signed_str_uri = Aspose::Cloud::Common::Utils.sign(str_uri)

  response_stream = RestClient.post(signed_str_uri, '', {:accept=>'application/json'})
  valid_output = Aspose::Cloud::Common::Utils.validate_output(response_stream)
  valid_output.empty? ? Aspose::Cloud::Common::Utils.download_file(@filename,@filename,folder_name,storage_name,storage_type) : valid_output
end
unhide_rows(start_row, total_rows, folder_name = '', storage_type = 'Aspose', storage_name = '') click to toggle source
# File lib/Cells/worksheet.rb, line 718
def unhide_rows(start_row, total_rows, folder_name = '', storage_type = 'Aspose', storage_name = '')
  raise 'start_row not specified.' if start_row.nil?
  raise 'total_rows not specified.' if total_rows.nil?          

  str_uri = "#{@base_uri}/cells/rows/unhide?startrow=#{start_row}&totalRows=#{total_rows}"
  str_uri = Aspose::Cloud::Common::Utils.append_storage(str_uri,folder_name,storage_name,storage_type)
  signed_str_uri = Aspose::Cloud::Common::Utils.sign(str_uri)

  response_stream = RestClient.post(signed_str_uri, '', {:accept=>'application/json'})
  valid_output = Aspose::Cloud::Common::Utils.validate_output(response_stream)
  valid_output.empty? ? Aspose::Cloud::Common::Utils.download_file(@filename,@filename,folder_name,storage_name,storage_type) : valid_output
end
unhide_worksheet(folder_name = '', storage_type = 'Aspose', storage_name = '') click to toggle source
# File lib/Cells/worksheet.rb, line 453
def unhide_worksheet(folder_name = '', storage_type = 'Aspose', storage_name = '')
  str_uri = "#{@base_uri}/visible?isVisible=true"
  str_uri = Aspose::Cloud::Common::Utils.append_storage(str_uri,folder_name,storage_name,storage_type)
  signed_str_uri = Aspose::Cloud::Common::Utils.sign(str_uri)
  JSON.parse(RestClient.put(signed_str_uri, '', {:accept=>'application/json'}))['Code'] == 200 ? true : false
end
unmerge_cells(start_row, start_column, total_rows, total_colunms, folder_name = '', storage_type = 'Aspose', storage_name = '') click to toggle source
# File lib/Cells/worksheet.rb, line 772
def unmerge_cells(start_row, start_column, total_rows, total_colunms, folder_name = '', storage_type = 'Aspose', storage_name = '')
  raise 'start_row not specified.' if start_row.nil?
  raise 'start_column not specified.' if start_column.nil?
  raise 'total_rows not specified.' if total_rows.nil?
  raise 'total_colunms not specified.' if total_colunms.nil?

  str_uri = "#{@base_uri}/cells/unmerge?startrow=#{start_row}&startcolumn=#{start_column}&totalrows=#{total_rows}&totalcolumns=#{total_colunms}"
  str_uri = Aspose::Cloud::Common::Utils.append_storage(str_uri,folder_name,storage_name,storage_type)
  signed_str_uri = Aspose::Cloud::Common::Utils.sign(str_uri)

  response_stream = RestClient.post(signed_str_uri, '', {:accept=>'application/json'})
  valid_output = Aspose::Cloud::Common::Utils.validate_output(response_stream)
  valid_output.empty? ? Aspose::Cloud::Common::Utils.download_file(@filename,@filename,folder_name,storage_name,storage_type) : valid_output
end
update_oleobject(index, str_xml, folder_name = '', storage_type = 'Aspose', storage_name = '') click to toggle source
# File lib/Cells/worksheet.rb, line 344
def update_oleobject(index, str_xml, folder_name = '', storage_type = 'Aspose', storage_name = '')
  raise 'index not specified.' if index.nil?
  raise 'str_xml not specified.' if str_xml.empty?          

  str_uri = "#{@base_uri}/oleobjects/#{index}"          
  str_uri = Aspose::Cloud::Common::Utils.append_storage(str_uri,folder_name,storage_name,storage_type)
  signed_str_uri = Aspose::Cloud::Common::Utils.sign(str_uri)
  JSON.parse(RestClient.post(signed_str_uri, str_xml, {:accept=>'application/json'}))['Code'] == 200 ? true : false
end
update_picture(picture_index, picture_data, folder_name = '', storage_type = 'Aspose', storage_name = '') click to toggle source
# File lib/Cells/worksheet.rb, line 571
def update_picture(picture_index, picture_data, folder_name = '', storage_type = 'Aspose', storage_name = '')
  raise 'picture_index not specified.' if picture_index.nil?
  raise 'picture_data not specified.' if picture_data.empty?  

  str_uri = "#{@base_uri}/pictures/#{picture_index}"          
  str_uri = Aspose::Cloud::Common::Utils.append_storage(str_uri,folder_name,storage_name,storage_type)
  signed_str_uri = Aspose::Cloud::Common::Utils.sign(str_uri)
  JSON.parse(RestClient.post(signed_str_uri, picture_data, { :accept=>'application/json'}))['Code'] == 200 ? true : false
end
update_properties(worksheet_name, gridlines_visible = false, pagebreak_preview = false, ruler_visible = false, folder_name = '', storage_type = 'Aspose', storage_name = '') click to toggle source
# File lib/Cells/worksheet.rb, line 828
def update_properties(worksheet_name, gridlines_visible = false, pagebreak_preview = false, ruler_visible = false, folder_name = '', storage_type = 'Aspose', storage_name = '')
  raise 'worksheet_name not specified.' if worksheet_name.empty?

  json_data = { :Name=>worksheet_name, :IsGridlinesVisible=>gridlines_visible, :IsPageBreakPreview=>pagebreak_preview, :IsRulerVisible=>ruler_visible }.to_json
  str_uri = "#{@base_uri}"
  str_uri = Aspose::Cloud::Common::Utils.append_storage(str_uri,folder_name,storage_name,storage_type)
  signed_str_uri = Aspose::Cloud::Common::Utils.sign(str_uri)
  response = RestClient.post(signed_str_uri, json_data, {:content_type=>:json, :accept=>'application/json'})
  json = JSON.parse(response)
  if json['Code'] == 200
    Aspose::Cloud::Common::Utils.download_file(@filename,@filename,folder_name,storage_name,storage_type)
  end
end