# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-ruby
require 'aspose_cells_cloud'

class Hyperlink

  include AsposeCellsCloud

  def initialize
     #Get client_id and client_secret from https://cloud.aspose.com
   
    @instance =  AsposeCellsCloud::CellsApi.new($client_id,$client_secret,$api_version,$baseurl) 
  end

  # Update worksheet hyperlink by index
  def update_worksheet_hyperlink_by_index
    name = $BOOK1
    sheet_name = $SHEET1
    hyperlink_index = 0
    hyperlink = AsposeCellsCloud::Hyperlink.new({:Address=>'www.aspose.com'})
    folder = $TEMPFOLDER
    result = @instance.upload_file( folder+"/"+name,  ::File.open(File.expand_path("data/"+name),"r") {|io| io.read(io.size) })
    expect(result.uploaded.size).to  be > 0
    result = @instance.cells_hypelinks_post_worksheet_hyperlink(name, sheet_name, hyperlink_index, { :hyperlink=>hyperlink, :folder=>folder})
    expect(result.code).to eql(200)
  end

end

hyperlink = Hyperlink.new()
puts hyperlink.update_worksheet_hyperlink_by_index