Hi Team,
We want to sort our excel from left to right.
I want to sort from row 1 to row 5000 using sort by row 13.
It is sorting all the rows below row 13 but the rows above row 13 remains unsorted.
CODE below:
DataSorter dataSorter =
OutputexcelWorkbookPreview.DataSorter;
dataSorter.SortLeftToRight = true;
dataSorter.Key1 = 12;
dataSorter.Order1 = Aspose.Cells.SortOrder.Ascending;
dataSorter.Key2 = 11;
dataSorter.Order2 = Aspose.Cells.SortOrder.Ascending;
dataSorter.HasHeaders = false;
dataSorter.CaseSensitive = false;
CellArea ca = new CellArea();
ca.StartRow = 0;
ca.StartColumn = 18;
ca.EndRow = 5000;
ca.EndColumn = 34;
dataSorter.Sort(OutputexcelWorkbookPreview.Worksheets[“Output”].Cells, ca);
OutputexcelWorkbookPreview.Save(Server.MapPath(OutputDownloadpath + “/” + “OutputFile_PreviewForTest1.xlsx”));
Could you help with this request?
Regards,
Sumit Agarwal