'Export to Excel' with an excel template possible?

[Patrick]

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

[Dimiter Topalov]

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

[Patrick]

OK Thanks.

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