# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-perl/
use strict;
use warnings;
use utf8; 
use File::Slurp;
use MIME::Base64;
use AsposeCellsCloud::CellsApi;
my $config = AsposeCellsCloud::Configuration->new( client_id => $ENV{'ProductClientId'}, client_secret => $ENV{'ProductClientSecret'});
my $instance = AsposeCellsCloud::CellsApi->new(AsposeCellsCloud::ApiClient->new( $config));

my $remoteFolder = 'TestData/In';
my $remoteName = 'Book1.xlsx';
my $request = AsposeCellsCloud::Request::PutWorksheetFormatConditionRequest->new();
$request->{name} =  $remoteName;
$request->{sheet_name} =  'Sheet1';
$request->{index} =  0;
$request->{cell_area} =  'A1:C10';
$request->{type} =  'CellValue';
$request->{operator_type} =  'Between';
$request->{formula1} =  'v1';
$request->{formula2} =  'v2';
$request->{folder} =  $remoteFolder;
$request->{storage_name} =  '';
my $result =  $api->put_worksheet_format_condition(request=> $request);