ALERT: Please upgrade to version 4.

jExcel v2: The javascript spreadsheet

jExcel CE is a very light, totally free, jquery plugin to embed a spreadsheet compatible with Excel in your website or application. You can create a excel-like table from a JS array, json or even a CSV file. You can use your copy and paste shortcuts to move data from excel straight to your jExcel spreadsheet and vice versa. You can easily integrate third party jquery plugins to create your own custom colums, custom editors, and customize new features to your clients. jExcel has a plenty of nice features such as key-value dropdown, CSV loading/exporting, multiple spreadsheets and much more. We have a large roadmap ahead for our jquery plugin and we are constantly improving, so don't forget to send us your ideas.

The benefits to embed a jquery spreadsheet in your applications

With a few simple steps you can have jExcel integrated to your application. So, you can easily enjoy all advantages of this great jquery plugin.

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 clients 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 jquery plugin integrations

Lean, fast and simple to use

Screenshot

New features in the jExcel CE Version:

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

Jexcel 2.1.0

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

How to embed a simple javascript spreadsheet in my application?

A very simple example to integrate the jexcel jquery plugin in your website to create your first online spreadsheet. You can check out more advanced examples here.

<html> <script src="https://cdnjs.cloudflare.com/ajax/libs/jquery/3.1.1/jquery.min.js"></script> <script src="https://cdnjs.cloudflare.com/ajax/libs/jexcel/2.1.0/js/jquery.jexcel.min.js"></script> <link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/jexcel/2.1.0/css/jquery.jexcel.min.css" type="text/css" /> <div id="my"></div> <script> data = [ ['jExcel', 'Jquery spreadsheet, javascript spreadsheet, jquery', 181], ['Handsontable', 'Another nice javascript spreadsheet plugin', 9284], ['Datatables', 'DataTables is a table enhancing plug-in for the jQuery library.', 5164], ]; $('#my').jexcel({ data:data, colWidths: [ 300, 80, 100 ] }); </script> </html>

We are working hard to create the better jquery plugin possible. So, we would love to hear your ideas. Which features is missing in our jquery spreadsheet? We are glad to say new features are coming every day, and we are currently working in features such as:

Merged cells

Big data (partial table loading)

Pagination

Online work collaboration

Toolbar with undo, redo, colors, etc

Themes

Status bar

More suggestions are welcome to improve our jquery plugin. Please send your comments in our Github page.

Advanced dropdowns

Full examples on how to handle simple, advanced, autocomplete and conditional dropdowns.

Programmaticaly data changes

Insert, remove and move columns and rows

Fixed headers and scrollings

Overflow table and scrolling

Custom table design

Create a custom table design. For example a bootstrap-like spreadsheet table.

Table styling

Table styling

Manage cell comments

Manage a table cell comments

Custom meta information

Manage the table meta information

Custom toolbars

Full examples how to load a autocomplete dropdown.

Loading remote data

How to load the data from an external CSV file into a jExcel grid or table.

Masking and formating

Handling currency types and masking numbers.

Calendar picker

How to handle a calendar with date and datetime picker.

Sorting

Sorting your jExcel spreadsheet

Create custom cells

How to create custom column types based on a third party jquery plugin

Handling events

Handling events on your spreadsheet

Readonly options

Understanding how to set a readonly column or multiple custom cells

Multiple instances

How to create multiple table instances in the same page

Text wrap

How to change the text wrap behavior in a jExcel column

Nested headers

Creating a jExcel table with nested headers.

Add images on your cells

Add images on your spreasheet cells

Copyright and license

New jExcel Pro Version

jExcel is released under the MIT license. Copyrights belong to Paul Hodel

We have now two versions jExcel CE and jExcel Pro. We are very happy to bring a new version vanilla javascript plugin with full premium support.

More about the new jExcel Pro The professional javascript spreadsheet.

About jExcel

The jExcel is a full original javascript software created as a jquery plugin 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 coulb 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.