Kendo UI for Angular
The Kendo UI for Angular Spreadsheet enables you to easily edit and visualize tabular data by using cell formatting options, styles, and themes. With a wide range of functionalities, the component empowers users to effectively manage and manipulate data in a spreadsheet-like interface.
The component has a variety of built-in tools to help users create, edit, and style the data. The main menu has three different tabs, including File, Home, and Insert, each offering a convenient way to manage the data. The Home menu enables users to format and style the text in different ways to make it more readable and visually appealing. The insert menu, on the other hand, provides an easy way to insert or delete rows and columns within the spreadsheet.
The Kendo UI for Angular Spreadsheet provides the possibility to store and load data in a native JSON format, as well as import and export .xlsx files directly within the component.
Save time and increase your productivity with the Spreadsheet’s action bar, providing various tools for managing the cell selection and calculating cell values by entering formulas into the dedicated formula input.
The Sheets Bar offers a convenient way to manage the sheets and perform various actions, such as adding a new sheet, modifying an existing one (rename, delete, duplicate, or reorder), and changing an active sheet.
The component enables you to customize the default appearance of the cells and the look and feel of the respective content. The built-in properties allow you to configure all cells at once or just highlight the most important information. You can customize the header width and height, row height, column width, and the default cells style.
The Spreadsheet component enables you to emits certain events that enable you to control its behavior upon user interaction:
activeSheetChange – triggered when the active sheet is about to change
change – triggered when a value in the spreadsheet is changed
excelExport – triggered when the user clicks the Export to Excel toolbar button
excelImport – triggered when the user clicks the Open toolbar button
formatChange – triggered when the selected range format is changed
selectionChange – triggered when a user changes a selection
Enhance accessibility and productivity with keyboard-only navigation. The Angular Spreadsheet component includes keyboard navigation support, enabling users to navigate and interact with its items efficiently using only the keyboard.