When export, Add a custom row to Excel with column filters

3 posts, 0 answers
  1. Michael
    Michael avatar
    4 posts
    Member since:
    Mar 2020

    Posted 01 Apr 2020 Link to this post

    I have modified the below code to add my own title row to Excel.

    But, as you see in my screen shot, the column filters were added to the title row instead of the actual data row.

    How can I have the column filters on the data row?

    https://dojo.telerik.com/ekuDetoX/2

  2. Michael
    Michael avatar
    4 posts
    Member since:
    Mar 2020

    Posted 02 Apr 2020 in reply to Michael Link to this post

    I found the solution.

    the key is to add this line.  

    sheet.frozenRows = 2;

     

    https://dojo.telerik.com/ekuDetoX/3

  3. Alex Hajigeorgieva
    Admin
    Alex Hajigeorgieva avatar
    1082 posts

    Posted 06 Apr 2020 Link to this post

    Hello, Michael,

    Just a quick note with the documentation API reference:

    https://docs.telerik.com/kendo-ui/api/javascript/ooxml/workbook/configuration/sheets.frozenrows

    Kind Regards,
    Alex Hajigeorgieva
    Progress Telerik

    Progress is here for your business, like always. Read more about the measures we are taking to ensure business continuity and help fight the COVID-19 pandemic.
    Our thoughts here at Progress are with those affected by the outbreak.
Back to Top