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.
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.
Other Webix widgets:
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
The ability to build in and configure the chart in detail (type, range of values, color of the chart, legend settings, etc.)
The ability to use more than 200 mathematical functions.
Choose the chart type you like.
JavaScript SpreadSheet live demo
1
2
3
4
5
6
Report - July 2016
Region
Europe
Europe
Europe
Asia
Country
Germany
France
Poland
Japan
Sales - Group A
$188,400.00
$192,200.00
$68,900.00
$140,000.00
Sales - Group B
$52,000.00
$12,000.00
$8,000.00
$14,000.00
Total
$240,400.00
$204,200.00
$76,900.00
$154,000.00
Sales - Group A
Sales - Group B
Total
Report - July 2016
Report - July 2016
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
You will find a list of built-in functions on this page. You can also add your own functions in accordance with this manual.
Yes, it does. Spreadsheet allows you to use both regular charts, and sparklines.
No, it isn't. All complex widgets require the commercial package Webix Pro.
- 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.
All calculations are performed on the client side, in the browser.
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.
Yes, there is. You can import data from Excel files and export it back to Excel.
When the trial period expires, all the functionality of the Spreadsheet will be blocked. But you can contact us to extend the trial period.
Definitely. Complex widgets are easy to configure, integrate, and customize. To help with that we have created a detailed documentation.
