We need to customize our exported excel to contain some additional information to the top rows of the excel sheet.
On using 'filterable' option as true in ExcelExport React component, it's getting applied on the first row but we want those filters to come on header values present on the 2nd/nth row in case we have some additional information on the top rows.
<ExcelExport
data={data}
fileName="Products.xlsx"
ref={(exporter) => { this._exporter = exporter; }}
filterable={true}
>Please refer the attached snapshots for actual and expected results needed from customization.
Hello, Rohan,
Thank you for the confirmation.
Currently, this can only be done by freezing the rows as this will make them act as a header of the document and be always visible when the user scrolls through the data
Regards,
Stefan
Progress Telerik
Hey Stefan,
Thanks for demo example. This is exactly what we wanted as part of this requirement.
Just a question, as we are freezing the number of rows to achieve it, is it possible to have it without freezing the rows?
Hello, Rohan,
This can currently be done by changing the frozen row number as this will tell the component to place the filter row further down:
https://www.telerik.com/kendo-react-ui/components/excelexport/api/WorkbookSheet/#toc-frozenrows
I made an example showcasing this:
https://stackblitz.com/edit/react-tac1tz-mtexuk?file=app%2Fmain.jsx
I saw that we suggested logging this inside a ticket, but please advise if this option will help to cover the requirement.
Regards,
Stefan
Progress Telerik