Aspose.Cells.Examples.CSharp.Articles.SortData.Run C# (CSharp) 메소드

        public static void Run()
        {
            // ExStart:1
            // The path to the documents directory.
            string dataDir = RunExamples.GetDataDir(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType);
            
            // Open an Excel file
            Workbook workbook = new Workbook(dataDir+ "Book_SourceData.xlsx");

            // Accessing the first worksheet in the Excel file
            Worksheet worksheet = workbook.Worksheets[0];

            // Get the cells collection in the sheet
            Cells cells = worksheet.Cells;

            // Obtain the DataSorter object in the workbook
            DataSorter sorter = workbook.DataSorter;

            // Set the first order
            sorter.Order1 = Aspose.Cells.SortOrder.Ascending;
            // Define the first key.
            sorter.Key1 = 0;
            // Set the second order
            sorter.Order2 = Aspose.Cells.SortOrder.Ascending;
            // Define the second key
            sorter.Key2 = 1;

            // Create a cells area (range).
            CellArea ca = new CellArea();

            // Specify the start row index.
            ca.StartRow = 1;
            // Specify the start column index.
            ca.StartColumn = 0;
            // Specify the last row index.
            ca.EndRow = 9;
            // Specify the last column index.
            ca.EndColumn = 2;

            // Sort data in the specified data range (A2:C10)
            sorter.Sort(workbook.Worksheets[0].Cells, ca);

            // Saving the excel file in the default (that is Excel 2003) format
            workbook.Save(dataDir+ "outBook_SortedData.out.xlsx");
            // ExEnd:1
        }
    }