<
DHTMLX Spreadsheet 5.1 with New Themes, Simplified Localization of Number Formats, Live Integration Demos with Frameworks, and More
Angular

DHTMLX Angular Spreadsheet

Highly customizable Angular spreadsheet component with elegant Material style for editing and formatting data safely and conveniently.

Try DHTMLX Angular Spreadsheet Live Demo

Open a demo on desktop
Spreadsheet by DHTMLX helps in creating Excel-like data tables with minimum time and effort.
Capterra Shortlist 2024
GetApp Category Leaders 2024
Software Advice Front Runners 2024
Best Meets Requirements
High Performer EMEA
Users Most Likely To Recommend
Easiest to Use

How to Create Angular Spreadsheet

5 steps to build an Angular Spreadsheet example:
1.
Create a spreadsheet.component.ts file and import files and styles of Spreadsheet.
2.
Add an empty container for Spreadsheet with the ref attribute.
4.
When the component is initialized, initialize Spreadsheet and attach the instance of Spreadsheet to the container with the ref attribute.
5.
Specify a data set and load Spreadsheet with data using the parse() method.

Spreadsheet Angular Key Features

Built-in features
Add-on
Simple customization
Using 170+ predefined functions
Within the DHTMLX Spreadsheet widget, there are numerous built-in mathematical formulas and functions designed for strings, financial operations, and information processing. Moreover, these functions are compatible with both Excel and Google Sheets.
Using 170+ predefined functions
Working with multiple sheets
End-users have the option to work with multiple sheets. This includes adding new sheets, renaming them, removing unnecessary ones, and changing the currently active sheet. Using cross-referencing, they can easily consolidate data from multiple sheets into a single one.
Working with multiple sheets
Number formatting
DHTMLX Spreadsheet Angular allows you to set various numeric values to cells, such as text, digits, percents, and currency symbols. Furthermore, customization options include adjusting default number formats or setting personalized formats.
Number formatting
Using 170+ predefined functions
Excel export module
We provide you with a separate module for exporting spreadsheets to Excel (.xlsx) files. This module can be installed directly on your server or as a Docker image. You’ll also receive all updates and fixes to the export service and consultations related to the Spreadsheet component.
Excel export module
PDF/PNG export module
Adding custom icons and toolbar buttons
DHTMLX Spreadsheet comes with Material Design icons, but you can easily integrate any other icon font pack and customize the toolbar controls according to your preferences. A great example is adding a custom button to swiftly clear all content with a single mouse click.
Enriching context menu controls
You can customize not only the toolbar but also other parts of the spreadsheet, such as the menu and context menu. For instance, you have the option to add a Paint format control in the context menu, enabling end-users to save cell styles and easily apply them to other cells.
Setting custom read-only mode
Apart from enabling the read-only mode for the entire Spreadsheet, you can also block specific operations for cells. Thus, for example, it's possible to limit the possibility of editing and styling the content of individual cells.

Why Choose DHTMLX Spreadsheet?

Specially crafted for Angular
Building Angular apps using DHTMLX Spreadsheet requires just a couple of simple steps, as our spreadsheet component written natively in JavaScript has a smooth integration with Angular. Check the documentation to find out all the details. Besides, DHTMLX Spreadsheet supports React, Svelte, and Vue.js frameworks to cater to the tasks of most developers.
Edit and format data securely
The main advantage of DHTMLX Spreadsheet is secure data processing performed on your own server. Involving Ajax techniques, our Angular spreadsheet can display data on a web page without any threat to your data sources. If there's a need to restrict access to the data for end users, you can run your spreadsheet in read-only mode.
Complete customization
The structure of DHTMLX Spreadsheet is highly configurable. All of its parts including the toolbar, grid, menu, and context menu have flexible configuration settings for adjusting the Angular spreadsheet library to your project. You can switch on or off the menu, add custom menu items and toolbar controls, and choose another icon font.
Data manipulation
Our developers have created an elaborate API, which enables conducting lots of operations in the grid. Working with tabular data in DHTMLX Spreadsheet is much like working in Excel for end-users. Here you have undo and redo commands, options for selecting cells by block, locking and unlocking them, pasting new rows and columns or deleting them from the grid, resizing columns, etc.
Applying styles
DHTMLX Spreadsheet offers a broad range of formatting options for advanced data presentation. These options include setting the background color of cells with the help of the color picker, text decoration, alignment, etc. On top of that, it's possible to clear styles of cells and their values.
Get started for free
Download the DHTMLX Spreadsheet trial version and test it completely free of charge for 30 days taking advantage of our email technical support.

DHTMLX Spreadsheet Licensing

Individual
Total: $599
Commercial
Total: $1299
Enterprise
Total: $2899
Ultimate
Total: $5799
License Terms Read License Agreement Read License Agreement Read License Agreement Read License Agreement
Developers 1 5 20
Projects 1 1 5
Use in SaaS (unlimited end-users)
Source code
Perpetual distribution rights
Support Plan
Standard Premium Premium Ultimate
Time Period 1 year 1 year 1 year 1 year
Updates Major, minor, and maintenance updates Major, minor, and maintenance updates Major, minor, and maintenance updates
Major, minor, and maintenance updates
Priority queue for bug fixing
Support requests 10 30 50
Response time 72h 48h 48h 24h
Personal Account Manager
Functionality
PRO PRO PRO + 1 add-on PRO + 1 add-on
Online export to Excel Free Free Free Free
Free local Excel export module
Individual
$599
License Terms Read License Agreement
Developers 1
Projects 1
Use in SaaS (unlimited end-users)
Source code
Perpetual distribution rights
Support Plan
Standard
Time Period 1 year
Updates Major, minor, and maintenance updates
Support requests 10
Response time 72h
Personal Account Manager
Functionality
PRO
Online export to Excel Free
Free local Excel export module
Commercial
$1299
License Terms Read License Agreement
Developers 5
Projects 1
Use in SaaS (unlimited end-users)
Source code
Perpetual distribution rights
Support Plan
Premium
Time Period 1 year
Updates Major, minor, and maintenance updates
Support requests 30
Response time 48h
Personal Account Manager
Functionality
PRO
Online export to Excel Free
Free local Excel export module
Enterprise
$2899
License Terms Read License Agreement
Developers 20
Projects 5
Use in SaaS (unlimited end-users)
Source code
Perpetual distribution rights
Support Plan
Premium
Time Period 1 year
Updates Major, minor, and maintenance updates
Support requests 50
Response time 48h
Personal Account Manager
Functionality
PRO + 1 add-on
Online export to Excel Free
Free local Excel export module
Ultimate
$5799
License Terms Read License Agreement
Developers
Projects
Use in SaaS (unlimited end-users)
Source code
Perpetual distribution rights
Support Plan
Ultimate
Time Period 1 year
Updates
Major, minor, and maintenance updates
Priority queue for bug fixing
Support requests
Response time 24h
Personal Account Manager
Functionality
PRO + 1 add-on
Online export to Excel Free
Free local Excel export module
Documentation
Refer to documentation
Explore the Spreadsheet documentation with API references and step-by-step guides and tutorials. It includes instructions for smoothly integrating the pure JavaScript library into different frameworks, including Angular, React, Svelte, and Vue.js.
Samples
Explore code snippets
Try to work with spreadsheets online, play around with the code, and share your code snippets with your team or DHTMLX support to demonstrate your ideas or issues.
Free trial
Download Spreadsheet trial
Take the opportunity to explore the features of DHTMLX Spreadsheet with the free 30-day trial version. It includes the latest updates and official technical support.
Official tech support
Learn about technical support
Read about the ways to get technical or licensing support. Our team helps proprietary license owners as well as trial users.
Community forum
Use DHTMLX forum
Benefit from the experiences of other DHTMLX users and tap into the knowledge shared by fellow developers. We actively monitor discussions and address frequently asked questions.
Blog
Keep up with updates
Visit the DHTMLX blog where we’re writing about Spreadsheet releases, valuable tips, technical guides, and updates on other DHTMLX offerings and developments.
Manage large data sets conveniently with DHTMLX Spreadsheet
Download the Spreadsheet trial version and evaluate it free of
charge for 30 days getting assistance from the official support team.
NO credit card required