Angular Spreadsheet Overview
The Kendo UI for Angular Spreadsheet allows you to create, edit, and manipulate tabular data with ease. Just like in an MS Excel spreadsheet, you can edit, resize columns and rows, calculate formulas, import and export to Excel and PDF, and much more.
The Spreadsheet is built from the ground up and specifically for Angular so that you get a high-performance control which integrates tightly with your application and with the rest of the Kendo UI for Angular components.
Since version
17.0.0, the Kendo UI for Angular Spreadsheet component supports strict Content Security Policy (CSP) compliance.
Angular Spreadsheet Example
Angular Spreadsheet Key Features
The Kendo UI for Angular Spreadsheet component delivers a range of handy and developer-friendly features whose number and further development are not limited by the list in this section. The Kendo UI for Angular team constantly invests efforts to improve the performance and add more value to the existing Spreadsheet library as well as develop new features to it.
Data Binding
The Spreadsheet allows you to store and load data in a native JSON format. To supply data, set the sheets property to a SheetDescriptor collection that defines the rows, cells, columns, and formatting for each sheet. You can also control the visible area by setting predefined rows and columns. Read more about data binding in the Spreadsheet...
Importing and Exporting Excel Files
The Kendo UI for Angular Spreadsheet component comes with built-in support for Excel files. You can easily import or export files in .xlsx format. Read more about the Excel Import & Export...
Importing and Exporting JSON Data
The Spreadsheet supports JSON as an import and export format, allowing you to load and save sheet data programmatically. Read more about the JSON Import & Export...
PDF Export
The Spreadsheet allows you to export the active worksheet to a PDF file. You can configure the paper size, orientation, margins, and scale through the pdfExportSettings input and trigger the export from the built-in File menu. Read more about the PDF export of the Spreadsheet...
Menu and Toolbar Tools
The Spreadsheet component provides a variety of built-in tools that help you to create, edit, and style the sheet data. Read more about the built-in menu and toolbar tools of the Spreadsheet...
Filtering and Sorting
The Spreadsheet provides filtering and sorting capabilities to help you manage large datasets. These features are accessible from the Data menu in the toolbar. Read more about filtering and sorting in the Spreadsheet...
Data Validation
The Kendo UI for Angular Spreadsheet provides a built-in data validation tool that allows you to restrict the type of data that can be entered into a cell or range of cells. Read more about the data validation tool of the Spreadsheet...
Custom Cell Editors
The Kendo UI for Angular Spreadsheet allows you to create custom cell editors that extend the built-in editing capabilities with specialized input controls for specific data types. Read more about implementing custom cell editors for the Spreadsheet...
Disabled Cells
The Spreadsheet lets you mark individual cells or ranges as disabled to prevent users from modifying protected data. You can disable cells declaratively through the sheet configuration or toggle their state at runtime. Read more about disabling cells in the Spreadsheet...
Cell Comments
The Kendo UI for Angular Spreadsheet allows you to attach text comments to individual cells. Cell comments serve as annotations that provide additional context without modifying the underlying cell value. Read more about cell comments in the Spreadsheet...
Action Bar
The Spreadsheet action bar allows you to control the cell selection and calculate cell values by entering formulas into the dedicated formula input. Read more about the action bar capabilities of the Spreadsheet...
Built-in Formulas
The Spreadsheet supports a comprehensive set of built-in formulas for mathematical, statistical, logical, text, and date operations. Read more about the built-in formulas of the Spreadsheet...
Sheets Bar
The sheets bar provides a convenient way to rename, duplicate, and delete sheets as necessary. Read more about the sheets bar options of the Spreadsheet...
Context Menu
The Spreadsheet context menu provides quick access to common actions such as copy, paste, and cell merging. You can modify the context menu items, add custom actions, or prevent the menu from opening. Read more about the context menu of the Spreadsheet...
Appearance
You can use the options provided by the Spreadsheet component to customize its appearance. Read more about the customizable appearance of the Spreadsheet...
Events
The Spreadsheet exposes several events to let you easily handle any file operations logic. Read more about the events of the Spreadsheet...
Keyboard Navigation
The Spreadsheet supports a number of keyboard shortcuts which allow users to accomplish various commands. Read more about the keyboard navigation of the Spreadsheet...
Globalization
The Spreadsheet provides internationalization, localization, and right-to-left support to adapt the component to different languages and cultures. Read more about the globalization of the Spreadsheet...
Accessibility
The Spreadsheet is accessible for screen readers and supports WAI-ARIA attributes. Read more about the accessibility of the Spreadsheet...
Trial Version of Kendo UI for Angular
The Kendo UI for Angular Spreadsheet is part of the Kendo UI for Angular library. Kendo UI for Angular offers a 30-day trial with a full-featured version of the library—no restrictions! What’s more, you are eligible for full technical support during your trial period in case you have any questions. Sign up for a free 30-day trial of Kendo UI for Angular.
Support Options
For any questions about the use of the Kendo UI for Angular Spreadsheet, or any of our other components, there are several support options available:
- Kendo UI license holders and anyone in an active trial can take advantage of the Kendo UI for Angular outstanding customer support delivered by the actual developers who built the library. To submit a support ticket, use the Kendo UI support system.
- Kendo UI for Angular forums are part of the free support you can get from the community and from the Kendo UI team on all kinds of general issues.
- Kendo UI for Angular feedback portal and Kendo UI for Angular roadmap provide information on the features in discussion and also the planned ones for release.
- Kendo UI for Angular uses GitHub Issues as its bug tracker and you can submit any related reports there. Also, check out the closed list.
- Of course, the Kendo UI for Angular team is active on StackOverflow as well and you can find a wealth of questions and answers there.
- Need something unique that is tailor-made for your project? Progress offers its Progress Services group that can work with you to create any customized solution that you might need.
Support and Learning Resources
- SpreadSheet Homepage
- Getting Started with the Kendo UI for Angular Spreadsheet
- API Reference of the SpreadSheet
- Getting Started with Kendo UI for Angular (Online Guide)
- Getting Started with Kendo UI for Angular (Video Tutorial)
- Video Courses
- SpreadSheet Forum
- Before You Start: All Things Angular (Telerik Blog Post)
- Knowledge Base