Note

Access to this page requires authorization. You can try signing in or .

Access to this page requires authorization. You can try .

Excel.Interfaces.TableSortLoadOptions interface

Package:
excel

Manages sorting operations on Table objects.

Remarks

API set: ExcelApi 1.2

Used by

Properties

$all

Specifying $all for the load options loads all the scalar properties (such as Range.address) but not the navigational properties (such as Range.format.fill.color).
fields

Specifies the current conditions used to last sort the table.
matchCase

Specifies if the casing impacts the last sort of the table.
method

Represents the Chinese character ordering method last used to sort the table.

Property Details

$all

Specifying $all for the load options loads all the scalar properties (such as Range.address) but not the navigational properties (such as Range.format.fill.color).

$all?: boolean;

Property Value

boolean

fields

Specifies the current conditions used to last sort the table.

fields?: boolean;

Property Value

boolean

Remarks

API set: ExcelApi 1.2

matchCase

Specifies if the casing impacts the last sort of the table.

matchCase?: boolean;

Property Value

boolean

Remarks

API set: ExcelApi 1.2

method

Represents the Chinese character ordering method last used to sort the table.

method?: boolean;

Property Value

boolean

Remarks

API set: ExcelApi 1.2

Feedback

Was this page helpful?