Hi Veselin.
Your documentation states that you can use spreadsheet.saveAsExcel() - however half of the time I get unknown errors (network error cannot download) when trying to use this.
However - the functionality I asked for, which you have said is not supported, is definitely possible. My solution is below..
var rows = [
{
cells: [ {value: "Item Id", background: "#428bca", vAlign: "center", color: "#ffffff", bold: true} ]
}
];
dataSource.fetch(function () {
var data = this.data();
for (var i = 0; i < data.length; i++) {
rows.push({
cells: [ {value: data[i].skuId} ]
})
}
var workbook = new kendo.ooxml.Workbook({
sheets: [
{
columns: [
{autoWidth: true}, {autoWidth: true}, {autoWidth: true}, {autoWidth: true}, {autoWidth: true},
{autoWidth: true}, {autoWidth: true}, {autoWidth: true}, {autoWidth: true}, {autoWidth: true},
{autoWidth: true}, {autoWidth: true}, {autoWidth: true}, {autoWidth: true}, {autoWidth: true},
{autoWidth: true}, {autoWidth: true}, {autoWidth: true}, {autoWidth: true}, {autoWidth: true},
{autoWidth: true}, {autoWidth: true}, {autoWidth: true}, {autoWidth: true}, {autoWidth: true},
{autoWidth: true}, {autoWidth: true}, {autoWidth: true}, {autoWidth: true}, {autoWidth: true},
{autoWidth: true}
],
title: "Sheet1-Data",
rows: rows
}
]
});
This definitely works every time, for hundreds of thousands of rows and around 150 columns.