I'm French and i'm pretty bad in english but i will try ! Excuse for my bad english.
I try for two weeks to optimize the processing time of the method DataSorter.Sort() with no result. I'm sorting a Excel file with +/- 300 000 rows and 14 columns. At this time, the processing time is more than one hour (i don't know exactly the time, i always stopped after one hour). My file is in .xlsx if this can help you.
My part of code is like this :
- Code: Select all
workbook.DataSorter.SortColumns.Add(7, OderBy.Ascending);
workbook.DataSorter.Sort(worksheet[A1:Q300000]);
Do you have a idea where i can gain time ? Or it's normal the processing time is more than one hour for a sorter on 300 000 rows ?
Best regards,
Gautier.
Edit : I finally decided to let end the processing time, it took like +/- 1H30 - 2H. It's normal when we do it directly on Excel (on 300 000 rows), is like instant ? I remenber it's was just a question, not a reproach !