Trier les données dans les feuilles de calcul
Contents
[
Hide
]
Ci-dessous se trouve l’exemple de code de comparaison pour VSTO et Aspose.Cells.
VSTO
Excel.Workbook myWorkbook = this.Application.Workbooks.Open(fileName);
Excel.Worksheet mySheet = myWorkbook.ActiveSheet;
Excel.Range Colors = mySheet.get_Range("A1", "A10");
Colors.Sort(
Colors.Rows[1], Excel.XlSortOrder.xlAscending,
Colors.Rows[2], missing, Excel.XlSortOrder.xlAscending,
missing, Excel.XlSortOrder.xlAscending,
Excel.XlYesNoGuess.xlNo, missing, missing,
Excel.XlSortOrientation.xlSortColumns,
Excel.XlSortMethod.xlPinYin,
Excel.XlSortDataOption.xlSortNormal,
Excel.XlSortDataOption.xlSortNormal,
Excel.XlSortDataOption.xlSortNormal);
Aspose.Cells
Workbook myWorkbook = new Workbook(fileName);
Worksheet mySheet = myWorkbook.Worksheets[myWorkbook.Worksheets.ActiveSheetIndex];
DataSorter sorter = myWorkbook.DataSorter;
sorter.Order1 = Aspose.Cells.SortOrder.Ascending;
sorter.Key1 = 0;
sorter.Sort(mySheet.Cells, 0, 0, 10, 0);
myWorkbook.Save(fileName);