Tutorial: Introduction

Introduction


Edit this page

What is Handsontable Pro

Handsontable Pro is our premium spreadsheet solution packed with business-ready features. It comes with forum support, where you can find the answers to common questions as well as talk directly with our core team members.

This software is based on a free and open source project, Handsontable, which is a composite spreadsheet component for apps and websites. It is written in JavaScript and not constrained by any external framework. Handsontable can be easily modified or extended with custom plugins. It also binds to any source using the JSON format and is capable of handling a large amount of data. You can easily do all CRUD operations and provide end-users with an Excel-like experience.

Typical use cases

The list below is just to give you a rough idea on what you can do with Handsontable, but it doesn't limit you in any way. If you have already created an inspiring app, share it with others on our forum.

  • Database editing
  • Configuration controlling
  • Data merging
  • Workforce planning
  • Sales reporting
  • Financial analysis

Basic concepts

Handsontable introduces a new approach to building spreadsheets for web projects. Typically, libraries like this give you all the features in one, pre-built package. This is not very effective as spreadsheets are usually very complex and heavy tools, so even though you just need just a single feature, you end up with overhead code.

Handsontable is different as it allows you to exclude all the unnecessary plugins from the package. It's created with modularity in mind and most plugins are developed upon the lightweight core. Not all the features have been moved from the core to plugins yet, but we're nearly there.

Concepts or technologies at the heart of Handsontable:

  • Extensibility - it makes possible to build new functionalities upon the core and only use those required in a certain project. It gives you the real freedom of creating.
  • ECMAScript 2015 (ES6) - in the future the most important parts of the library will be rewritten to ES6 provide a better control over the code.
  • Virtual rendering - also known as "lazy loading". In a nutshell, we don't render the cells outside the viewport until you scroll down or across the table to see them. This allows to handle large datasets, some of which can contain over thousands of rows.

Getting help

Generally, using Handsontable doesn't require advanced programming skills. However, if you need any custom modifications and have just started with JavaScript you may need some assistance from a more experienced developer. We would be glad to help.

If you are new to Handsontable then begin with the Quick start page, which will give you a good idea on the features this library has. You might also want to dig a bit deeper in the Basic usage section, which will guide you step by step on how to create your first app.

If you get stuck with something, then the best way to get an answer is our forum. Don't hesitate to share your thoughts and opinions there.

Priority support

If you need an instant answer to your question, then we are here to help your business. As creators of Handsontable we know this solution inside out. Contact us for more details.