[Jprogramming] retreiving Excel cells into J

[Devon McCormick]

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 <adamdun at 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