FW: [Jprogramming] Passing a J Array to Excel

[Leigh J. Halliwell]

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