Just for fun I replaced the J6 dll with the J7 dll in the J6 library. The J6 exe worked just fine including wd.
On Sun, Oct 3, 2010 at 9:09 PM, bill lam <[email protected]> wrote: > 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 ---------------------------------------------------------------------- For information about J forums see http://www.jsoftware.com/forums.htm
