Sorting an opened Excel File that has headers in Row1 and Excel Filtering is on

Posted by: john.brazill on 31 May 2022, 8:26 am EST

  • Posted 31 May 2022, 8:26 am EST

    Hi All,
    I am opening an excel file which has the headings in Row 1 and excel filtering is turned on. Everything looks normal once opened in spread. I can sort and filter any column.
    But how can I do that programmatically? None of the typical spread sorting examples work.
  • Replied 31 May 2022, 4:09 pm EST

    Hi John,

    It seems you have Range AutoFilter in your sheet. You can manage range sorting programmatically as shown in the documentation at
    If you face any issues let us know with a sample replicating the issue.

Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels