SpreadJS, Angular Excel Component

The world's No. 1 Excel Component for Angular Developers

Quickly and easily develop Excel screens and features in your Angular applications using SpreadJS, an Angular-based Excel spreadsheet component.

Why SpreadJS

Why Choose SpreadJS for Angular Apps?

Fully Implemented Excel UI & Editor

You can quickly and easily implement an Excel editor that's fully compatible with Microsoft Excel in your React-based applications with just a few lines of JavaScript code.

Angular Support

SpreadJS supports Angular v18. Develop Excel UI and features more efficiently in your Angular-based applications.

Supports 500+ Excel Functions

It provides over 500 built-in functions that are fully compatible with Microsoft Excel functions, and you can extend them by customizing formulas with built-in functions and operators.

Import and Export Excel Data

You can easily and quickly import Excel files directly into SpreadJS, or export SpreadJS sheets to various formats such as XLSX (Excel), CSV, and PDF.

Data Visualization Using Charts, Sparklines, and Pivot Tables

Provide your users with enhanced data visualization solutions with a variety of Excel-compatible charts, sparklines, pivot tables, and custom visualizations.

SpreadJS Template Designer without Coding

Save time and energy on application development by easily designing Excel templates with the SpreadJS template designer without coding.


Quick Start

Getting Started with SpreadJS in Angular 🚀

1. Go to the Angular app folder and install the SpreadJS library.

npm install @mescius/spread-sheets

npm install @mescius/spread-sheets-angular

2. Add a css file to apply SpreadJS styles.

Access the angular.json file of the Angular app you will be working on and add the SpreadJS css file.

Add the CSS file with the desired style from among the various CSS files. (Check the entire theme)

// angular.json

"options": {

    ...

    "styles": [

        "node_modules/@mescius/spread-sheets/styles/gc.spread.sheets.excel2016colorful.css"

    ],

    ...

}

3. Set the Korean cultural sphere.

1) Install the Korean resource package.

npm install @mescius/spread-sheets-resources-ko

2) Add code to import the Korean resource package at the top of the app.component.ts file.

// app.component.ts

import    '@mescius/spread-sheets-resources-ko'      ;

3) Add the code below.

// app.component.ts

GC.Spread.Common.CultureManager.culture("ko-kr");

4. Initialize the SpreadJS control and add it to the screen.

Initialize the SpreadJS control and write code to display it on the screen.

Modify the code in the app.component.html and app.component.ts files.

Please check the sample below for the full code.

5. Run the Angular app and check the results.

npm start


For Angular Developers

Recommended Tutorials for SpreadJS Beginners

View More

Angular Web Excel Editor

EASY

Designer Components

The SpreadJS designer component allows you to quickly and easily implement a UI, menu structure, and Excel functionality similar to Google Sheets and online MS Excel. Check out the live demo and explore its various features.

Read More FAQ How to apply

The screen below is implemented as an actual designer component.

Angular Starter Template

Jump-Start Your Development with Customizable Angular Samples & Templates.

Explore a variety of templates and samples built with SpreadJS. View live demos and download the source code to customize for your own use.

  • Business Dashboard

    A sample business dashboard built with built-in charts, sparklines, and custom formatting. Download the zip file in Angular.

    View Demo
  • Financial KPI Dashboard

    This is a sample financial KPI dashboard that allows you to check targets and achievement rates. Download the zip file in Angular.

    View Demo
  • Report Card Dashboard

    This is a sample report card dashboard that displays the number of students and their grades using bullets, lines, and column sparklines. Download the zip file for Angular.

    View Demo
  • Financial applications

    A sample financial application built using the chart and range templates. Download the zip file for Angular.

    View Demo
  • Medical Dashboard

    This healthcare dashboard uses various charts to monitor patient visits, average wait times, and patient satisfaction. Download the zip file in Angular.

    View Demo
  • Retail indicators

    This is a sample dashboard demonstrating the power of the rangeTemplate feature, which allows you to define multi-row templates and apply custom templates to cells. Download the zip file for Angular.

    View Demo
  • Project Dashboard

    This is a sample project dashboard that allows you to check the progress of a project using the built-in charts in the Gantt sheet. Download the zip file for Angular.

    View Demo
Want More Templates & Samples?

Visit our SpreadJS online tutorial showcase!

SpreadJS Key Features for Angular

  • Powerful Pivot Tables

    SpreadJS fully supports pivot tables and can import and export Excel pivot tables. Use pivot tables to group, calculate, summarize, and display large amounts of data, increasing your productivity.

  • Gantt Sheet

    Provides a GanttSheet, a data table view with quick data binding.

  • Report Sheet

    Easily design reports with support for data entry, pagination, data filtering, sorting, and conditional formatting.

  • 500+ Functions Supported

    SpreadJS includes powerful Excel-compatible formulas, data aggregation, over 500 functions, cross-table references, and custom names.

  • Excel Import/Export

    A JavaScript spreadsheet with full support for Excel import/export functionality.

  • Data Visualization With Charts and Sparklines

    Charts and sparklines make data clear and easy to understand. Most Excel charts, interactions, and animations enhance your dashboards and spreadsheets.

  • Multicultural Support

    You can localize your application by selecting from or customizing the CalcEngine Language pack. You can adjust not only the language but also currency, number separators, and more.

  • SpreadJS Template Designer

    Save time and energy on application development by easily designing templates with the WYSIWYG SpreadJS designer without coding.

    How to Use
  • TableSheet

    TableSheet is a separate, high-performance, enterprise-grade DataTable that adds the power of the SpreadJS spreadsheet calculation engine, runtime panels, and custom views to quickly handle your most demanding data binding requirements.

  • Data Manager

    SpreadJS Data Manager is a new data engine API built for performance that lets you connect to and interact with bound data in TableSheets through data relationships and views faster and easier than ever before.