[Jprogramming] Passing a J Array to Excel

[Howell, Leonard W. (MSFC-VP62)]

Leigh,

I just started following this thread but would also like to paste data
from J into Excel. I've been using edit variable and the Paste in excel.
Seems to work ok but I would like to try your method. Can you provide an
example with each step required?

Thanks, Leonard

-----Original Message-----
From: programming-bounces at jsoftware.com
[mailto:programming-bounces at jsoftware.com] On Behalf Of Leigh J.
Halliwell
Sent: Thursday, March 22, 2007 12:30 PM
To: 'Programming forum'
Subject: FW: [Jprogramming] Passing a J Array to Excel

Dear J Forum:
 
Thank you, Bill and Devon, for your help.  You've both confirmed to me
that
the clipboard is the way to go.  I found negative numbers to be
converted
with hyphens in the 8!: functions.  The following tacit function does
everything that I need:
 
PasteToExcel =: 13 : 'wdclipwrite ;(<@(,&CRLF)@}:@;)"1 (,&TAB) each 8!:0
y'
 
Sincerely,
 
Leigh
----------------------------------------------------------------------
For information about J forums see http://www.jsoftware.com/forums.htm