The Kendo UI Spreadsheet widget enables you to edit and visualize tabular data by using cell formatting options, styles, and themes.
Out of the box, the Spreadsheet supports:
- Selection and activation of cells that are functionally similar to ones in Excel.
- Selection of cell and background colors.
- Validation, insertion, deletion, editing, and merging of cells.
- Vertical and horizontal alignment of cells.
- Formatting of cells, including the provision of fonts and font sizes, application of borders, rendering of content in bold, italics and underline styles.
- Formatting of data, including the provision of the number, currency, accounting, date, time, percentage, fraction, scientific, text, special, and custom options.
- Applying formulas in categories such as logical, text, date, and time.
- Resizing, insertion, and deletion of rows and columns.
- Multiple sheets.
- Frozen panes.
- Text wrapping.
Each of these features is exposed as a user interface (UI) to the end user and as API calls for further UI customization to the developer.
The Spreadsheet supports Internet Explorer 9 or later versions.
To instantiate the Spreadsheet, use an empty
<div> element, as demonstrated in the following example.
<div id="spreadsheet"> </div> <script> $("#spreadsheet").kendoSpreadsheet(); </script>
For more details on the instantiation mechanism of Kendo UI widgets, refer to the article on widget initialization.
To find the detailed list of configuration options supported by the Spreadsheet, including sheet and data configuration, refer to the API reference of the Spreadsheet.
sheet object instance interface enables you to get and set settings and data on the sheet level.
The following example demonstrates how to set the value for a range of cells.
The Spreadsheet offers methods for storing and loading data in a JSON format.
For more information on the data import and export functionality in the Spreadsheet, refer to the article on storing content as JSON.
The Spreadsheet features a built-in export-to-Excel functionality which is fully actionable in the browser.
You can bind individual sheets to a Data Source in a special data-driven mode.
For more information on the data-binding Spreadsheet functionality, refer to the article on binding the Spreadsheet to a data source.
The Spreadsheet is primarily targeted at desktop users. Its performance and functionalities are limited on mobile devices.
Other articles on the Kendo UI Spreadsheet:
- Custom Functions
- Custom Cell Editors
- Cell Formatting
- Load and Save Data as JSON
- Data Source Binding
- Export to Excel
- Server-Side Processing
- User Guide
- How to Bind Charts to Sheet Data
- How to Get Flagged Cells Containing Invalid Values
- How to Set Validation Rules to Column Ranges