Analyzing your prompt, please hold on...
An error occurred while retrieving the results. Please refresh the page and try again.
Sort Data in Column with Custom Sort List
Contents
[
Hide
]
Possible Usage Scenarios
You can sort data in a column using a custom list. This can be done using the DataSorter.AddKey(int key, SortOrder order, String customList) method. However, this method works only if the items in the custom list do not contain commas. If they contain commas, such as “USA, US” or “China, CN”, you must use the DataSorter.AddKey(int key, SortOrder order, String[] customList) overload. In this overload, the last parameter is not a String but an array of Strings.
Sort Data in Column with Custom Sort List
The following sample code explains how to use the DataSorter.AddKey(int key, SortOrder order, String[] customList) method to sort data with a custom sort list. Please see the sample Excel file used in this code and the output Excel file generated by it. The screenshot below shows the effect of the code on the sample Excel file after execution.
Sample Code