SetSort

SetSort(key1, sSortOrder1, key2, sSortOrder2, key3, sSortOrder3, sHeader, sOrientation)

Sorts the cells in the given range by the parameters specified in the request.

Parameters:

Name Type Description
key1 ApiRange | String

First sort field.

sSortOrder1 SortOrder

The sort order for the values specified in Key1.

key2 ApiRange | String

Second sort field.

sSortOrder2 SortOrder

The sort order for the values specified in Key2.

key3 ApiRange | String

Third sort field.

sSortOrder3 SortOrder

The sort order for the values specified in Key3.

sHeader SortHeader

Specifies whether the first row contains header information.

sOrientation SortOrientation

Specifies if the sort should be by row (default) or column.

Returns:

This method doesn't return any data.