Using full object notation can be useful when referring to an object by index, or providing context for the object.
Here are a few examples. ExcelSheet[1] ExcelSheet["Book1","Sheet1"] ExcelSheet["Book1",1] ExcelRange["Report.xls",1,"A1:D100"] When no context is provided, the active context is assumed. Excel object references are resolved when they are passed to a verb, not before. Until then, they are just Mathematica expressions representing a location in Excel. If you want to see if an object reference is valid, you can do so by using the ExcelCheck function. You can return collections of objects as a list by using the plural of an object name. You can extract the name of a returned object. You can also return the embedded context information for the objects. |
