<?php
require_once('vendor\autoload.php');
use \Aspose\Cells\Cloud\Api\CellsApi;
use \Aspose\Cells\Cloud\Request\PostWorksheetRangeSortRequest;

$CellsCloudClientId = "...." ; # get from https://dashboard.aspose.cloud/#/applications
$CellsCloudClientSecret = "....";  # get from https://dashboard.aspose.cloud/#/applications
$cellsApi = new CellsApi($CellsCloudClientId , $CellsCloudClientSecret );

$remoteFolder = "TestData/In";

$localName = "Book1.xlsx";
$remoteName = "Book1.xlsx";

$dataSorter = new \Aspose\Cells\Cloud\Model\DataSorter();
$dataSorter->setCaseSensitive('true' ); 

 
$request = new PostWorksheetRangeSortRequest();
$request->setName( $remoteName);
$request->setSheetName( "Sheet1");
$request->setCellArea( "A1:C10");
$request->setDataSorter( $dataSorter);
$request->setFolder( $remoteFolder);
$request->setStorageName( "");
$cellsApi->postWorksheetRangeSort($request);