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.

$('#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

});

Changelog:

2023-12-25

• Fixed rows/cols snap drag feature

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.