Bring Excel or Google Sheet-like experiences to your web applications without the hassle of a single line of code. Organize data with these built-in functionalities: formulas, filtering, sorting, scrolling and frozen panes. Load/save data from JSON via API methods or enable export to Excel on the client.
Organize and search data easily using the built-in sorting feature of Kendo UI for jQuery Spreadsheet. Sort values in the Spreadsheet globally or sort a selected range of column values and get a better understanding of data spanning across multiple rows and columns.
The jQuery Spreadsheet is capable of handling large datasets by leveraging the server to process data for importing into the component and also to export data in friendly formats, mainly PDF and Excel.
In cases where you need to lock specific data from editing, you can lock selected cells and make others editable.
Just like all popular spreadsheet software, the jQuery Spreadsheet allows the user to format cells for their specific data type, colors, borders, and much more. That’s not all. We take it a step further by supporting custom cell editors. You can use these to help the user enter the correct date. Use the Color Picker if the user needs to select a color or the DatePicker if a user needs to enter a date.
Enjoy a wide range of formulas, from standard numeric such as sum, count, min, max, average to advanced math, statistical, date or text formulas for custom calculations. They come supported out-of-the-box, so you only need to use the function row from the UI to define the formula.
Enjoy virtually no limitations on the number of cells in a sheet, providing unmatched performance--even with thousands of cells.
All standard image formats can be imported and added to cells as content. This makes visualizing complex tables more intuitive as users can place images to provide clues about what each cell does, or just to improve the table’s visualization.
Users can add comments to any cell – whether it’s a note to themselves or a collaborator, or perhaps an explanation of what a formula does.
The jQuery Spreadsheet has validation tools built-in, giving you a way to ensure data in common formats fit your rules (ex: emails, dates). You can also include you own custom rules.
he jQuery Spreadsheet supports any globalization or localization scenarios. You can also enable RTL mode to display the control’s text and UI elements from left to right.
Improve accessibility and productivity with keyboard-only navigation. This component supports keyboard navigation to help navigate and interact with items.