We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. Image for the cookie policy date
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

Trusted by the world’s leading companies

syncfusion trusted companies

Overview

The Angular Spreadsheet, also known as the Angular Excel viewer, is a feature-rich component for organizing and analyzing data in a tabular format. It provides all the common Excel features, including data binding, selection, editing, formatting, resizing, sorting, and importing and exporting Excel documents.


Data binding

Bind data seamlessly with various local and remote data sources such as JSON, RESTful services, OData services, and WCF services. The control uses a data manager to handle data and supports customizing data requests and processing.

Angular Spreadsheet data binding.


High performance

The Angular Spreadsheet (Excel like grid) component is designed and optimized for loading large amounts of data, scrolling, and more.

Instant data loading in Angular Spreadsheet.

Instant loading

Angular Excel Viewer instant loading allows users to load large amounts of data into a worksheet and view it on demand with the help of row and column virtualization.

Smooth scrolling in Angular Spreadsheet.

Smooth scrolling

The Angular Spreadsheet component provides a smooth scrolling experience even with many cells in a view.


Angular Spreadsheet editing.

Editing

Data editing allows you to add, edit, and remove formulas or values in a cell. Edit the contents of a cell directly in the cell or by typing the formula bar.


Excel-like selection

The Angular Spreadsheet widget provides interactive support to highlight the cells, rows, columns, and sheets selected. Selection can be done through mouse, touch, or keyboard interaction.

Angular Spreadsheet selection.


Formulas

The Angular Spreadsheet library provides a wide range of formulas with cross-sheet references support.

Angular Spreadsheet built-in formulas.

Built-in functions

The Angular Spreadsheet with rich UI provides a built-in calculation engine is suitable for most of the calculations. It also provides an option to create and use custom formulas.

Angular Spreadsheet dependent cell reference.

Auto calculation

Values are automatically recalculated when a dependent cell is edited.


Number formatting in Angular Spreadsheet.

Number formatting

Number formatting is used to change the appearance of numbers in Angular Spreadsheet. It helps display data as currency, percentages, short dates, long dates, time, fractions, and scientific numbers, similar to Excel.


Cell formatting

Using cell formatting, users can highlight a particular cell or range of cells from a whole workbook. The component supports various formatting options: font size, font family, font color, fill color, indent, and horizontal and vertical alignments of text.

Sheet tabs in Angular Spreadsheet.


Open and save

Excel and CSV import

Load Excel documents initially or open them like an Excel application with data accuracy, styles, and formats. Microsoft Excel (.xlsx), Microsoft Excel 97-2003 (.xls), and comma-delimited values (.csv) file formats can be opened in a Angular Spreadsheet.

Excel and CSV export

Easily save the Angular Spreadsheet component with data accuracy, styles, and formats as an Excel file. The Angular Material Spreadsheet supports file formats such as Microsoft Excel (.xlsx), Microsoft Excel 97-2003 (.xls), and comma-delimited values (.csv).


Sort and filter

  • Reorganize data faster by sorting the range of cells in either the ascending or descending order. The custom sort option allows you to sort multiple columns.
  • When filtering, if values in one or more columns do not meet the filtering criteria, all the data will be hidden. You can filter text, dates, and numbers.

Angular Spreadsheet sorting and filtering.


There is built-in support for hyperlinks and bookmarks. Navigate to web links or cell references within the sheet or other sheets in the workbook.

Hyperlink in Angular Spreadsheet Viewer.


Image

The image feature allows users to view, insert, and modify a picture in a Angular Spreadsheet with customizing options.

Image in Angular Spreadsheet.


Chart

The chart feature transforms the Angular Spreadsheet data into an intuitive overview for better understanding and to make smart business decisions.

Chart in Angular Spreadsheet.


Ribbon UI

The Angular Spreadsheet provides an interactive ribbon that organizes the spreadsheet’s features into a series of tabs. Collapse the ribbon to make more rows visible in the viewport.

Ribbon in Angular Spreadsheet.


Collaborative editing

Easily collaborate on workbooks. Multiple users can work on a spreadsheet at the same time and view the changes made by others instantly.

Collaborative editing in Angular Spreadsheet.


Interactive features

Clipboard operations in Angular Spreadsheet.

Copy to clipboard

Use the clipboard operations, cut, copy, and paste, just like Microsoft Excel. You can paste the values or formulas with or without formatting in a newly selected range.

Context menu in Angular Spreadsheet.

Context menu

The context menu improves user interaction with the Angular Spreadsheet using a pop-up menu. It appears when a cell, row header, column header, or sheet tab is right clicked. In addition to built-in default menu items, you can add custom context menu items.

Row and column resizing in Angular Spreadsheet.

Resize and autofit

The resize and autofit options help you adjust the row height and column width.

Undo and redo in Angular Spreadsheet.

Undo and redo

The Angular Spreadsheet provides an option to undo and redo changes made in a workbook. You can customize the limit of undo and redo operations.


Accessibility

Keyboard navigation in Angular Spreadsheet.

Keyboard navigation

The Angular Excel Spreadsheet ensures that every cell is accessible using a keyboard. Major features like selection, clipboard, and editing can be performed using keyboard commands alone; no mouse interaction is required. This helps in creating highly accessible applications using this component.

Accessibility and screen reader support in Angular Spreadsheet.

Screen reader

The Angular Excel Grid view has complete WAI-ARIA accessibility support. The Angular Spreadsheet with rich UI includes high-contrast visual elements, helping visually impaired people have the best viewing experience. Also, valid UI descriptions are easily accessible through assistive technologies such as screen readers.


Built-in and customizable themes

Five built-in, SASS-based themes are available: Material, Bootstrap, Bootstrap 4, Fabric, and high contrast. Simplify theme customization either by overriding the existing SASS styling or creating custom themes using the Theme Studio application.

Angular Spreadsheet themes.


Globalization and localization

Format dates and numbers in Angular Spreadsheet.

Globalization

The Angular Spreadsheet enables users from different locales to use it by formatting the dates, currency, and numbering to suit their language preferences. It uses the internalization (i18n) library to handle number formatting.

Show right-to-left language in Angular Spreadsheet.

Right to left (RTL)

Right-to-left rendering allows you to display the text and layout of the Spreadsheet from right to left. This improves the user experience and accessibility for RTL languages.

Localize Angular Spreadsheet UI strings.

Localization

Localize all the strings used in the user interface of the Angular Spreadsheet component. The component uses the localization (l10n) library to localize UI strings.


Supported browsers

The Angular Spreadsheet works well with all modern web browsers: Chrome, Firefox, Microsoft Edge, Safari, and IE11. It supports IE11 with the help of polyfills.

Supported web browsers for Angular Spreadsheet.


Angular Spreadsheet Code Example

Easily get started with the Angular Spreadsheet using a few simple lines of HTML and TS code example as demonstrated below. Also explore our Angular Spreadsheet Example that shows you how to render and configure a Spreadsheet in Angular.

<div class="control-section">
    
<ejs-spreadsheet #default>
  <e-sheets>
    <e-sheet name = "Price Details" >
      <e-ranges>
        <e-range[dataSource] = "priceData" ></e-range>
      </e-ranges>
      <e-columns>
        <e-column[width] = 130 ></e-column>
        <e-column[width] = 92 ></e-column>
        <e-column[width] = 96 ></e-column>
      </e-columns>
     </e-sheet>
    </e-sheets>
  </ejs-spreadsheet >                    
</div>
import { Component, Inject, ViewChild } from '@angular/core';
import { SpreadsheetComponent } from '@syncfusion/ej2-angular-spreadsheet';
/**
 * Default Spreadsheet Controller
 */
@Component({
    selector: 'control-content',
    templateUrl: 'default.html'
})

export class DefaultController {
    @ViewChild('default')
    public spreadsheetObj: SpreadsheetComponent;
priceData: object[] = dataSource1;
    }

Other supported frameworks

Spreadsheet is also available in React, Vue, and JavaScript frameworks. Check out the different Spreadsheet platforms from the links below,

Developer-friendly APIs

Developers can customize their UI and control its behaviors according to the end user’s requirement using the control’s rich set of client-side APIs.




65+ ANGULAR UI COMPONENTS

Frequently Asked Questions

  • Seamless data analysis and visualization like in Microsoft Excel.
  • Compatibility with Microsoft Excel file formats.
  • Highly intuitive user interfaces.
  • Flexible data binding with support to use local and remote data source services.
  • Supports Freeze panes, Keyboard shortcuts and all the common Excel features.
  • One of the best Angular Spreadsheet in the market that offers feature-rich UI to interact with the software.
  • Supports all modern browsers.
  • Mobile-touch friendly and responsive.
  • Expansive learning resources such as demos and documentation to learn quickly and get started with Angular Spreadsheet.

We do not sell the Angular Spreadsheet separately. It is only available for purchase as part of the Syncfusion Angular suite, which contains over 70 Angular components, including the Spreadsheet. A single developer license for the Syncfusion Essential Studio for Angular suite costs $995.00 USD, including one year of support and updates. On top of this, we might be able to offer additional discounts based on currently active promotions. Please contact our sales team today to see if you qualify for any additional discounts.

You can find our Angular Spreadsheet demo here.

No, our 70 Angular components, including Spreadsheet, are not sold individually, only as a single package. However, we have competitively priced the product so it only costs a little bit more than what some other vendors charge for their Spreadsheet alone. We have also found that, in our experience, our customers usually start off using one of our products and then expand to several products quickly, so we felt it was best to offer all 70 Angular components for a flat fee of $995/developer. On top of this, we might be able to offer additional discounts based on currently active promotions. Please contact our sales team today to see if you qualify for any additional discounts.

No, this is a commercial product and requires a paid license. However, 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.

A good place to start would be our comprehensive getting started documentation.

Read independent,
authenticated reviews
on G2

Download Now Pricing

What do our customers say about us?

double quotes

Using Syncfusion Angular and JavaScript controls makes front-end web development a piece of cake. Each component has many properties that can be configured as per your desire, methods that can be used to interact with the element, and a lot of events that trigger at different stages, which makes modifying your components according to the state of the application an easy task. Also, their support is amazing! They always offer a sample working project, which makes it very simple to solve your question about your code.
Carlos Rodriguez Garcia

Carlos Rodriguez Garcia

Vistatec

double quotes

We started using Syncfusion Angular controls for the Scheduler to offer our providers a way to schedule their availability and automate our administrative process to show availability and gaps in schedules. This helped us provide the best user experience and deliver care to our patients in a timely manner.
Tim Rankel

Tim Rankel

Senior Developer at MeMD

Transform your applications today by downloading our free evaluation version Download Free Trial

Awards

Greatness—it’s one thing to say you have it, but it means more when others recognize it. Syncfusion is proud to hold the following industry awards.

Up arrow icon

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon

Live Chat Icon For mobile