[Jprogramming] Write array to Excel via OLE Automation without using Paste?

[Alex Rufon]

Hi Ed,

You can use the clipfmt verb to convert your data and use Bill's suggestion. Its part of the formatting scripts. To use:
   load 'format'
   [temp=. ;: 'aa bb cc'
+--+--+--+
|aa|bb|cc|
+--+--+--+
   clipfmt temp
aa	bb	cc

r/Alex

-----Original Message-----
From: programming-bounces at jsoftware.com [mailto:programming-bounces at jsoftware.com] On Behalf Of bill lam
Sent: Wednesday, September 29, 2010 9:39 AM
To: programming at jsoftware.com
Subject: Re: [Jprogramming] Write array to Excel via OLE Automation without using Paste?

Срд, 29 Сен 2010, bill lam писал(а):
> x is the data to be set in clipboard format
>      fields separated by TAB and rows separated by CRLF

or may be rows separated by LF, please check by yourself.

-- 
regards,
====================================================
GPG key 1024D/4434BAB3 2008-08-24
gpg --keyserver subkeys.pgp.net --recv-keys 4434BAB3
----------------------------------------------------------------------
For information about J forums see http://www.jsoftware.com/forums.htm