As far as I can see, wd will be decommitted in J7 therefore all previous ole excel addons and xlutil will no longer work. That is why tables/wdooo was added to the J7 addons repository.
Вск, 03 Окт 2010, David Mitchell писал(а): > > > On 9/28/2010 16:35, Cox, Ed wrote: > [---=| Quote block shrunk by t-prot: 26 lines snipped |=---] > > > > > > _________________________________________________ > > > > This message is for the designated recipient only and may contain > > privileged, proprietary > > or otherwise private information. If you have received it in error, please > > notify the sender > > immediately and delete the original. Any other use of the email by you is > > prohibited. > > > > Dansk - Deutsch - Espanol - Francais - Italiano - Japanese - Nederlands - > > Norsk - Portuguese > > Svenska: www.carefusion.com/legal/email > > As far as I can tell, the J wd/ole interface has limited support for > constructing the variant data type needed to set the individual cell Values > of > an Excel Range. The OLE argument that gets sent from J to Excel always seems > to > look like a single element to Excel. > > There does not seem to be any provision for transforming a J array into the > type > of variant/safearray argument that some non-J code uses for setting multiple > distinct Values in an Excel Range. > > The closest I could get to passing an array from J to Excel in pure J was to > use > this type of approach: > > xlopen '' > xlcmd 'wb add' > xlget 'temp worksheets' > xlid 'ws' > xlget 'ws item sheet1' > xlid 'sh1' > booga1=:'Test 1 2 3' > booga2=:'4 3 2 fee' > xlget 'sh1 cells ',": 1,2 > xlset 'temp value "',booga1,'"' > xlget 'sh1 cells ',": 2,2 > xlset 'temp value "',booga2,'"' > xlget 'sh1 range b1:b2' > xlcmd 'temp texttocolumns , 1 1 0 0 0 0 1' > > This sends the data from J to Excel as individual rows and then expands the > columns using texttocolumns with a space delimiter. > > Other possible approaches might be to use the pcall interface or to create > your > own DLL to perform the J to OLE conversions you need. > > -- > Cheers, > David Mitchell -- 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
