ej2-angular-ui-components/components/spreadsheet

Angular Spreadsheet Component

The Angular 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/CSV file or from local and remote data sources such as JSON, RESTful services, OData services, and more. The populated data can be exported as Excel with xlsx, xls, CSV and PDF formats.

Getting started . Online demos . Learn more

Trusted by the world's leading companies

Setup

Create an Angular Application

You can use Angular CLI to setup your Angular applications. To install the Angular CLI, use the following command.

npm install -g @angular/cli

Create a new Angular application using the following Angular CLI command.

ng new my-app
cd my-app

Add Syncfusion Spreadsheet package

All Syncfusion Angular packages are available in npmjs.com. To install the Angular Spreadsheet package, use the following command.

ng add @syncfusion/ej2-angular-spreadsheet

The above command does the below configuration to your Angular app.

• Adds @syncfusion/ej2-angular-spreadsheet package and its peer dependencies to your package.json file.
• Imports the SpreadsheetModule in your application module app.module.ts.
• Registers the Syncfusion UI default theme (material) in the angular.json file.

This makes it easy to add the Syncfusion Angular Spreadsheet module to your project and start using it in your application.

Add Spreadsheet component

In src/app/app.component.ts, use <ejs-spreadsheet> selector in the template attribute of the @Component directive to render the Syncfusion Angular Spreadsheet component.

import { Component, OnInit } from '@angular/core';

@Component({
    selector: 'app-root',
    template: `<ejs-spreadsheet>
                    <e-sheets>
                        <e-sheet>
                            <e-ranges>
                                <e-range [dataSource]='data'></e-range>
                            </e-ranges>
                        </e-sheet>
                    </e-sheets>
                </ejs-spreadsheet>`
})
export class AppComponent implements OnInit {

    public data: object[] = [];

    ngOnInit(): void {
        this.data = [
            { OrderID: 10248, CustomerID: 'VINET', EmployeeID: 5, ShipCity: 'Reims' },
            { OrderID: 10249, CustomerID: 'TOMSP', EmployeeID: 6, ShipCity: 'Münster' },
            { OrderID: 10250, CustomerID: 'HANAR', EmployeeID: 4, ShipCity: 'Lyon' }
        ];
    }
}

Supported frameworks

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

JavaScript	React	Vue	ASP.NET Core	ASP.NET MVC

Showcase samples

• Expense Tracker - Source, Live Demo
• Loan Calculator - Source, Live Demo
• Fitness Tracker - Source, Live Demo

Key features

• Data sources: Bind the Spreadsheet component with an array of objects or data from a web service using 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 option to dynamically edit a cell.
• Formulas: Provides built-in calculation library with pre-defined formulas and named range support.
• Clipboard: Provides the option to perform clipboard operations.
• Cell formatting: Provides the option to customize the appearance of cells.
• Number formatting: Provides the option to format the cell value.
• Open: Provides the option to open Excel and CSV files in Spreadsheet.
• Save: Provides the option to save Spreadsheet data as Excel, CSV, and PDF documents.
• 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 to web link or cell reference within the sheet or to other sheet in Spreadsheet.
• Resize: Allows you to change the row height and column width. Auto fit the rows and columns based on its content.
• Wrap text: Provides the option to display the large content as multiple lines in a single cell.
• Data validation: Provides the option to validate edited values based on data validation rules defined for a cell or range of cells.
• Find and replace: Provides the option to find the data and replace it across all sheets in Spreadsheet.
• Protect sheet: Provides the option to restrict user actions like cell editing, row and column insertion, deletion, and resizing.
• Borders: Provides the option to customize cell gridlines such as color and its style for enhanced UI.
• Show/hide: Provides the option to show/hide rows, columns and sheets.
• Insert/delete: Provides the option to insert/delete rows, columns and sheets.
• Merge cells: Provides the option to combine two or more cells located in the same row or column into a single cell.
• Conditional formatting: Provides the option to format a cell or range of cells based on conditions applied.
• Autofill: Provides the option to fill or copy a series or pattern of values and formats into adjacent cells in any direction.
• Clear: Provides the option to clear the content, formats, and hyperlinks applied to a cell or range of cells in a Spreadsheet.
• Aggregates: Provides the option to check the sum, average, count, and more for the selected cells or range in the sheet.
• Picture: Allows you to view, insert, and modify a picture in a Spreadsheet with customizing options.
• Chart: Transforms your Spreadsheet data to an intuitive overview for better understanding and to make smart business decisions.
• Freeze panes: Allows you to keep the specified rows and columns always visible at the top and left side of the sheet while scrolling through the sheet.
• Password protection: Allows you to protect the workbook with a password.
• Multi-line editing: Allows you to insert a line break between paragraphs of the text within a cell in a Spreadsheet.
• Calculate range selection: Helps you to select a range or multiple ranges when editing a formula in a cell.
• Right-to-left (RTL): Aligns content in the Spreadsheet component from right to left.
• Templates: Templates can be used to create custom user experiences in the Spreadsheet.
• Globalization: Personalize the Spreadsheet component with different languages, as well as culture-specific number, date, and time formatting.
• 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 the following mediums.

• Support ticket - Guaranteed Response in 24 hours | Unlimited tickets | Holiday support
• Community forum
• GitHub issues
• Request feature or report bug
• Live chat

Changelog

Check the changelog here. Get minor improvements and bug fixes every week to stay up to date with frequent updates.

License and copyright

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. To acquire a license for 80+ Angular UI components, you can purchase or start a free 30-day trial.

A free community license is also available for companies and individuals whose organizations have less than $1 million USD in annual gross revenue and five or fewer developers.

See LICENSE FILE for more info.

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