sort like Excel "expanding sort"

[kindman]

Hey, good time
Is it possible to expanding sort in columns? (XLSReadWrite) Because sorting the column will only sort the same column, not adjacent rows
How to sort like expanding sort Excel?

[larsa]

Hello

Yes, you can do do. Use:
Sort(ACol1, ARow1, ACol2, ARow2: integer; const AAscending,ACaseSencitive: boolean);

Example:
XLS[0].Sort(0,0,1,9,True,False);

[kindman]

Thanks for the post but if we want to sort by column 1 to row 9 but columns after column 1 will not be moved accordingly (if sort by column 1)...

[larsa]

Hello

Do you have an example on how to do this sort? You can send me an Excel file with before and after sorting.