The Spreadsheet allows you to edit and visualize tabular data by using cell formatting options, styles, and themes.
The Spreadsheet supports Internet Explorer 9 and later versions. The widget is primarily targeted at desktop users and, therefore, its performance and functionalities on mobile devices are limited.
To initialize the Spreadsheet, use an empty
<div> element. For more information, refer to the article on widget initialization in Kendo UI.
<div id="spreadsheet"> </div> <script> $("#spreadsheet").kendoSpreadsheet(); </script>
The Spreadsheet instance exposes methods for sheet instance retrieval, insertion, and deletion.
- A common method is the
sheetobject instance interface enables you to configure the settings and data on the sheet level.
- You can use the
rangemethod for retrieval of a
rangeinstance that you can use to manipulate one or more cell regions of the sheet. To retrieve the
rangemethod, use a string with an A1 or an RC notation.
The following example demonstrates how to set the value for a range of cells.
- Cell formatting
- Custom editors
- Custom functions
- Import and export of data
- End-user guide