How to do Excel Export with multiple Worksheets

[Noah]

It looks like in the documentation there is support for generating workbooks with multiple sheets, but it is not clear to me how to do that.  Is there a declarative way that I am missing like 

 

<kendo-excelexport>

     <kendo-excelexport-sheet name="sheet1">

...columns for sheet 1

</kendo-excelexport-sheet>

     <kendo-excelexport-sheet name="sheet2">
...columns for sheet 2
</kendo-excelexport-sheet>

</kendo-excelexport>

[Dimiter Topalov]

Hi Noah,

The desired functionality is not supported out-of-the-box, but can be achieved via some custom implementation. Here is an example of two separate arrays, exported to different excel sheets of the same excel workbook that can point you in the right direction:

http://plnkr.co/edit/1nuxnxXTlv3NMhC8JeDT?p=preview

For any functionality, features and enhancements that are currently not currently built-in, we strongly encourage submitting feature requests to our UserVoice portal:

http://kendoui-feedback.telerik.com/forums/555517-kendo-ui-for-angular-feedback

It is our primary indicator of customer interest in certain features, and helps us prioritize, based on the demand when updating our roadmap. If you have the time, please submit a request, describing the desired functionality and the use case for such an enhancement. Thank you in advance.

Regards,
Dimiter Topalov
Progress Telerik

[Robert]

Hi Noah,

FYI...the Plunker link you posted is to a SPINNER EXAMPLE not an Excel example.

[Dimiter Topalov]

Hi,

The Plunker is rather outdated, but the relevant code is still applicable. Here is a working Stackblitz demo with the same code and updated Angular and Kendo UI for Angular versions:

https://stackblitz.com/edit/angular-1n2udv?file=app/app.component.ts

Regards,
Dimiter Topalov
Progress Telerik

[keerthi]

 

how can we set the names for the generated sheets instead of Sheet1, sheet2 for dynamically. Can you provide an example for the below https://www.telerik.com/kendo-angular-ui/components/excelexport/how-to/export-to-separate-sheets/ concept where we are dynamically generating the sheets and generating to the workbook

 

[Dimiter Topalov]

Hello Keerthi,

Each sheet name can be set via the respective WorkbookSheet "name" option:

https://www.telerik.com/kendo-angular-ui/components/excelexport/api/WorkbookSheet/#toc-workbooksheet

Here is the updated documentation example:

https://stackblitz.com/edit/angular-tppg62?file=app/app.component.ts

I hope this helps.

Regards,
Dimiter Topalov
Progress Telerik