Sort On Multiple Columns

[obeltrami]

Hello,

I searched for a way to sort by multiple columns (first D then A, for example) and I saw in the release notes that version 5.10 had "New Sort method for sorting columns. Can sort on multiple columns.".

But the 2 overloaded Sort() functions do not seem to allow to sort on multiple columns AFAIK. I also could not find it in the doc-o-matic documentation.

Could you share example code of sorting a sheet by column D then A, for example ?

Very best regards,

Olivier

[larsa]

Hello

Here is an example which will sort on columns C and D:

Code: Select all

XLS[0].Sort(2,0,4,XLS_MAXROW,True,True);

[nagygabor679]

Hi,
How can I sort whole table by X (any) column?
Thanks,
Gábor