📄️ Initialization
Initialize DHTMLX Spreadsheet on a page by including the source files, adding a container and calling the dhx.Spreadsheet constructor with a configuration object.
📄️ Configuration
Configure DHTMLX Spreadsheet. Set up the toolbar, the editing bar, the menu, the number of rows and columns, the read-only mode, the selection of cells and number formats.
📄️ Data loading and export
Load JSON, CSV or Excel data with styles, locked cells and links into DHTMLX Spreadsheet from a file or a local source, save and restore the state, and export data to Excel or JSON.
📄️ Work with Spreadsheet
Undo and redo actions, add, remove, freeze and hide rows and columns, autofit column width, filter, search and sort data, and clear DHTMLX Spreadsheet with the API.
📄️ Work with sheets
Load multiple sheets into DHTMLX Spreadsheet, and add, remove, get, clear and switch sheets with the API methods.
📄️ Work with cells
Set and get cell values and styles, validate cells, insert links, and edit, lock, merge and select cells in DHTMLX Spreadsheet with the API.
📄️ Number formatting
Apply number, currency, percent, date, time and scientific formats to cell values in DHTMLX Spreadsheet, localize them, define custom format masks and set or get the format of a cell.
📄️ Formulas and functions
Use the Excel and Google Sheets compatible formulas in DHTMLX Spreadsheet, including math, date, lookup, string and financial functions, add custom formulas and get the formula of a cell.
📄️ Event handling
Attach and detach event listeners and call events in DHTMLX Spreadsheet with the events.on(), events.detach() and events.fire() methods.
🗃️ Localization
1 item
📄️ Customization
Customize DHTMLX Spreadsheet. Change icons, and add, update and delete controls of the toolbar, the menu and the context menu, or build a custom read-only mode.
🗃️ Themes
3 items
📄️ TypeScript support
Use the built-in TypeScript definitions of DHTMLX Spreadsheet for type checking, autocompletion and JSDoc hints in your IDE.
📄️ AwaitRedraw helper
Run code after DHTMLX Spreadsheet finishes rendering with the dhx.awaitRedraw helper, for API methods that take effect only once the component is on the page.
📄️ DHTMLX MCP server
Live DHTMLX Spreadsheet documentation reaches AI assistants through the MCP server, spanning formulas, cell formatting, data loading, and sheet management.