Google Sheets Style Feature Rich jQuery Spreadsheet Plugin - ipgrid

Google Sheets Style Feature Rich jQuery Spreadsheet Plugin - ipgrid
File Size: 264 KB
Views Total:
Last Update:
Publish Date:
Official Website: Go to website
License: MIT
   

ipgrid is a flexible, feature-rich, highly customizable jQuery spreadsheet plugin inspired by Google Sheets and MS Excel. Comes with lots of configuration options and API methods & events.

Basic usage:

1. Include the needed jQuery and jQuery UI libraries on the webpage.

<script src="/path/to/jquery.min.js"></script>
<script src="/path/to/jquery-ui.min.js"></script>

2. Include the jQuery ipgrid plugin after jQuery JavaScript library.

<script src="scripts/ip.grid.js"></script>
<link href="css/ip.grid.css" rel="stylesheet">

3. Create a container for the spreadsheet.

<div class="example"></div>

4. Call the function on the container element and specify the number of rows and columns.

$('#example').ip_Grid({

  rows: 1000,
  cols: 30

});

5. Default plugin options.

$('#example').ip_Grid({

  id: $(this).attr('id'),
  publicKey: null,
  rows: 10,
  cols: 10,
  frozenRows: 0,
  frozenCols: 0,
  showRowSelector: true,
  showColSelector: true,
  showGridResizerX: true,
  rowData: new Array(),
  colData: new Array(),
  mergeData: new Array(),
  dataTypes: new Array(),
  ip_Grid: null, //this is the call back which is executed once the grid is created
  defaultColWidth: defaultColWidth,
  defaultRowHeight: defaultRowHeight,
  loading: false,
  refresh: false,            
  scrollX: null,
  scrollY: null,
  hashTags: [],
  sheetName: '',

  //EVENTS
  onLoad: null

});

Change log:

2017-02-16

  • generate unlimited size of cols with their real names like in ms excel

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