Excel export shows empty column for fields that have array of simple strings as values

[Noah]

columns: [
  {field: 'EmptyExport', values: ['red', 'white', 'blue']},
  {field: 'GoodExport', values: [
    {text: 'red', value: 'red'},
    {text: 'white', value: 'white'},
    {text: 'blue', value: 'blue'}]
  }
]

If you use the excel export feature for a grid with the columns listed above, the 'EmptyExport' field values don't make it into the excel grid (it's just an empty column), but the GoodExport field values do.

This is with version 2016.1.322

[Dimiter Madjarov]

Hello Noah,

I am unable to reproduce the behavior on my end. Here is a small example that demonstrates the feature in action. There is no CDN for version 2016.1.322, but the behavior is the same there too.

Regards,
Dimiter Madjarov
Telerik

 

 

[Noah]

Exports Blank column

I don't know if that link will work, but if not, if you replace the grid definition in your dojo with the below, you will see the blank column when you export.

$("#grid").kendoGrid({
  toolbar: ["excel"],
  excel: {
    allPages: true
  },
  columns: [
    { field: "productName" },
    { field: "category", values: [
      "Beverages",
      "Food"
    ] }
  ],
  dataSource: [
    { productName: "Tea", category: "Beverages" },
    { productName: "Ham", category: "Food" }
  ]
});

[Dimiter Madjarov]

Hello Noah,

The current implementation is incorrect. As stated in the documentation each item in the columns.values array must have a text and value field. An array of strings is not supported in this case.

Regards,
Dimiter Madjarov
Telerik