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 Answers, 1 is accepted
0
Michael
Top achievements
Rank 1
Rank 1
answered on 02 Apr 2020, 04:48 PM
I found the solution.
the key is to add this line.
sheet.frozenRows = 2;
https://dojo.telerik.com/ekuDetoX/3
0
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.
Our thoughts here at Progress are with those affected by the outbreak.