add_key method

add_key

Adds sorted column index and sort order.

def add_key(self, key, order):
    ...

Parameter	Type	Description
key	int	The sorted column index(absolute position, column A is 0, B is 1, …)
order	`SortOrder`	The sort order

Adds sorted column index and sort order with custom sort list.

def add_key(self, key, order, custom_list):
    ...

Parameter	Type	Description
key	int	The sorted column index(absolute position, column A is 0, B is 1, …)
order	`SortOrder`	The sort order.
custom_list	str	The custom sort list.

Adds sorted column index and sort order with custom sort list.

def add_key(self, key, order, custom_list):
    ...

Parameter	Type	Description
key	int	The sorted column index(absolute position, column A is 0, B is 1, …)
order	`SortOrder`	The sort order.
custom_list	list	The custom sort list.

Adds sorted column index and sort order with custom sort list.

def add_key(self, key, type, order, custom_list):
    ...

Parameter	Type	Description
key	int	The sorted column index(absolute position, column A is 0, B is 1, …)
type	`SortOnType`	The sorted value type.
order	`SortOrder`	The sort order.
custom_list	any	The custom sort list.

If type is SortOnType.CellColor or SortOnType.FontColor, the customList is Color.