Jexcel Pro v5: The JavaScript spreadsheet

jExcel, a lightweight Vanilla JavaScript plugin, can help you create exceptional web-based interactive tables and spreadsheets. Compatible with most widely-used spreadsheet software, such as Excel or Google Spreadsheet, it offers users an unrivalled Excel-like user experience. It also works well with prominent modern frameworks and flexibly utilizes a large collection of events, extensions and configurations to meet different application requirements. Impress your clients with a better user experience and a great dynamic interactive data management tool.

Impress your clients with a better user experience and a great dynamic interactive data management tool.

  • Make rich and user-friendly web interfaces and applications
  • Handle complicated data inputs with ease and convenience
  • Use shortcuts such as CTRL+C, CTRL+V to move data from/to any other spreadsheet software
  • Improve software user experience
  • Create rich CRUDS and beautiful UI
  • Highly flexible and customizable
  • Lightweight and simple to use
  • Thousands of successful user cases


Start your free trial now

After you create a free account, you will receive specific instructions on how to download and start using jExcel. There is no time limit for your evaluation period; you will need a valid license only when you are ready to deploy your applications.

Click here and start with JExcel Pro



Create amazing online spreadsheets

A basic example how to embed a JavaScript spreadsheet on your applications. I would like to see more examples.



Source code example

<html>
<script src="https://jexcel.net/v5/jexcel.js"></script>
<script src="https://jexcel.net/v5/jsuites.js"></script>
<link rel="stylesheet" href="https://jexcel.net/v5/jsuites.css" type="text/css" />
<link rel="stylesheet" href="https://jexcel.net/v5/jexcel.css" type="text/css" />

<div id="spreadsheet"></div>

<script>
jexcel(document.getElementById('spreadsheet'), {
    minDimensions: [10,10],
    license: '39130-64ebc-bd98e-26bc4',
});
</script>
</html>


Differences between the Pro and Community Edition Versions

Feature Description
DOM management With a new DOM management engine, the pagination and lazy loading options allow for higher efficiency in table rendering.
Formula parsing The upgraded formula engine ensures that the efficiency and accuracy of calculations are enhanced, even when dealing with chained formulas.
Data persistance It offers complete support for data persistence. Developers can persist not only data, but also the properties of data tables in a remote server. Data tables can thus be easily recreated.

Stronger integration with remote servers enables better management of record IDs and remote data persistence.
Decouple editors It allows the overwriting of column properties for one specific cell. For example, the table can be configured to render a drop down in one specific cell within a text type column.
Filter options It has the column property filterOptions, which helps developers overwrite the behavior of a cell based on the values of another cell. For example, I have two date columns in a table; the second should not have a date that is before the one in the first.
Real-time collaboration Its real-time spreadsheet online sharing capacity gives multiple users the opportunity for effective collaboration.
Custom editor template It offers a lot of new native columns types and provides a new simplified custom type template. Developers can extend and create new custom column types within mere minutes.
Worksheet management The advanced integrated tab management system gives users a higher degree of flexibility in their usage, including the option to create new worksheets inside a spreadsheet.
Add-ons and extensions It supports add-ons and plugins, which allows developers to use third-party extensions or create their own add-ons.
Premium support It offers timely and comprehensive technical support to help developers maximize the potential of jExcel Pro and fulfil any application requirements.


jExcel History

Jexcel 5.0.0

  • Calendar filter, to create conditions before open
  • New detached borders and copying indication border
  • New formula and loading engine
  • New faster navegation options
  • Various different native column type implementations
  • New decouple custom column template object
  • New cells property capable to set a type for one specific cell
  • HTML content compabilibiliy
  • Complete data and configuration persistence support
  • Remote tables and table multiple users syncronization (jExcel Cloud)
  • Theme
  • Fixed formulas on footers
  • Formula can return DOM elements
  • Dynamic column type changing

Jexcel 4.0.1

  • Freeze columns
  • Multiple columns resize
  • New smart key navigation
  • New smart merge cell methods
  • Support for large tables, only loads what is necessary when using lazyloading or pagination
  • Faster formula engine
  • New native formula methods
  • Super event: centralized event handler method
  • Easier backend integration

Jexcel 3.6.0

  • Better formula parsing
  • New events
  • New initialization options
  • General fixes

Jexcel 3.2.3

  • getMeta, setMeta methods
  • Npm package with jSuites
  • General fixes

Jexcel 3.0.1

jExcel v3 is a complete rebuilt JavaScript Vanilla version. For that reason, it was not possible to keep complete compatibility with the previous version. If you are upgrading you might need to implement a few updates in your code. If you have questions, you can review the article upgrading from jExcel v2 or Handsontable.

The jExcel v3 brings a lot of great new features:

  • Drag and drop columns
  • Resizable rows
  • Merge columns
  • Search
  • Pagination
  • Lazy loading
  • Full-screen flag
  • Image upload
  • Native color picker
  • Better mobile compatibility
  • Better nested headers compatibility
  • Amazing keyboard navigation support
  • Better hidden column management
  • Great data picker: dropdown, autocomplete, multiple, group options and icons
  • Importing from XSLX (experimental)

Big improvements are included, such as:

  • A completely new formula engine with no external dependencies with much faster results.
  • Absolutely no selectors, means a much faster application
  • New native columns
  • No jQuery is required
  • React, Vue and Angular examples
  • XLXS support using a custom sheetjs (Experimental).

Jexcel 2.1.0

We are glad to bring you the latest jquery plugin version, with the following improvements:

  • Mobile touch fixes
  • Paste fixes & New CSV parser

Jexcel 2.0.0

  • New radio column
  • New dropdown with autocomplete and multiple selection options
  • Header/body separation for a better scroll/column resize behavior and compatibility
  • Better text-wrap including alt+enter excel compatibility
  • New set/get meta information
  • New set/get config parameters
  • New set/get programmatically cell style
  • New set/get cell comments
  • New table custom toolbar
  • New responsive calendar picker

Jexcel 1.5.7

  • Checkbox column type improvements
  • Destroy jquery table updates

Jexcel 1.5.1

  • Spreadsheet data overflow and fixed headers. See an example
  • Navigation improvements

Jexcel 1.5.0

  • Relative insertRow, deleteRow, insertColumn, deleteColumn. See an example
  • Redo, Undo action tracker for insertRow, deleteRow, insertColumn, deleteColumn, moveRow
  • New formula column recursive chain
  • New alternative design option bootstrap-like. See an example
  • updateSettings updates


Javascript spreadsheet examples

  • Loading from a JSON object
    How to create a dynamic table from a JSON object.

  • Using tabs
    How to enable tabs on the online spreadsheet, so that users can add new worksheets.

  • Formulas on table footer
    Adding fixed formulas on the table footer.

  • Column filters
    How to enable column filters on a jExcel spreadsheet.

  • Spreadsheet as a webcomponent
    How to create a spreadsheet JavaScript webcomponent using jExcel.

  • React Implementation
    An example of how to integrate jExcel with React.

  • VUE Implementation
    An example of how to integrate jExcel with Vue.

  • Angular Implementation
    An example of how to integrate jExcel with Angular.

  • Jquery Implementation
    An example of how to integrate jExcel with jQuery.

  • Lazy loading
    An example of tackling large table datasets using jExcel Pro.

  • Search and pagination
    An example of utilizing search and pagination to tackle big datasets.

  • Column types
    Learn more about the powerful column types. This example demonstrates all native column types and how to create your own custom type.

  • Advanced dropdown
    Examples of how to handle simple, advanced, multiple, autocomplete, and conditional dropdowns. Learn how to add groups and images to your dropdown column type.

  • Date and datetime picker
    An example of basic to advanced calendar usage, date and datetime picker, valid date ranges, and conditional rendering.

  • Images
    An example of how to embed and upload images to your spreadsheet.

  • Email and Links
    Learn how to embed links and email to your spreadsheet.

  • Progressbar
    Include a progress bar column type in your spreadsheet to create a better visual experience for your applications.

  • Autonumber
    Learn how to use the autonumber column type in your spreadsheet to enhance the syncing of the spreadsheet data with databases, as well as date persistence.

  • HTML editor
    Learn how to allow users to include rich text to your spreadsheet using the new HTML editor column type.

  • Custom column type
    How to create custom column types using jExcel Pro.

  • Programmatically updates
    Learn how to apply changes to your table programmatically. Learn how to add, delete and move columns and rows, sorting, and other options.

  • Table Style
    Learn how to customize your JavaScript spreadsheet and bring a better visual experience to your applications.

  • Table Scripting
    Learn how to tackle conditional actions in your spreadsheet based on the available data within it.

  • Events
    Create rich and advanced spreadsheet behaviors using JavaScript events.

  • Importing data
    How to create a new spreadsheet based on different data sources, such as CSV, JSON, array, or XLSX files.

  • My first table
    Create a basic JavaScript spreadsheet.

  • Create a javascript spreadsheet from a CSV file
    How to create a JavaScript spreadsheet or data grid based on a CSV file.

  • Formulas
    Learn how to use jExcel-like formulas on your JavaScript tables.

  • Custom Formulas
    Unleash the power of your tables by bringing formulas and custom JavaScript methods to your jExcel spreadsheet.

  • Spreadsheet toolbars
    An example of how to enable or customize your JavaScript spreadsheet toolbar.

  • Column comments
    How to allow comments in your table spreadsheet.

  • Headers
    Enable nested headers in your spreadsheet and learn how to set or get header values.

  • Translations
    How to translate default messages from jExcel.

  • Meta information
    Manage hidden information about your cells using meta information methods. Learn how to set and reveal hidden information.

  • Merged cells
    An example of how to merge cells in your JavaScript tables.

  • Sorting columns
    An example of how to sort the table by columns via JavaScript.

  • Readonly Columns
    How to use readonly columns and cells. Learn how to programmatically change the readonly status of one cell.

  • Custom Contextmenu
    How to use and customize the spreadsheet contextmenu. Learn how to add custom actions to your spreadsheet.

  • Freeze columns
    Set up freeze columns in a jExcel JavaScript spreadsheet.

  • Create from a HTML table
    Create a jExcel table from a simple HTML table.

  • Dealing with remote IDs
    Learn how to manage and sync remote IDs of database records with your spreadsheets.

  • Data persistence
    Learn how data persistence can help you create exceptional online spreadsheets.

  • Including charts on your spreadsheets
    Learn how to include charts on your spreadsheets.



Copyright and license

This software is free for any non-commercial usage. For commercial usage, please choose from our subscription plans.

Copyrights belong to Paul Hodel




About jExcel

Inspired by Handsontable and Microsoft Excel, the jExcel Pro is a fully original JavaScript software created to facilitate data input and manipulation in web-based applications.

This software has two different versions—CE and Pro. It is a lightweight alternative to the Handsontable JavaScript spreadsheet. Therefore, certain keywords in the configuration and initialization directives will be familiar to Handsontable users. This allows for easy migration from Handsontable to jExcel.

The first time we were involved in a web-based spreadsheet development was in 2005, when we created a datagrid inspired by DHTMLX. However, because of the lack of audience, we decided to discontinue its development. A few years ago, we discovered Handsontable. It is an excellent software, but in certain extensions, we were limited from making integrations of a greater complexity. For example, it is not possible to have a simple key-value dropdown. We saw the opportunity and decided to build something from scratch—it would be completely original and allow for a simple transition between Handsontable and itself.

If you are a developer who likes Microsoft Excel, Handsontable, DataGrid, or would like to give users a new user-friendly experience, you are in the right place. You can manipulate the jExcel JavaScript spreadsheet data with JSON, CSV, or simple arrays, making it easy for you to integrate jExcel into any of your applications. We want to make sure that you enjoy using our tool and find it useful, so if you have any questions, just let us know. We are always happy to offer you free help!

All trademarks belong to their respective owners.