A lightweight jQuery plugin which adds Spreadsheet functionality on HTML table built using HTML, JS and JQuery.
It supports external copy paste.
- Create a HTML table with class
tableX
- Include
tableX.js
plugin in your HTML - Call plugin on the table using
$('.tableX').tableX()
- To exclude n rows and n columns from left, right, top and bottom (0 is the start) -
$('.tableX').tableX(index_from_left: n, index_from_top: n, index_from_bottom: n, index_from_right: n)
- To exclude n rows and n columns from left, right, top and bottom (0 is the start) -
click
on the cell to make it activeup
down
left
right
arrows for cell navigationclick + hold + drag
mouse over cells to multiselectctrl + c
to copy selected cell datactrl + v
to paste data (supports external sources)
Download the repo and run the demo.html