Set Auto Filter Row/Column and Export it to Excel

Posted by: dikl99 on 8 September 2017, 2:41 pm EST

  • Posted 8 September 2017, 2:41 pm EST

    Hello,

    How do i Set Auto Filter Row/Column and Export it to Excel?

    Thanks,
    Udi

  • Replied 8 September 2017, 2:41 pm EST

    Hello,

    FilterItems are not exported to Excel, only the filtered view can be saved to Excel using SaveAsFiltered ExcelSaveFlags in SaveExcel method. However, if you want to save the filterItems as well then you can save it in XML rather than Excel.

    Hope this will help you. Thanks.

  • Replied 8 September 2017, 2:41 pm EST

    Thanks

    Well, i mainly want the Auto filters drop down to appear, i don't to filter any row, just to provide the excel file with the filter row ready.... any idea?

  • Replied 8 September 2017, 2:41 pm EST

    Hello,

    DropDown containing all the filter items is not exported to Excel. However, if you just want to save the filtered view which we get after filtering has been applied on any of the filter items then you can use SaveAsFiltered ExcelSaveFlags in SaveExcel method as I have already mentioned in my previous post.

    Thanks.

Need extra support?

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

Learn More

Forum Channels