\nActiveSheet<\/a>: The currently active sheet,
\nActiveWorkbook<\/a>: The currently active workbook.<\/p>\n
An an example, you can use the following code to access a named range on the active sheet:<\/p>\n
print ActiveSheet.Range(\"Test\").Value2<\/pre>\nPlease also see the VBA documentation for these (using the links above). More IronPython-specific details are available on using Using IronPython with Excel<\/a>, but note that we have already set up the application, active sheet and activer workbook objects ready to use (and some of this seems out of date now).<\/p>\n
Advanced Note: Code written for IronPython using “Application<\/a>“, “ActiveSheet<\/a>” and “ActiveWorkbook<\/a>” will often work under both IronPython and CPython. However, in some cases, IronPython requires a trailing (). We have used .Value2 above because this works identically under both IronPython and CPython. However, if we use .Value, then it must be ActiveSheet.Range(“Test”).Value in CPython and ActiveSheet.Range(“Test”).Value() (with brackets) in IronPython. This is because .Value can take an argument. Thus .Value(10) works, and .Value[10] also works, where 10 is “xlRangeValueDefault<\/span><\/a>” and the [] notation is IronPython’s way of distinguishing between multiple versions of a call.<\/p>\n
As an example, the following code example shows how to directly access a range on a sheet as a .Net array of Variants. (This can be faster than using the more typical SolverStudio approach of a double-indexed dictionary of values. Note that the blank cells come through as “None” in the direct access. As the code shows, SolverStudio creates a list of tuples for this Data Item, but this excludes any blank cells.<\/p>\n
![\"DirectSheetAccessExample\"](\"http:\/\/solverstudio.org\/wp-content\/uploads\/2015\/03\/DirectSheetAccessExample.png\")
<\/a><\/p>\n