Sort 'StrCmpLogicalW' in excel

[Lucas]

Is possible to sort a table in excel using StrCmpLogicalW?

[Gintaras]

Macro Macro2769

Code:

Copy      Help

ExcelSheet es.Init
ARRAY(str) a
es.CellsToArray(a "A:A")
if(a.len(1)>1) out "note: this example sorts 1-column array or using 1-st column in multicolumn array. Sorting using other column is possible with callback function, read more in sort help."
a.sort(8)
out a
es.CellsFromArray(a "B:B")

[Lucas]

Thanks but I was looking for something like ExcelSheet.Sort

[Gintaras]

My old Excel sorts numbers not like StrCmpLogicalW, eg a10 before a2. Don't know how to sort like StrCmpLogicalW.