Spreadsheet by DHTMLX helps in creating Excel-like data tables with
minimum time and effort.
Enhance Your App with DHTMLX Spreadsheet
Built-in features
Add-on
Simple customization
Using 170+ predefined functions
The Spreadsheet widget includes hundreds of predefined math formulas
and string, financial, and information functions users can apply to
perform various calculations with values and strings. The functions
are compatible with Excel and Google Sheets.
You can allow your users to work with multiple sheets. They may add
a new sheet, rename it, remove an unnecessary one, and change the
currently active sheet. Users can conveniently consolidate data
from multiple sheets into a single one via cross-referencing.
With DHTMLX Spreadsheet, you can apply different cell numeric
values, including text, digits, percent, and currency signs.
Moreover, you may change the settings of default number formats
or create custom ones.
You can purchase a standalone module for exporting spreadsheet
tables to Excel (.xlsx) format. It can be deployed directly to
your server or as a Docker image. Besides, you’ll get all updates
and fixes to the export service together with consultations on the
Spreadsheet widget.
By default, DHTMLX Spreadsheet uses Material Design icons. However,
you can add any other icon font pack as well as apply desired
controls to the toolbar. For example, you can add a custom button
to the toolbar to remove all content at once.
You have an option to add custom controls not only to the toolbar,
but to other spreadsheet parts, including menu and context menu.
Thus, you can add a Paint format control to the context menu and
allow end-users to save cell style and apply it to other cells
within seconds.
In addition to applying the read-only mode to the entire
Spreadsheet, you have an option to block certain operations.
Thus, for example, you can restrict the possibility to edit
and style the cell content.
JavaScript spreadsheet supports the most essential features for displaying and
formatting tabular data due to the simple API. Offering the basic Excel-like
functionality, it allows you to embed the spreadsheet anywhere on a web page
and work with the tabular data in a familiar way. The spreadsheet supports
undo/redo actions, block selection, locking and unlocking cells, adding and
removing columns and rows, etc.
Custom look and feel
Need to build a complex financial app or use a simple JavaScript spreadsheet for
internal purposes? Due to a wide range of configuration settings, you may fine-tune
the layout, toolbar, menu, and context menu of your spreadsheet. Among the
available options are adding custom toolbar controls, custom icons for controls,
menu and context menu items, etc.
Cell formatting
With the formatting capabilities of DHTMLX Spreadsheet, you can change text color
and decoration, cell background, set text-align, rename column headings, resize
columns' width, etc. Besides, it's possible to clear the styles applied to cells.
End users may choose to clear the style of a cell, its value or both.
Support for Angular, React, and Vue.js
DHTMLX Spreadsheet comes with support for the most widely used client-side
frameworks to meet the needs of the majority of developers. Integration with
Angular, React, and Vue.js is smooth and requires just a few quick steps
described in our guides.
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.
The documentation for Spreadsheet includes API references and comprehensive guides,
enabling you to set up and customize your spreadsheets easily. It also provides
instructions on seamlessly integrating the library with React, Svelte, Angular,
and Vue.js.
You have a great option to work with the Spreadsheet online, test out JavaScript and
HTML code variations, and share your unique code snippets with your colleagues or
DHTMLX support team.
We recommend you explore the DHTMLX Spreadsheet functionality by obtaining the free
30-day trial version, complete with the latest updates and official technical support.
There's no need for a credit card during the trial.
Whether you're a trial user or own a proprietary license, you can rely on DHTMLX
technical or licensing assistance. We’ve outlined the ways to obtain support on the
linked page.
You can exchange knowledge with other DHTMLX users and access the insights shared
by fellow developers who are well-acquainted with the Spreadsheet. We diligently
keep track of discussions and answer frequently raised questions.
The DHTMLX blog serves as an extensive knowledge base, providing the latest information
on Spreadsheet releases with in-depth feature descriptions, useful tips, technical
tutorials, and updates on other offerings and developments from our team.