Thread Subject:

Matlab as COM client: How to ID object members

I am using the following toy code to figure out how to access my Excel
data:

   wbkNmRatings = 'Book1';
   xlApp=actxGetRunningServer('Excel.Application');
   wbks=xlApp.Workbooks;
   wbk = wbks.Item(wbkNmRatings);
   sht=wbk.Sheets.Item('mySheet');
   rg=sht.Range('$B$2:$C$3');

   rg.Value
   rg.Formula

   methodsview(rg)
   inspect(rg)

One inconsistency between the objects here versus those accessed from
the Excel immediate window is that you can take the Value and Formula
of properties of an entire range, whereas you can only do that for
individual cells in Excel. I tried to look at the methods &
properties of the range handle "rg" to see what else could be done, as
well as what whether there was a way to access specific cells or
subranges in "rg". However, "inspect" and "methodsview" does not
reveal either a Value or Formula property or method. Why would they
not be listed, and where would I find more complete documentation?