I tried using msexcel.ijs in wdooo and it got this error:
test''
file:///c:/users/me/j64-701/addons/tables/wdooo/test1.xls
error occurred
9
|length error: test
| 'me base temp' =:olecreate__p'Excel.Application'
S_OK
1
It appears that olecreate returns a 2 element result:
rz=. base, temp
--
David Mitchell
On 10/3/2010 22:09, bill lam 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
>
----------------------------------------------------------------------
For information about J forums see http://www.jsoftware.com/forums.htm
