Kendo UI for jQuery Spreadsheet Overview
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.
The Spreadsheet is part of Kendo UI for jQuery, a
professional grade UI library with 110+ components for building modern and feature-rich applications. To try it out sign up for a free 30-day trial.
The Spreadsheet is part of Kendo UI for jQuery, a professional grade UI library with 110+ components for building modern and feature-rich applications. To try it out sign up for a free 30-day trial.
Initializing the Spreadsheet
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.
Functionality and Features
- Cell formatting
- Custom editors
- Custom functions
- Import and export of data
- End-user guide