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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
Visit the DHTMLX blog where weβre writing about Spreadsheet releases, valuable tips,
technical guides, and updates on other DHTMLX offerings and developments.