Live integration between APL ARRAY and EXCEL Sheet

[Morten|Dyalog]

Hi Charles! Could you be falling prey to the same problem that Woodley had - of a non-default value for ⎕WX? The value should be 3. Without this, you need to treat Range as a function rather than an indexable property, and write:

Code: Select all

range←XL.ActiveSheet.Range 'A1:D3'

The ⎕NC-vs-⎕NL behaviour is related to the fact that Dyalog APL wraps all external objects in a "regular" APL namespace. You can inject your own names into this wrapper, and then ⎕NC will report them - but it will only see the "normal" APL names:

Code: Select all

      'XL' ⎕WC 'OLECLient' 'Excel.Application' ⍝ Create a an OLE Client
      XL.XYZ←1234
      XL.⎕NL 2
XYZ
      XL.⎕NC 'XYZ'
2


The negative argument to ⎕NL alters the behaviour in two ways: You get a vector of vectors back, AND it also includes names exposed by the underlying external object (not you ALSO see XYZ in the result):

Code: Select all

      ¯6↑XL.⎕NL -2
 WindowsForPens  Workbooks  WorksheetFunction  Worksheets  XYZ  _Default


If you provide ⎕NC with a nested right argument, you will see the names exposed by the underlying object, and also get a more granular result with sub-classification of the names:

Code: Select all

      XL.⎕NC 'CentimetersToPoints' 'ActiveSheet'
¯3.6 ¯2.6


More about this in the help for ⎕NC and ⎕NL.

[Charles Brenner]

Hi Morton,
Thanks. I thought I'd checked ⎕WX←3 but since I'm now successful with SaveXL I must've thought wrong.

But the Excel object isn't visible to me. I see a slew of names & functions in Workbook but nothing tempting hits my eye. Can you tell me where to look?

Thanks,
Charles

[Morten|Dyalog]

Try (XL.Visible←1) to make Excel show itself?