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

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

Spreadsheet
πŸ’Ž Save on bundles
Individual Commercial Enterprise Ultimate
License Terms
Individual
Commercial
Enterprise
Ultimate
Developers
Individual
1
Commercial
5
Enterprise
20
Ultimate
Projects
Individual
1
Commercial
1
Enterprise
5
Ultimate
Use in SaaS (unlimited end-users)
Individual
Commercial
Enterprise
Ultimate
Perpetual distribution rights
Individual
Commercial
Enterprise
Ultimate
Support Plan
Individual
Standard Support
Commercial
Premium Support
Enterprise
Premium Support
Ultimate
Ultimate Support
Time Period
Individual
1 year
Commercial
1 year
Enterprise
1 year
Ultimate
1 year
Updates
Individual
Major, minor, and maintenance updates
Commercial
Major, minor, and maintenance updates
Enterprise
Major, minor, and maintenance updates
Ultimate
Major, minor, and maintenance updates
Priority queue for bug fixing
Support requests
Individual
10
Commercial
30
Enterprise
50
Ultimate
Response Time
Individual
72h
Commercial
48h
Enterprise
48h
Ultimate
24h
Personal Account Manager
Individual
Commercial
Enterprise
Ultimate
Functionality
Individual
Professional
Commercial
Professional
Enterprise
Professional
Ultimate
Professional
Online export to Excel
Individual
Free
Commercial
Free
Enterprise
Free
Ultimate
Free
Free local Excel export module
Individual
Commercial
Enterprise
Ultimate
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