jExcel Pro v4: The javascript spreadsheet

jExcel is a lightweight vanilla javascript plugin to create amazing web-based interactive tables and spreadsheets compatible with spreadsheet softwares, such as Excel or Google Spreadsheet. It is very easy to integrate with any web-based software and will transform simple tables/grids in rich dynamic tables improving the user experience and helping developers to create amazing interfaces.

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

  • Make rich and user-friendly web interfaces and applications
  • Handle complicated data inputs in a way users are familiar with
  • Improve software user experience
  • Create rich CRUDS and beautiful UI
  • Compatibility with excel: copy and paste, formulas, etc.
  • High flexible and extensible
  • Lightweight, fast and simple to use
  • Thousands of successfully user cases


Differences between the Pro and Community Edition Versions

The most significant difference is the Pro loading and formulas engine. When using lazyloading or pagination, the cells are created as you needed and this improves the performance when dealing with big tables. But, there are other differences, some extra features, and the availability to store your spreadsheets on the cloud and the professional support level.

The CE Edition is very important, and the subscription options for the Pro edition helps to maintain the Community Edition as one of the best javascript spreadsheet software on the internet.



Create amazing online spreasheets

A example how to embed a simple javascript spreadsheet in your application. You can check out for more examples here.


Source code example

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

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

<script>
var data = [
    ['Jazz', 'Honda', '2019-02-12', '', true, '$ 2.000,00', '#777700'],
    ['Civic', 'Honda', '2018-07-11', '', true, '$ 4.000,01', '#007777'],
];

jexcel(document.getElementById('spreadsheet'), {
    data:data,
    columns: [
        {
            type: 'text',
            title:'Car',
            width:90
        },
        {
            type: 'dropdown',
            title:'Make',
            width:120,
            source:[
                "Alfa Romeo",
                "Audi",
                "Bmw",
                "Chevrolet",
                "Chrystler",
                "Dodge",
                "(...)",
              ]
        },
        {
            type: 'calendar',
            title:'Available',
            width:120
        },
        {
            type: 'image',
            title:'Photo',
            width:120
        },
        {
            type: 'checkbox',
            title:'Stock',
            width:80
        },
        {
            type: 'numeric',
            title:'Price',
            mask:'$ #.##,00',
            width:80,
            decimal:','
        },
        {
            type: 'color',
            width:80,
            render:'square',
        },
     ]
});
</script>
</html>

Installation

<link rel="stylesheet" href="https://jexcel.net/v4/jexcel.css"
    integrity="sha384-Vkoo8x4CGsO3+Hhxv8T/Q5PaXtkKtu6ug5TOeNV6gBiFeWPGFN9MuhOf23Q9Ifjh" crossorigin="anonymous">

Register and download



jExcel History


Jexcel 4.0.1

  • Freeze columns
  • Multiple column resize
  • New smart key navegation
  • 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
  • Superevent: 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 v3 is a complete rebuilt javascript vanilla version. For that reason it was not possible to keep a complete compatibility with the previous version. If you are upgraging you might need to implement a few updates in your code. If you have questions, you can review the article upgraging from jExcel v2 or Handsontable.

Jexcel 3.0.1

The jExcel v3 brings 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 compatibily
  • Amazing keyboard navegation support
  • Better hidden column management
  • Great data picker: dropdown, autocomplete, multiple, group options and icons
  • Importing from XSLX (experimental)

Big improviments are included, such as:

  • Complete new formula engine with no external depencies 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

  • React Implementation
    A full example on how to integrate jExcel with React

  • VUE Implementation
    A full example on how to integrate jExcel with Vue

  • Jquery Implementation
    A full example on how to integrate jExcel with Jquery

  • Lazy loading
    This example brings a very nice feature to deal with large table datasets.

  • Search and pagination
    Full spreadsheet example with search and pagination to bring great compatibility for those who love datatables.

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

  • Advanced dropdown
    Full examples on how to handle simple, advanced, multiple, autocomplete and conditional dropdowns. Create amazing javascript tables using categories and images in your dropdowns.

  • Date and datetime picker
    Example from basic to advanced calendar usage, date and datetime picker

  • Images
    This examples shows how to embed and upload images to your spreadsheet

  • Programmatically updates
    How to update your spreadsheet and its data by javascript

  • Table Style
    Bring a very special touch to your applications customizing your javascript spreadsheet.

  • Table Scripting
    Customize the table behavior using javascript

  • Events
    Learn how to handle events on jExcel

  • Importing data
    How to import data from an external CSV, json file or XLSX.

  • Formulas
    Unleash the power of your tables bringing formulas and custom javascript methods on your jExcel spreadsheet.

  • Custom toolbars
    Full example on how to enable nor customize your javascript spreadsheet toolbar.

  • Column comments
    Allow comments in your table spreadsheet.

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

  • Translations
    How to translate the default messages from jExcel

  • Meta information
    Keep hidden information about your cells using meta information methods

  • Merged cells
    Full example on how to handle merge cells in your javascript tables.

  • Sorting columns
    Example how to sort the table by a column via javascript.

  • Readonly Columns
    Example how to setup readonly cells

  • Custom Contextmenu
    How to customize jexcel contextmenu

  • Freeze columns
    Setup freeze columns in jExcel



Copyright and license

This software is free for any non-commercial use. For commercial use, please choose one of our subscription plan is for you.

A licence is required to use this software. You must register even for non-commercial use.

Copyrights belong to Paul Hodel




About jExcel

The jExcel Pro is a full original javascript software created to facilitate the data manipulation in web based applications. It was created to be an easy javascript data input tool for users and it was created inspired on the Handsontable and the Microsoft Excel.

This software has two different versions CE and Pro and was created to be a light alternative to Handsontable javascript spreadsheet. So, some keywords in the configuration and initialization directives could be similar to make easy any migration from Handsontable to jExcel.

The first time we were involved in a web based spreadsheet development was in 2005, when we created the datagrid inspired in dhmlx. But, because the lack of audience we decided to discontinuate its development. A few years ago, we found and started to use Handsontable. It is a great piece of software. But, in a certain extension very complicated for integrations and sometimes limited, for example it is not possible to have a simple key-value dropdown. So, we decided to build something from the scratch, complete original but with a goal to keep as simple as possible any transition between any Handsontable to jExcel.

If you are a developer and 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, so it will be easy to integrate jExcel to any of your applications. We would like to make sure you will have a great start with our tool, so if you have any question, just let us know. We are always willing to help. All for free!

All trademarks belong to their respective owners.