This is a migrated thread and some comments may be shown as answers.
Export to Excel Footer
1 Answer 25 Views
This is a migrated thread and some comments may be shown as answers.
Marcin
Top achievements
Rank 1
Marcin asked on 08 Sep 2017, 01:30 PM
Footer is treated as string values (because of possible text, etc), which make sense. However I would like to export footer as numbers. I know I can post proces workbook on excelExport event, but I need some clarifications. I would need to access to agregates of exported data. Is is possible? Or instead of accessing e.data property is better to get values directly from data source.

1 Answer, 1 is accepted

Sort by
0
Accepted
Stefan
Telerik team
answered on 12 Sep 2017, 12:30 PM
Hello Marcin,

If the aggregates will be only numbers with no text, then the cell value can be parsed to int and then used for additional custom calculations.

I made an example where I added 20 to the aggregates value:

https://dojo.telerik.com/IBEyu

If there is text in the footer then a custom logic has to be used to subtract only the number part from the text in order to parse it.

Regards,
Stefan
Progress Telerik
Try our brand new, jQuery-free Angular 2 components built from ground-up which deliver the business app essential building blocks - a grid component, data visualization (charts) and form elements.
Tags
Grid
Asked by
Marcin
Top achievements
Rank 1
Answers by
Stefan
Telerik team
Share this question
or