The Spreadsheet is an user interactive component to organize and analyze data in tabular format with configuration options for customization. It will load data by importing an Excel file or from a data source, such as RESTful JSON data services and local JavaScript object array binding. The populated data can be exported as Excel with xlsx, xls, and csv formats.
This is a commercial product and requires a paid license for possession or use. Syncfusion’s licensed software, including this component, is subject to the terms and conditions of Syncfusion's EULA (https://www.syncfusion.com/eula/es/). To acquire a license, purchase one at https://www.syncfusion.com/sales/products or start a free 30-day trial here (https://www.syncfusion.com/account/manage-trials/start-trials).
A free community license (https://www.syncfusion.com/products/communitylicense) is also available for companies and individuals whose organizations have less than $1 million USD in annual gross revenue and five or fewer developers.
To install Spreadsheet and its dependent packages, use the following command.
npm install @syncfusion/ej2-spreadsheetSpreadsheet component is also offered in the following list of frameworks.
- Data sources: Bind the spreadsheet component with an array of JavaScript objects or DataManager.
- Virtualization: Provides the option to load large amount of data without performance degradation.
- Selection: Provides the option to select a cell or range of cells.
- Editing: Provides the options to dynamically edit a cell.
- Formulas: Provides built-in calculation library with predefined formulas and named range support.
- Clipboard: Provides the option to perform clipboard operations.
- Cell formatting: Provides option to customize the appearance of cells.
- Number formatting: Provides option to format the cell value.
- Open: Provides the option to open excel file in spreadsheet.
- Save: Provides option to save spreadsheet data as excel file.
- Sorting: Helps you to arrange the data to particular order in a selected range of cells.
- Filtering: Helps you to view specific rows in the spreadsheet by hiding the other rows.
- Undo Redo: Provides the option to perform undo redo operations in spreadsheet.
- Collaborative Editing: Provides the option for real time changes across multiple users in the Spreadsheet.
- Hyperlink: Provides the option to navigate the web links or cell reference within the sheet or to other sheets in spreadsheet.
- Resize: Allows you to change the row height and column width. Auto fit the rows and columns based on its content.
- RTL: Provides right-to-left mode which aligns content in the spreadsheet component from right to left.
- Localization: Provides inherent support to localize the UI.
- Accessibility: Provides with built-in accessibility support which helps to access all the spreadsheet component features through the keyboard, screen readers, or other assistive technology devices.
Product support is available through following mediums.
- Creating incident in Syncfusion Direct-trac support system or Community forum.
- New GitHub issue.
- Ask your query in Stack Overflow with tag
syncfusion,ej2.
Check the license details here.
Check the changelog here
© Copyright 2019 Syncfusion, Inc. All Rights Reserved. The Syncfusion Essential Studio license and copyright applies to this distribution.