kendo-excelexport-column template

[alex]

hi, I would like to know how it is possible to insert a template for the single column.
I would like to apply a template to the cell for example to print a text and not the value of the field

Something like this:

<kendo-grid-excel fileName="{{fileName}}" [fetchData]="_allData">
    <ng-container *ngFor="let item of _excelColumns">
        <kendo-excelexport-column [field]="item.field" [title]="item.title" [hidden]="item.hidden" [cellOptions]="item.cellOptions" [width]="item.width">
            <ng-template let-dataItem>
                Hello world
              </ng-template>
        </kendo-excelexport-column>
    </ng-container>
</kendo-grid-excel>

 

 

hello world not displayed

 

Great regards,

Alex

 

 

[Georgi]

Hi Alex,

Thank you for the provided information and code snippet.

Custom templates are a known limitation for exporting to Excel. It is documented in this article:

"The Grid does not export its detail template to Excel. The reason for this behavior is that the detail template might contain arbitrary HTML which cannot be converted to Excel column values."

You can, however, use different data when exporting your grid to excel. A custom fetchData callback could be used for this purpose. A little more info and an example are present here.

In this example I have used a simple map function to displace the original value of the cell with a different, custom value.

Hope this helps - please do let me know if it does and/or if you require any further assistance on this issue.

 

Regards,
Georgi
Progress Telerik