排序性能问题:对于百万级大数据,排序没有成功

Aspose.Cells Product Family
1

小表格中可以排序，百万行的大表。我尝试了两种办法，都没有取得成功
方法1:
Aspose.Cells.GridDesktop.Worksheet sheet = gridDesktop1.GetActiveWorksheet();
int izdh = sheet.RowsCount;
int izdl = sheet.ColumnsCount;
int idqh = sheet.GetFocusedCell().Column;

        int[] intArray = new int[1];
        intArray[0] = idqh;
        string ssjbmc = sheet.Name;

        Aspose.Cells.GridDesktop.SortOrder[] lsorsz=new Aspose.Cells.GridDesktop.SortOrder[1];
        lsorsz[0] = Aspose.Cells.GridDesktop.SortOrder.Ascending;
        sheet.Cells.Sort(1, 0, izdh - 1, izdl, intArray, lsorsz,SortOrientation.SortTopToBottom,false);
        gridDesktop1.Invalidate();

方法2:
Aspose.Cells.GridDesktop.Worksheet sheet = gridDesktop1.GetActiveWorksheet();
int izdh = sheet.RowsCount;
int izdl = sheet.ColumnsCount;

int idqh = sheet.GetFocusedCell().Column;
int[] intArray = new int[1];
intArray[0] = idqh;
string ssjbmc = sheet.Name;
Aspose.Cells.GridDesktop.SortOrder[] lsorsz = new Aspose.Cells.GridDesktop.SortOrder[1];
lsorsz[0] = Aspose.Cells.GridDesktop.SortOrder.Ascending;
SortRange sr = new SortRange(sheet,1,
0, izdh - 1, izdl,
SortOrientation.SortTopToBottom, false);
sr.Sort(intArray, lsorsz);
gridDesktop1.Invalidate();

2

文件在前面有个问题里发过了： Aspose.Cells.GridDesktop的多次循环还是有问题：System.IndexOutOfRangeException:“Index was outside the bounds of the array.” - Free Support Forum - aspose.com

3

@hudaming
小文件可以么，大文件等我们回头做下测试

4

@hudaming
6万条记录花了几秒钟
百万条记录的就卡在那了

5

@hudaming
这个直接用excel打开来排序也要话费很长时间的

QQ截图20240102114326.png1607×716 44.7 KB
QQ截图20240102114326.png (44.7 KB)

我们记录了一个单子来跟踪这个性能问题

Issue ID(s): CELLSNET-54903

You can obtain Paid Support Services if you need support on a priority basis, along with the direct access to our Paid Support management team.

6

这个问题,我已经通过其他方式来解决.所以这个功能,我暂时不需要了

7

@hudaming
感谢你的反馈。很高兴你的问题通过其他方式得到了解决。你反映的问题我们已经建立了内部单子，我们会持续优化完善产品。如果你有任何疑问，请随时联系我们。