Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Sort 'StrCmpLogicalW' in excel
#1
Is possible to sort a table in excel using StrCmpLogicalW?
#2
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")
#3
Thanks but I was looking for something like ExcelSheet.Sort
#4
My old Excel sorts numbers not like StrCmpLogicalW, eg a10 before a2. Don't know how to sort like StrCmpLogicalW.


Forum Jump:


Users browsing this thread: 1 Guest(s)