Completed
Last Updated: 22 Jul 2020 11:58 by ADMIN
Rohan
Created on: 20 Jul 2020 16:10
Type: Feature Request
0
Customization required for applying filters to the exported excel

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.

Attached Files:
4 comments
Rohan
Posted on: 22 Jul 2020 11:57
Thanks Stephan, we can close this request now.
ADMIN
Stefan
Posted on: 21 Jul 2020 11:42

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

Rohan
Posted on: 21 Jul 2020 10:21

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?

ADMIN
Stefan
Posted on: 21 Jul 2020 07:07

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