using Aspose.Cells.Cloud.SDK.Api;
using Aspose.Cells.Cloud.SDK.Model;
using Aspose.Cells.Cloud.SDK.Request;
using System;
using System.IO;
using System.Collections.Generic;

CellsApi cellsApi = new CellsApi(Environment.GetEnvironmentVariable("CellsCloudTestClientId"), Environment.GetEnvironmentVariable("CellsCloudTestClientSecret"));
string remoteFolder = "TestData/In";

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



var dataSorter = new DataSorter()
{
    CaseSensitive = true
};
var request = new PostWorksheetRangeSortRequest(
    name: remoteName,
    sheetName: "Sheet1",
    cellArea: "A1:C10",
    dataSorter: dataSorter,
    folder: remoteFolder,
    storageName: ""
);
cellsApi.PostWorksheetRangeSort(request);