we are trying to use Kendo UI grid export to excel functionality in IE9, but it doesn't work.
when we click on Export to Excel, it throws "POST" not supported error on server side. our datasource is remote URI, we have server side pagination, but even if we switched to local static datasource, Kendo seems still fire event to server. we wonder if anyone can help us to resove this issue.
Thanks.
Here is our code snippet.
var list = [
{type:'a', id: '1', date:'09/11/2001',
submittedBy: 'Vin Diesel', submittedDate: '12/11/2001'},
{type:'b', id: '2', date:'11/02/2012',
submittedBy: 'Brad Pitt', submittedDate: '11/11/2012'},
{type:'c', id: '3', date:'06/05/2004',
submittedBy: 'Hugh Grant', submittedDate: '12/11/2004'}
];
var localList = new kendo.data.DataSource({
data: list,
pageSize: 2
});
$scope.onSearchClick = function(o) {
$("#grid").kendoGrid({
toolbar: ["excel"],
excel: {
fileName: "Kendo UI Grid Export.xlsx"
},
dataSource: localList,
pageable: true,
resizable: true,
pageSize:2,
sortable : {
mode : 'multiple'
},
columns: [
{ field: 'type', title: 'Type' },
{ field: 'id', title: 'Event ID' },
{ field: 'date', title: 'Date' },
{ field: 'submittedBy', title: 'Submitted By' },
{ field: 'submittedDate', title: 'Submitted Date' }
],
});
var grid = $("#grid").data("kendoGrid");
//grid.dataSource.read();
};
when we click on Export to Excel, it throws "POST" not supported error on server side. our datasource is remote URI, we have server side pagination, but even if we switched to local static datasource, Kendo seems still fire event to server. we wonder if anyone can help us to resove this issue.
Thanks.
Here is our code snippet.
var list = [
{type:'a', id: '1', date:'09/11/2001',
submittedBy: 'Vin Diesel', submittedDate: '12/11/2001'},
{type:'b', id: '2', date:'11/02/2012',
submittedBy: 'Brad Pitt', submittedDate: '11/11/2012'},
{type:'c', id: '3', date:'06/05/2004',
submittedBy: 'Hugh Grant', submittedDate: '12/11/2004'}
];
var localList = new kendo.data.DataSource({
data: list,
pageSize: 2
});
$scope.onSearchClick = function(o) {
$("#grid").kendoGrid({
toolbar: ["excel"],
excel: {
fileName: "Kendo UI Grid Export.xlsx"
},
dataSource: localList,
pageable: true,
resizable: true,
pageSize:2,
sortable : {
mode : 'multiple'
},
columns: [
{ field: 'type', title: 'Type' },
{ field: 'id', title: 'Event ID' },
{ field: 'date', title: 'Date' },
{ field: 'submittedBy', title: 'Submitted By' },
{ field: 'submittedDate', title: 'Submitted Date' }
],
});
var grid = $("#grid").data("kendoGrid");
//grid.dataSource.read();
};