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.
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.
Figure 1: Activating Export Dialog
Figure 2: Export Dialog
The Spreadsheet client-side API includes the
@(Html.Kendo().Spreadsheet() .Name("spreadsheet") .Excel(ex => ex.FileName("Order.xlsx")) )
Currently, the export module does not handle sorting and filtering. This limitation will be addressed before the widget goes out of its Beta version.