时间戳

首页 > 解决方案 > 如何下载带有绑定字段列的剑道网格excel表？

angular - 如何下载带有绑定字段列的剑道网格excel表？

问题描述

这是我的专栏。这里的第一列我绑定了三个字段。当我将它下载到 Excel 表时，它只有名称和 upc 字段。

  <kendo-grid-column title="{{ 'MPG/PartNumber/Size' | translate}}" width="250">
<ng-template kendoGridCellTemplate let-dataItem>
  <span>{{ dataItem.manufactureCode }}</span>
  <span>{{ dataItem.partNo }}</span>
  <span>{{ dataItem.size }}</span>
</ng-template>
<ng-template kendoGridEditTemplate let-dataItem="dataItem">
  <input [formControl]="formGroup.get('manufactureCode')" class="k-textbox boxtext">
  <input [formControl]="formGroup.get('partNo')" class="k-textbox boxtext">
  <input [formControl]="formGroup.get('size')" class="k-textbox boxtext">
</ng-template></kendo-grid-column>

  <kendo-grid-column field="name" title="{{ 'Description' | translate}}">
<ng-template kendoGridEditTemplate let-column="column" let-formGroup="formGroup" let-isNew="isNew">
  <input #input class="k-textbox" [formControl]="formGroup.get(column.field)">
</ng-template></kendo-grid-column>

  <kendo-grid-column field="upc" title="{{ 'UPC' | translate}}" width="150">
<ng-template kendoGridEditTemplate let-column="column" let-formGroup="formGroup" let-isNew="isNew">
  <input #input class="k-textbox" [formControl]="formGroup.get(column.field)">
</ng-template></kendo-grid-column>

<kendo-grid-excel fileName="Products.xlsx" [fetchData]="allData"></kendo-grid-excel>

标签： angulartypescriptkendo-grid

解决方案

这是方法

  <kendo-grid-excel fileName="Products.xlsx">
<kendo-excelexport-column field="manufactureCode" title="MFG">
</kendo-excelexport-column>
<kendo-excelexport-column field="partNo" title="Part">
</kendo-excelexport-column>
<kendo-excelexport-column field="size" title="Size">
</kendo-excelexport-column>
<kendo-excelexport-column field="name" title="Description">
</kendo-excelexport-column>
<kendo-excelexport-column field="upc" title="UPC">
</kendo-excelexport-column>

推荐阅读