LoadXL¨ in 14-beta

APL-related discussions - a stream of APL consciousness.
Not sure where to start a discussion ? Here's the place to be
Forum rules
This forum is for discussing APL-related issues. If you think that the subject is off-topic, then the Chat forum is probably a better place for your thoughts !

LoadXL¨ in 14-beta

Postby StephenTaylor on Tue Apr 29, 2014 3:08 pm

Function LoadXL from ws loaddata seems to get into a strange state under each.

      Dyalog APL/W Version 14.0.20815
Serial No : 501502
Unicode Edition
Beta release
Tue Apr 29 15:57:24 2014
clear ws
)copy loaddata LoadXL
C:\Program Files\Dyalog\Dyalog APL 14.0 Unicode\ws\loaddata saved Mon Mar 31 17:18:14 2014
↑q←'C:\sv9\dictionaries\'∘,¨'Actives' 'Enhanced Deferreds' 'Enhanced Pensioners',¨⊂' Migration.xls'
C:\sv9\dictionaries\Actives Migration.xls
C:\sv9\dictionaries\Enhanced Deferreds Migration.xls
C:\sv9\dictionaries\Enhanced Pensioners Migration.xls
⍴r←LoadXL (1⊃q) 'Migration' ⍬
1020 16
⍴r←LoadXL (2⊃q) 'Migration' ⍬
396 16
⍴r←LoadXL (3⊃q) 'Migration' ⍬
147 16
⍴r←LoadXL¨{⍵'Migration'⍬}¨q
VALUE ERROR
LoadXL[24] :If 0≠XL.Workbooks.Count ⍝ Currently open books

book
C:\sv9\dictionaries\Enhanced Deferreds Migration.xls
XL
#.[OLEClient]
XL.Workbooks
VALUE ERROR
XL.Workbooks

XL.MethodList

XL.PropList
Type ClassName Event Data Handle ClassID KeepOnClose TypeList HelpFile LastError Locale AutoBrowse QueueEven
ts InstanceMode LateBind MethodList ChildList EventList PropList
XL.Type
OLEClient


Observed in 14-beta, but I don't have here an earlier version with which to compare.
User avatar
StephenTaylor
 
Posts: 31
Joined: Thu May 28, 2009 8:20 am

Re: LoadXL¨ in 14-beta

Postby StephenTaylor on Tue Apr 29, 2014 3:23 pm

Okay, just needs a delay in the loop to allow the OLEClient to subside gracefully.
User avatar
StephenTaylor
 
Posts: 31
Joined: Thu May 28, 2009 8:20 am


Return to APL Chat

Who is online

Users browsing this forum: No registered users and 1 guest