Excel Export

The Spreadsheet utilizes the Kendo UI for jQuery Excel export framework to produce Excel files directly in the browser.

The output files are in the OOXML Spreadsheet format with an .xlsx extension. The legacy .xls binary format is not supported.

User Interface

The default toolbar configuration includes an Export button. Clicking it opens a dialog box for entering the file name and selecting the desired output format for the exported document.

Activating the Export to Excel dialog

The following image demonstrates the export of the Spreadsheet data to Excel.

Exporting to Excel

API Export Reference

The Spreadsheet client-side API includes the saveAsExcel method for initiating the export with JavaScript. This method does not ask you to specify a file name. Instead, it sets the value in excel.fileName.

    @(Html.Kendo().Spreadsheet()
        .Name("spreadsheet")
        .Excel(ex => ex.FileName("Order.xlsx"))
    )

Known Issues

Currently, the export module does not handle sorting and filtering. This limitation will be addressed before the widget goes out of its Beta version.

See Also

In this article
Not finding the help you need? Improve this article