dataSort

Skip to end of metadata
Go to start of metadata

dataSort Resource

This resource represents sorting data in a worksheet range.

Resource URI

~/{file-name}/worksheets/{sheet-name}/sort

Request Parameters

Parameter Name HTTP Method(s) Type Query String/HTTPBody Description
CellArea POST string
Query string Cells area to sort.
CaseSensitive POST bool
HTTP body Indicate whether case sensitive when comparing string.
HasHeaders POST
bool
HTTP body
Indicate whether the range has headers.
SortLeftToRight POST
bool
HTTP body
Indicate whether sorting orientation is from left to right.
SortKey List POST
list
HTTP body
Represents list of sorted column index and sort order, SortKey structure defination is below. 
storage POST string Query string The document storage.
folder POST string Query string The document folder.
In case of Amazon S3 storage folder path starts with Amazon S3 bucket name.

SortKey Defination

Member
Type
Description
Key
integer
Represents the sorted column index
SortOrder string
Represents the sort order, Valid values for this parameter appear below
Valid Value for SortOrder
accept Value Description
Ascending Sorts data in ascending order
Descending Sorts data in descending order

HTTP GET

Not supported.

HTTP POST

Returns a JSON/XML representation of cells resource after sorting.


POST http://api.aspose.com/v1.1/cells/myDocument.xlsx/worksheets/Sheet3/sort?cellArea=E15:F21

Request body string:

Data picture before sort:

Response:

Data Picture after sort:

HTTP PUT

Not supported.

HTTP DELETE

Not supported.

Enter labels to add to this page:
Please wait 
Looking for a label? Just start typing.