Export to Excel Footer

2 posts, 1 answers
  1. Marcin
    Marcin avatar
    195 posts
    Member since:
    Jan 2011

    Posted 08 Sep 2017 Link to this post

    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.
  2. Answer
    Stefan
    Admin
    Stefan avatar
    3072 posts

    Posted 12 Sep 2017 Link to this post

    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.
Back to Top