PDA

View Full Version : Paste values from Excel paste buffer into Extjs Grid?



jimm
14 Feb 2010, 12:32 PM
Hi there. New member. First post. Be gentle :) Am Using Extjs Grid successfully. Users now want to be able to paste a block of cells containing numbers from Excel into the grid.

1) highlight block of numbers in Excel
2) copy to paste buffer via Ctrl-C
3) go to grid on web page and highlight the upper left-hand corner of the paste block
4) Ctrl-V....voila.

Any examples out there? Thanks.

jimm
14 Feb 2010, 2:45 PM
I just found

http://www.extjs.com/forum/showthread.php?t=79511

I'll check this out. Sorry for taking up bandwidth.

VinylFox
14 Feb 2010, 6:56 PM
That plugin currently does not handle ctrl-V actions, but if you do add that feature please let me know, I would love to include it with the plugin.

jimm
19 Feb 2010, 4:09 AM
Hi there Vinyl,

If not Ctrl-V, what action causes it to paste? Is it drag-n-drop? I still have not had a chance to dig into your code yet....sorry.

VinylFox
19 Feb 2010, 4:46 AM
Yep, drag n drop. There is a video of it in action on my site.

http://www.vinylfox.com/datadrop-drag-grid-data-from-spreadsheet/

crp_spaeth
19 Feb 2010, 8:09 AM
You may want to take a look at my thread...
(Its implemented for Extjs 2.0)

https://www.extjs.com/forum/showthread.php?t=64477

Surinder singh
11 Mar 2011, 3:40 PM
hi,

here is another example
http://www.developerextensions.com/index.php?option=com_extensiondemo&view=extensiondemo&layout=ext&extension=Ext-CopyPasteGrid_1.4&Itemid=480

Thanks