1

I would like to setup Extjs GridPanel to allow pasting from clipboard. Ideally, I would like to be able to paste a matrix copied from Excel directly onto the GridPanel - does anyone know of an existing method of doing this? or any thoughts on where to start implementing it?

Assaf
  • 1,336
  • 1
  • 10
  • 17

3 Answers3

2

I would start with listening to the onpaste event on the GridPanel. You'll probably have to do some work with getting it to bubble up correctly to your handler.

Hopefully you'll then have a mess of text from Excel to deal with.

wombleton
  • 8,336
  • 1
  • 28
  • 30
2

There are two extensions for copy/paste actions on Grid Panels :

Excel Editor Grid

and another useful one

Deniz
  • 793
  • 11
  • 20
1

You could use a similar method to this other question on HTML tables if you're using IE only. Otherwise, I don't think you can get access to the clipboard in all browsers.

You may want to consider exporting from Excel as a CSV file and importing it into your application.

Community
  • 1
  • 1
JamesHalsall
  • 13,224
  • 4
  • 41
  • 66