[Solved] Grid Export to Excel Error .saveAsExcel()

[Dennis]

I'm getting the following error when trying to call the method .saveAsExcel(): "Unable to get property 'length' of undefined or null reference"

Here is code:

$(".download-excel").on("click",
    function() {
        try {
            var grid = $("#DataGrid").data("kendoGrid");
            grid.saveAsExcel();
        } catch (e) {
            fnDialog('Error Exporting Excel',
                'There was an error exporting the excel document. Please contact customer service.',
                null,
                null);
        }
    });

 

If I set a watch on the grid object, I can see the data. For some reason it fails at the grid.saveAsExcel();

[Stefan]

Hello Dennis,

This is not a known issue and it was not reproduced in my testing scenario.

I made an example using similar implementation and the Grid was correctly exported to Excel:

http://dojo.telerik.com/eMoqe

If I missed an important detail, please modify the provided Dojo and I will gladly assist.

Regards,
Stefan
Telerik by Progress

[Karl Williams]

I'm getting the same error. I have the jszip library in the right place and the tool bar button works. The saveAsExcel() function fails with the following error:

Cannot read properties of undefined (reading 'saveAsExcel')

Here's my code:

function ExportExcel() {
try {
var grid = $("#AssetGrid").data("kendoGrid");
grid.saveAsExcel();
} catch (error) {
alert(error);
}
}

[Georgi Denchev]

Hello, Karl,

I tested the Dojo that was provided by my colleague with the latest version of Kendo UI, however it is still working properly.

http://dojo.telerik.com/oRATIhAj 

The error seems to indicate the variable "grid" is undefined. This usually means that the $("#AssetGrid") selector has not found the Grid element. I would recommend that you double-check the name of the id and make sure there are no typos.

In case this doesn't help, could you modify the Dojo to reproduce the error and send it back to me?

Best Regards,

Georgi