Google Sheets Style Feature Rich jQuery Spreadsheet Plugin - ipgrid

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

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.


  rows: 1000,
  cols: 30


5. Default plugin options.


  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: '',

  onLoad: null


Change log:


  • 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.