dhtmlxSpreadsheet Reborn in Major Update 3.0

Here comes dhtmlxSpreadsheet 3.0, entirely renewed and redesigned JavaScript spreadsheet component with a range of major improvements. We’ve got rid of PHP dependency transforming it into a pure client-side JavaScript widget. The API has been thoroughly modified making room for various configuration options and operations for the grid. The interface has acquired the stylish Material look. Our Spreadsheet component has also received support for Angular, React, and Vue.js.

Fine-tune Your JavaScript Spreadsheet

V3.0 presents a highly adjustable structure for dhtmlxSpreadsheet, which consists of Menu, Context Menu, Toolbar, Editing Line, and Grid. All of these elements can be easily configured. For instance, you can put a limit on the number of columns and rows in the grid for your purposes:

Besides, you can restrict access to Spreadsheet for end users by means of the read-only mode enabled via the readonly configuration option. Events will help you to customize this mode and make some parts of Spreadsheet unavailable by blocking the operations of your choice:

Reorganized API Simplifies Work With Spreadsheet

Developers’ work with Spreadsheet is simplified due to the reorganized and detailed API. Now there are plenty of coherent methods for performing operations in the grid, for example, undo and redo actions, adding and removing columns and rows, locking and unlocking cells etc.

Spreadsheet enables extensive styling of cells and cell values. You can define the background color of cells, text decoration and text alignment of values in cells. Besides, you can clear the styles applied to cells, their values or both.

The main objective of dhtmlxSpreadsheet is providing a safe and convenient way to process large amounts of data. The safety of all operations is ensured by storing your data on your server. Loading data can be fulfilled from an external file in a JSON or CSV format via the load method or a local source with the help of the parse method. The serialize method makes it possible to save the processed data in the current state and paste it to another spreadsheet.

// saving state of the spreadsheet1var state = spreadsheet1.serialize();

// parsing the state of the spreadsheet1 into spreadsheet2
spreadsheet2.parse(state);

Angular, React, and Vue.js Supported

From now on, using our JavaScript Spreadsheet in an app based on any of these three popular frameworks is a piece of cake. You’re free to choose one of the two simple scenarios for initializing Spreadsheet with Angular, React, or Vue.js. Check our initialization guides: