JavaScript SpreadSheet widget UI library for web developers | SpreadJS

SpreadSheet JavaScript UI widget for web developers

Webix SpreadSheet is a customizable web widget which offers all functions of Excel-style spreadsheets. All the regular functions of the desktop Excel will be available for you (formulas and math, sorting and filtering, editing, various types of data). Add SpreadSheet JavaScript component into your business application with just 5 rows of the code.

What is SpreadSheet?

It is an application to work with table data. Using SpreadSheet you can perform calculations, automate data entry and processing, conveniently visualise table data, create pivot tables and more. Webix offers a unique UI widget which offers SpreadSheet functionality directly in the browser, on the client side. All the power and functionality of the spreadsheets can be integrated into any business application. It is a ready-made solution that allows you to save many hours of web development and UI design.

Why use JS SpreadSheet?

Flexible calculations

Calculations may take place on both the client and server sides of your application.

Super fast rendering

Our SpreadSheet is deeply optimized and allows to instantly draw huge amounts of data.

Excel file formats support

Spreadsheet control can load Excel documents initially or open them like an Excel application with data accuracy, styles, and formats. Support of Microsoft Excel (.xlsx) and Microsoft Excel 97-2003 (.xls) formats.

Documentation, support, examples

Product with a detailed documentation and technical support service.

Easy backend integration

Explicit Integration with PHP, Node.js, Golang and .NET.

Customizable

All elements can be adjusted through API, without need to edit anything in source codes (which are provided by the way).

Easy frontend integration

Сan work with all modern frameworks. You can use it standalone or inside the React of an Angular app.

Cross platform and browser support

Support of All Modern browsers.

Advanced Excel-like features for your JavaScript web apps

Formulas and math
Sorting and filtering
Visual information
Clipboard
Advanced data interaction
Data protection
Data look-and-feel customization
DataTable settings
Interaction with offline formats
Built-in charts and their detailed configuration
Enriched Math for Spreadsheet
Different types of diagrams

Use formulas with built-in functions that correspond to Excel ones, including named ranges functionality.

Simplify the perception of data with sorting, filtering and conditional formatting.

Add images and sparklines for visual display of data.

Copy and paste information from the clipboard to other cells or Excel files.

Use enhanced SpreadSheet functionality: apply string concatenation, add drop-down lists, connect data between sheets, etc.

Use the read-only mode to protect cells or sheets from being edited.

Set the way of data presentation: from the color of the text to cell data format.

Use multiple sheets, add or hide rows and columns in a single click, сhange the cell size by dragging and manage the visibility of cell borders and gridlines.

Upload Excel documents and download ready Excel, PDF or PNG files.

features-10

The ability to build in and configure the chart in detail (type, range of values, color of the chart, legend settings, etc.)

$features-11$

The ability to use more than 200 mathematical functions.

features-12

Choose the chart type you like.

Spreadsheet JavaScript coding samples

Search: cell highlighting

Highlighting cells with the desired sequence of symbols

Custom search filter

Displaying rows with the data that meets the search condition

DataTable in Dialog

Possibility to display dialog windows with the tables inside

Custom comments

Comments widget integration into Spreadsheet

Adding images into cells

Possibility to place an image inside one or several cells

External UI - Custom Views

Creating custom views - floating tables

Placeholders

An example of the UI with the use of placeholders

Conditional formats

An example of conditional formatting implementation

Excel Style Filters

An example of the filters implementation

Dropdowns

An example of the dropdowns implementation

Sorting

An example of the sorting implementation

Sparklines

An example of adding the Sparklines

FAQ

What are complex widgets?

These are full-fledged single page apps with the ready-made back-end and front-end layers, that can be downloaded and built into any solution. A full list of complex widgets can be found here.

What mathematical formulas and functions does Webix SpreadSheet support?

You will find a list of built-in functions on this page. You can also add your own functions in accordance with this manual.

Does Webix Speedweek allow to build graphs?

Yes, it does. Spreadsheet allows you to use both regular charts, and sparklines.

Is Spreadsheet compatible with the Webix community (opensource) edition?

No, it isn't. All complex widgets require the commercial package Webix Pro.

Where can I see all features and opportunities of Webix Spreadsheet?

You can contact us to arrange a presentation.
You can use the samples catalog.
Also we have described in detail all the opportunities in the documentation.

Where does Spreadsheet perform calculations: on the back-end side or in the browser (front-end)?

All calculations are performed on the client side, in the browser.

Does Webix Spreadsheet have a formula editor?

Yes. You need to activate the corresponding setting. Here is an example of the working editor that allows you to create formulas in Excel style when you click the "=" symbol.

Is there compatibility with MS Excel data format?

Yes, there is. You can import data from Excel files and export it back to Excel.

Will Spreadsheet work after the trial period expires?

When the trial period expires, all the functionality of the Spreadsheet will be blocked. But you can contact us to extend the trial period.

Can I change the UI and the design for Webix Spreadsheet?

Definitely. Complex widgets are easy to configure, integrate, and customize. To help with that we have created a detailed documentation.