excel - Kendo Angular网格在Excel Angular 4中导出数据时添加静态列

Question

我想使用以下代码导出Excel中的数据

<kendo-excelexport [data]="excelData" [group]="groups" [filterable]="true" fileName="exceldata.xlsx" #excelexport>
    <kendo-excelexport-column title="title">
        <ng-template kendoExcelExportCellTemplate let-dataItem>
            {{dataItem.isTrue == 1 ? "title" }}
        </ng-template>
        <ng-template kendoExcelExportGroupFooterTemplate let-group="group" let-aggregates>
            <span> Total</span>
        </ng-template>
        <ng-template kendoExcelExportFooterTemplate let-column="column">
            <span>Grand Total</span>
        </ng-template>
    </kendo-excelexport-column>
</kendo-excelexport>

请帮我解决这个问题。

提前致谢

Answer 1

Excel 导出不使用列模板来格式化值或自定义数据，请参阅以下链接以获取进一步说明 https://www.telerik.com/kendo-angular-ui/components/grid/export/excel-export/#toc-known-limitations