New to Kendo UI for jQuery? Start a free 30-day trial

ExcelExport

events

Fires when the user clicks the Export to Excel toolbar button.

excelExport

Event Data

e.sender `kendo.ui.Spreadsheet`

The widget instance which fired the event.

e.data `Array`

The array of data items that is used to create the Excel workbook.

e.workbook `kendo.ooxml.Workbook`

The Excel workbook configuration object. Used to initialize a kendo.ooxml.Workbook class. Modifications of the workbook will reflect in the output Excel document.

e.preventDefault `Function`

If invoked, the Spreadsheet will not save the generated file.

<div id="spreadsheet"></div>
<script>
    $("#spreadsheet").kendoSpreadsheet({
        sheets: [{
            name: "Food Order",
            mergedCells: [
                "A1:G1"
            ],
            rows: [{
                height: 70,
                cells: [{
                    value: "My Company", fontSize: 32, textAlign: "center"
                }]
            }],
        }],
        excelExport: function(e) {
        e.workbook.fileName = "Spreadsheet1.xlsx";
        }
    });

    var spreadsheet = $("#spreadsheet").data("kendoSpreadsheet");
    spreadsheet.saveAsExcel();
</script>

<div id="spreadsheet"></div>
<script>
    $("#spreadsheet").kendoSpreadsheet({
        sheets: [{
            name: "Food Order",
            mergedCells: [
                "A1:G1"
            ],
            rows: [{
                height: 70,
                cells: [{
                    value: "My Company", fontSize: 32, textAlign: "center"
                }]
            }],
        }]
    });

    var spreadsheet = $("#spreadsheet").data("kendoSpreadsheet");
    spreadsheet.bind("excelExport", function(e) {
        e.workbook.fileName = "Spreadsheet1.xlsx";
    });

    spreadsheet.saveAsExcel();
</script>

ExcelExport

excelExport

Event Data

e.sender kendo.ui.Spreadsheet

e.data Array

e.workbook kendo.ooxml.Workbook

e.preventDefault Function

e.sender `kendo.ui.Spreadsheet`

e.data `Array`

e.workbook `kendo.ooxml.Workbook`

e.preventDefault `Function`