jExcel v3: The javascript spreadsheet

jExcel is a lightweight vanilla javascript plugin to create amazing web-based interactive tables and spreadsheets compatible with Excel or any other spreadsheet software. You can create an online spreadsheet table from a JS array, JSON, CSV or XSLX files. You can copy from excel and paste straight to your jExcel spreadsheet and vice versa. It is very easy to integrate any third party javascript plugins to create your own custom columns, custom editors, and customize any feature into your application. jExcel has plenty of different input options through its native column types to cover the most common web-based application requirements. It is a complete solution for web data management. Create amazing applications with jExcel javascript spreadsheet.

With a few simple steps, you can have jExcel integrated into your applications. Impress your clients with better user experience with this amazing data interactive tool.

Make rich and user-friendly web interfaces and applications

You can easily handle complicated data inputs in a way users are used to

Improve your user software experience

Create rich CRUDS and beautiful UI

Compatibility with excel: users can move data around with common copy and paste shortcuts

Easy customizations with easy third-party plugin integrations

Lean, fast and simple to use

Thousands of successfully user cases

Speed up your work dealing with difficult data entry in a web-based software

Create amazing online spreasheets

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

<html> <script src="https://bossanova.uk/jexcel/v3/jexcel.js"></script> <link rel="stylesheet" href="https://bossanova.uk/jexcel/v3/jexcel.css" type="text/css" /> <script src="https://bossanova.uk/jsuites/v2/jsuites.js"></script> <link rel="stylesheet" href="https://bossanova.uk/jsuites/v2/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", "Ferrari", "Fiat", "Ford", "Honda", "Hyundai", "Jaguar", "Jeep", "Kia", "Mazda", "Mercedez-Benz", "Mitsubish", "Nissan", "Peugeot", "Porsche", "Subaru", "Suzuki", "Toyota", "Volkswagen" ] }, { 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>

% npm install jexcel

jExcel History

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

Or download from our Github Official

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

React Implementation

A full example on how to integrate jExcel with React

VUE Implementation

A full example on how to integrate jExcel with Vue

Angular Implementation

A full example on how to integrate jExcel with Angular

Jquery Implementation

A full example on how to integrate jExcel with Jquery

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

Lazy loading

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

Custom Contextmenu

How to customize jexcel contextmenu

Table overflow

How define a fixed width and height for the jexcel tables.

Copyright and license

jExcel is released under the MIT license.

The software is registered under UK law, copyrights belong to Paul Hodel

About jExcel

The jExcel 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 is free 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.