@syncfusion/ej2-spreadsheet

ej2-spreadsheet

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.

Setup

To install Spreadsheet and its dependent packages, use the following command.

npm install @syncfusion/ej2-spreadsheet

Resources

• Getting Started
• View Online Demos
• Product Page

Supported Frameworks

Spreadsheet component is also offered in the following list of frameworks.

1. Angular
2. React
3. VueJS
4. ASP.NET Core
5. ASP.NET MVC
6. JavaScript (ES5)

Key Features

• 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.
• 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.

Support

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.

License

Check the license details here.

Changelog

Check the changelog here

© Copyright 2019 Syncfusion, Inc. All Rights Reserved. The Syncfusion Essential Studio license and copyright applies to this distribution.