jQuery Plugin For Dynamic Spreadsheet-like Data Grid - jExcel

jQuery Plugin For Dynamic Spreadsheet-like Data Grid - jExcel
File Size: 94.6 KB
Views Total:
Last Update:
Publish Date:
Official Website: Go to website
License: MIT
   

jExcel is a powerful jQuery plugin which lets you dynamically generate a spreadsheet like data grid (table) from local JS data or even an external CSV file. Eesy to integrate with any third party plugin data manipulation plugin like input mask, currency formatting, key-value dropdown, color picker and much more. Also comes with an onchange handler which will be fired on every change in your spreadsheet.

Basic usage:

1. Add references to jQuery library and the jQuery jExcel plugin's JS & CSS files into the webpage.

<link href="dist/css/jquery.jexcel.css" rel="stylesheet">
<script src="//code.jquery.com/jquery.min.js"></script>
<script src="dist/js/jquery.jexcel.js"></script>

2. Create an empty DIV element that will be served as the container for your spreadsheet.

<div id="demo1"></div>

3. Define an array of JS data to be presented in the spreadsheet.

data1 = [
  ['Google', 1998, 807.80],
  ['Apple', 1976, 116.52],
  ['Yahoo', 1994, 38.66],
];

4. Initialize the spreadsheet and done.

$('#demo1').jexcel({ 
  data:data1
});

5. If you'd like to load an external CSV file into the spreadsheet:

<script src="/path/to/jquery.csv.min.js"></script>
$('#demo2').jexcel({
  csv:'demo.csv',
  csvHeaders:true
})

6. Download the spreadsheet data as a CSV file:

$('#demo2').jexcel('download');

7. Default plugin settings:

$('#demo2').jexcel({
  colHeaders:[],
  colWidths:[],
  colAlignments:[],
  columns:[],
  minSpareRows:0,
  minSpareCols:0,
});

Change log:

2017-09-11

  • new version 1.3.3 merged.

2017-05-08

  • Arrows control on edition.

2017-05-04

2017-03-22

  • New context menu and native dropdown filtering.

2017-03-14

  •  Undo-redo to include native checkboxes

2017-03-05

  • Update jquery.jexcel.css

2017-02-20

  • update

2017-02-11

  • Formulas, and arrow excel-like navigation improvement.

2017-01-28

  • CSV include first row as headers options. Download CSV including

2017-01-26

  • Sorting and ordering.

2017-01-19

  • Allows for dynamically adding columns.

2017-01-14

  • Implemented undo/redo feature

This awesome jQuery plugin is developed by paulhodel. For more Advanced Usages, please check the demo page or visit the official website.