You can bind local as well as remote data sources such as JSON, RESTful services, OData services, and WCF services seamlessly.
Provides a built-in calculation engine for most calculations. Create and use custom formulas in the React Spreadsheet. When a cell is edited, its values are recalculated automatically if that cell has a formula.
Import and Export
Spreadsheet supports opening Microsoft Excel (.xlsx), Microsoft Excel 97-2003 (.xls), and comma-separated values (.csv) file formats. You can load, open, or save spreadsheet components with data accuracy, styles, and formats like in Excel.
Charts and Images
With customizable options, the image feature enables users to view, insert, and edit an image in a spreadsheet. The spreadsheet data is transformed into an understandable summary using the chart function for improved comprehension.
Sort and Filter
Sort multiple columns at the same time with custom sorting. When filtering, all the data is hidden that doesn't meet the filtering criteria of one or more columns.
Utilize an interactive ribbon that organizes the functionality of the Spreadsheet into a number of tabs. More rows will appear in the viewport if the ribbon is expanded.
Choose from built-in, SASS-based Material, Bootstrap, Fabric (Office 365), Tailwind CSS, and high contrast themes. Using the Theme Studio application, you can override existing styles or create custom themes.
Workbooks can be shared with ease. Spreadsheet allows for concurrent user editing, and each user can see the changes made by the other users right away.
Large amounts of data can be loaded with Spreadsheet’s optimized design. You get instant loading with the help of row and column virtualization and smooth scrolling even with a lot of cells in the view.