Forum Discussion

Copper Contributor

Mar 13, 2025

Solved

Office Scripts Custom Sort Failing During Automation

I am attempting to use office scripts within a OneDrive Excel document within Microsoft Teams to run a custom sort. Using the "Record Action" feature, I simply attempted to sort the range H3:J28 via ...

Mar 13, 2025

Please try

function main(workbook: ExcelScript.Workbook) {

    const sheet = workbook.getActiveWorksheet()
    const range = sheet.getRange("H3:J28")

    const rangeSort: ExcelScript.SortField = {
        ascending: true,
        key: 0,
        sortOn: ExcelScript.SortOn.value
    }

    range.getSort().apply(
        [rangeSort],
        false,  // case insensitive
        false,  // no headers
        ExcelScript.SortOrientation.rows
    )

}

SergeiBaklan

Diamond Contributor

Mar 13, 2025

Please try

function main(workbook: ExcelScript.Workbook) {

    const sheet = workbook.getActiveWorksheet()
    const range = sheet.getRange("H3:J28")

    const rangeSort: ExcelScript.SortField = {
        ascending: true,
        key: 0,
        sortOn: ExcelScript.SortOn.value
    }

    range.getSort().apply(
        [rangeSort],
        false,  // case insensitive
        false,  // no headers
        ExcelScript.SortOrientation.rows
    )

}

lli99
Copper Contributor
Mar 26, 2025
Hi I'm trying to do the same, but with two custom sort levels keep getting errors. Can you help?
}// Custom sort on range range A2:AV610 on selectedSheet
selectedSheet.getRange("A2:AV610").getSort().apply([{ key: 5, ascending: true }, { key: 0, ascending: true }], false, true, ExcelScript.SortOrientation.columns);
- SergeiBaklan
  Diamond Contributor
  Mar 27, 2025
  Can't reproduce any errors, it works
  
  function main(workbook: ExcelScript.Workbook) { const sheet = workbook.getActiveWorksheet() sheet.getRange("A2:AV610") .getSort().apply( [ { key: 5, ascending: true }, { key: 0, ascending: true } ], false, true, ExcelScript.SortOrientation.columns ) }
  
  Columns become sorted.
  - lli99
    Copper Contributor
    Mar 27, 2025
    Oh I didn't use the bracket, it works now thank you!