bill lam wrote:
> I guess this is idispatch popularised by visual basic. Similar could
> be done in J without using the dot syntax, such as,
> get__cities ('Sheets' ; 'DK') ; ('Range' ; 'B1' ) ; 'Value2'
Sure, but the full dot syntax gives you much more - the segments in the name
are expressions which are executable within the context of the name dotted to
"so far". For a single element extraction (as above) there is little difference
(except that get_cities looks like something which is Excel specific), but I
can reverse ALL the data in all the sheets (IN EXCEL) by typing:
XL.(⌷Workbooks).(⌷Sheets).Usedrange.(Value2←⌽Value2)
And the above is not limited to Excel, it works with ANY object model exposed
via COM or .Net.
----------------------------------------------------------------------
For information about J forums see http://www.jsoftware.com/forums.htm