excel.sortorientation.yml

### YamlMime:TSEnum
name: Excel.SortOrientation
uid: 'excel!Excel.SortOrientation:enum'
package: excel!
fullName: Excel.SortOrientation
summary: ''
remarks: >-
  \[ [API set: ExcelApi 1.2](/javascript/api/requirement-sets/excel/excel-api-requirement-sets) \]


  #### Examples


  ```TypeScript

  // Link to full sample:
  https://raw.githubusercontent.com/OfficeDev/office-js-snippets/prod/samples/excel/30-events/event-column-and-row-sort.yaml


  async function sortLeftToRight(criteria: string) {
      await Excel.run(async (context) => {
          const sheet = context.workbook.worksheets.getActiveWorksheet();
          const range = sheet.getRange("A1:E5");

          // Find the row header that provides the sort criteria.
          const header = range.find(criteria, {});
          header.load("rowIndex");
          await context.sync();

          range.sort.apply(
              [
                  {
                      key: header.rowIndex,
                      sortOn: Excel.SortOn.value
                  }
              ],
              false /*matchCase*/,
              true /*hasHeaders*/,
              Excel.SortOrientation.columns
          );
          await context.sync();
      });
  }

  ```
isPreview: false
isDeprecated: false
fields:
  - name: columns
    uid: 'excel!Excel.SortOrientation.columns:member'
    package: excel!
    summary: '* \[ [API set: ExcelApi 1.2](/javascript/api/requirement-sets/excel/excel-api-requirement-sets) \]'
    value: '"Columns"'
  - name: rows
    uid: 'excel!Excel.SortOrientation.rows:member'
    package: excel!
    summary: '* \[ [API set: ExcelApi 1.2](/javascript/api/requirement-sets/excel/excel-api-requirement-sets) \]'
    value: '"Rows"'