# For complete examples and data files, please go to https://github.com/aspose-words/Aspose.Words-for-Cloud
require 'aspose_cells_cloud'

class ConditionalFormatting

  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

  # Clear cells contents.
  def put_worksheet_format_condition_area
    name = $BOOK1
    sheet_name = $SHEET1
    index = 0
    cell_area = $CELLAREA
    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_conditional_formattings_put_worksheet_format_condition_area(name, sheet_name, index, cell_area, { :folder=>folder})
    expect(result.code).to eql(200)
  end

end

conditional_formatting = ConditionalFormatting.new()
puts conditional_formatting.put_worksheet_format_condition_area