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

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

• 

  john.brazill

  • Post Options:
  • Link
    Copy

  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.

• 

  avnish.kumar

  

  • Post Options:
  • Link
    Copy

  Posted 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 https://www.grapecity.com/spreadnet/docs/versions/v14/online-win/spwin-sort-range.html.
  
  If you face any issues let us know with a sample replicating the issue.

  Regards
  
  Avnish