Is it possible to use GridColumn and the footerCell prop and have the footer row export in the Excel export?
I see this example, but it's utilizing the ExcelExportColumn, which doesn't have all of the extra things I want (footerCell, custom cell, header class name, filter, etc) - is there a workaround I'm missing?
Thank you!
2 Answers, 1 is accepted
Rank 4
Bronze
Iron
Iron
Thank you, Stefan! I ended up using a mix of these two docs, as I didn't want to create nearly duplicate code and to have more control over formatting and styling for the export file:
https://www.telerik.com/kendo-react-ui/components/excelexport/customization/
https://www.telerik.com/kendo-react-ui/knowledge-base/excel-export-with-custom-header-footer/
Hello,
The example is showing how to add a footer to the column in Excel. It has different properties because the values in the Grid and in the Excel can be different. The Grid is rendering HTML which is not 100% compatible with Excel, it is a very different format. That is why we have special footer options for Excel that we can use the transfer the same data (the look may not be 100% the same).
I made an example where we have the same footer cell in the Grid and in the Excel file:
https://stackblitz.com/edit/react-bsahy6?file=app/main.jsx
Regards,
Stefan
Progress Telerik
Virtual Classroom, the free self-paced technical training that gets you up to speed with Telerik and Kendo UI products quickly just got a fresh new look + new and improved content including a brand new Blazor course! Check it out at https://learn.telerik.com/.