48

I am looking for a jQuery plugin for something like spreadsheet or grid. I have found a lot of jQuery Grid plugins and one spreadsheet plugin. But I would like functionality with copy/paste cells from/to Excel. Something like here Any suggestions?

Community
  • 1
  • 1
Iurii Dziuban
  • 1,091
  • 2
  • 17
  • 31
  • https://jsgrids.io/ is a list of JavaScript grid libraries. You can filter the results for libraries, such as those that have copy and paste support, or those that export to Excel. – a paid nerd Jul 14 '20 at 00:44

3 Answers3

180

I needed JavaScript data grid with copy/paste compatibility with Excel. I could not find such, so I created this: http://handsontable.com/

Maybe you will find it useful.

warpech
  • 6,293
  • 4
  • 35
  • 36
  • Does it support forumlas? – K-Dawg Aug 23 '15 at 14:37
  • Yes: http://docs.handsontable.com/0.16.1/demo-formula-support.html (there is a demo link) – warpech Aug 24 '15 at 15:47
  • 5
    This simple description ("I created this jQuery plugin") belies the completeness of this solution: a full-blown web-based spreadsheet with formulas, API, documentation and support. Wow. – jdhildeb Oct 19 '15 at 20:56
  • 1
    Thanks :) Btw it does not require jQuery anymore. I will edit my answer – warpech Oct 21 '15 at 08:00
  • 1
    An alternative for handsontable is jExcel. Some examples can be found at: http://www.bossanova.uk/jexcel/tracking-changes-on-the-spreadsheet – Paul H. Feb 17 '17 at 20:21
2

there is one available on github: https://github.com/TanyaWebDesign/SpreadSheet

it is based on jquery, has copy/paste and bunch of other functions.

Yuri Romanenko
  • 159
  • 1
  • 9
2

The best way to deal with tabular data with jquery is probably using Slickgrid

I did a plugin for copy/paste from/to excel: http://labs.nereo.com/SlickGrid/examples/example-excel-compatible-spreadsheet.html

The plugin has now many bugs fixed and features added by the community (eg. undo/redo support) : https://github.com/Celebio/SlickGrid/commits/master

Onur Celebi
  • 333
  • 1
  • 3
  • 15