I cut and paste from Excel into J all the time - what doesn't work for you? See http://www.jsoftware.com/jwiki/NYCJUG/2012-05-08#Beginner.27sregatta for an example of the sort of thing I often do. The example shows c&p from a web page but it works just as well from Excel.
In any case, both Tara and the Excel OLE work fine - here's a sample of code I wrote using the latter: http://www.jsoftware.com/jwiki/DevonMcCormick/IO/OLEExcel#preview . On Wed, Jun 27, 2012 at 2:33 AM, adam dunne <adam...@gmail.com> wrote: > The tutorial J OLE Server for Excel in j602 (User Manual) shows how to > put a variant datatype from J into a range in an Excel worksheet. > Is it possible to transfer cells from an Excel worksheet into J? (Cut > and paste does'nt work; J does'nt like it). > ---------------------------------------------------------------------- > For information about J forums see http://www.jsoftware.com/forums.htm -- Devon McCormick, CFA ^me^ at acm. org is my preferred e-mail ---------------------------------------------------------------------- For information about J forums see http://www.jsoftware.com/forums.htm