'Export to Excel' with an excel template possible?

3 posts, 0 answers
  1. Patrick
    Patrick avatar
    2 posts
    Member since:
    Mar 2015

    Posted 08 Feb 2019 Link to this post

    We want to use the "Export to Excel" functionality. (We are using already a lot of the KendoUI controls)
    But as I see its only possible to export the data and do some (colour) formating of the cloumns/ cells. But not any fancy excel features.

    Is it possible to use an existing excel template and fill only one sheet with the data. And on the other, already exsiting, sheets we have some fancy diagrams with links to the sheet, which we want to fill with the "export".
    Is this possible. And if yes how? Didn't find anything about this.

    And is it maybe also possible to create an Google Spreadsheet instead of an Excel Sheet?

    Thanks

  2. Dimiter Topalov
    Admin
    Dimiter Topalov avatar
    1260 posts

    Posted 12 Feb 2019 Link to this post

    Hi Patrick,

    The Kendo UI for Angular ExcelExport functionality generates workbooks from a given data set, and allow for customizing the appearance and formatting of the cells and their values. The developer can also provide excel formulas that will be applied to certain cells for computing their values based on other cells values. All available capabilities and options are listed in the following sections of our documentation and API:

    https://www.telerik.com/kendo-angular-ui/components/excelexport/cells/

    https://www.telerik.com/kendo-angular-ui/components/excelexport/api/WorkbookSheetRowCell/

    https://www.telerik.com/kendo-angular-ui/components/excelexport/api/CellOptions/

    https://www.telerik.com/kendo-angular-ui/components/excelexport/workbook/customization/

    However, exporting directly in a preloaded existing excel files is not supported, nor is exporting to Google Spreadsheet (you can export to an Excel file, and load this file in Google Spreadsheet).

    Regards,
    Dimiter Topalov
    Progress Telerik
    Get quickly onboarded and successful with your Telerik and/or Kendo UI products with the Virtual Classroom free technical training, available to all active customers. Learn More.
  3. Patrick
    Patrick avatar
    2 posts
    Member since:
    Mar 2015

    Posted 12 Feb 2019 in reply to Dimiter Topalov Link to this post

    OK Thanks.

    I will take a look on the docs....

     

Back to Top