[Jprogramming] Passing a J Array to Excel

[Devon McCormick]

Leigh -

I just added the warning I gave you about negative numbers, plus other
potential pitfalls with numbers
from Excel, on the J Wiki at http://www.jsoftware.com/jwiki/Scripts/OLEExcel
 in the section
"Caveats About Ugliness and Other Things".

As you deal with some of these issues and write code for handling it, it
would be helpful for you
to either update this page or start on new page and link to this one.

Thanks,

Devon

On 3/22/07, Howell, Leonard W. (MSFC-VP62) <Leonard.W.Howell at nasa.gov>
wrote:
>
> 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
> ----------------------------------------------------------------------
> For information about J forums see http://www.jsoftware.com/forums.htm
>



-- 
Devon McCormick, CFA
^me^ at acm.
org is my
preferred e-mail