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.

spreadsheet
invisible 1 2 3 4 5

NEW features

  • Strict mode for plus operation.
  • Hide/show sheets via the menu.
  • Preview of print page borders.

1. Import and export

Import Excel documents to your web SpreadSheet and export information to Excel, PDF or PNG files.

2. New functions

Create your own functions for working with data in cells.

3. Flexible SpreadSheet UI customization

Add a formula editor, subbars, menus, set the number of columns and rows.

4. Localization

Adjust dates, numbers, monetary units and text labels to comply with the rules of particular countries.

5. Additional UI components and Webix API

Use popups, dialogs and other components from Webix UI library to extend functionality.

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

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.

JavaScript SpreadSheet live demo

Spreadsheet JavaScript coding samples

Search: cell highlighting

Search: cell highlighting

Highlighting cells with the desired sequence of symbols

Custom search filter

Custom search filter

Displaying rows with the data that meets the search condition

DataTable in Dialog

DataTable in Dialog

Possibility to display dialog windows with the tables inside

Custom comments

Custom comments

Comments widget integration into Spreadsheet

Adding images into cells

Adding images into cells

Possibility to place an image inside one or several cells

External UI - Custom Views

External UI - Custom Views

Creating custom views - floating tables

Placeholders

Placeholders

An example of the UI with the use of placeholders

Conditional formats

Conditional formats

An example of conditional formatting implementation

Excel Style Filters

Excel Style Filters

An example of the filters implementation

Dropdowns

Dropdowns

An example of the dropdowns implementation

Sorting

Sorting

An example of the sorting implementation

Sparklines

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?

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.

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.

Webix SpreadSheet licensing