Axolot Data

Push

You dont understand me. Small example: 23456 - - a - - 07.01.1900 43 - - f - - 01.01.1900 356675 - - df - - 02.01.1900 XLS[0].Sort(2,XLS[0].FirstRow,2,XLS[0].LastRow,TRUE,TRUE); Result: 23456 - - a - - 01.01.1900 43 - - f - - 02.01.1900 356675 - - df - - 07.01.1900 but it should be 43 - - f - - 01.0...

I think you dont understand me. I will sort full rows, but not only ohne column of a row, and not column 1, but column 2 oder 3.

...

Only a little question:

I have a excel sheet with 3 columns.
How can i sort using column 2 oder 3?

XLS[0].Sort(0,XLS[0].FirstRow,2,XLS[0].LastRow,TRUE,TRUE);

only sorts using column 0.

Thanks for help.

No help? Bad!

Hi, how do i copy cells or rows from one Excel file to another, including formulas und formattings? Excample: var XLS1, XLS2 : TXLSReadWriteII5; begin XLS1.LoadFromFile('file1.xlsx'); XLS2.LoadFromFile('file2.xlsx'); for XLS1[0].FirstRow to XLS1[0].LastRow do begin // how to copy the rows to XLS2[0]...