Scenarios Interface
Definition
Important
Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.
A collection of all the Scenario objects on the specified worksheet. A scenario is a group of input values (called changing cells) that’s named and saved.
public interface class Scenarios : System::Collections::IEnumerable[System.Runtime.InteropServices.Guid("00020896-0000-0000-C000-000000000046")]
[System.Runtime.InteropServices.InterfaceType(2)]
public interface Scenarios : System.Collections.IEnumerablePublic Interface Scenarios
Implements IEnumerable- Attributes
- Implements
Remarks
Use the Scenarios(Object) method to return the Scenarios collection.
Use the Add(String, Object, Object, Object, Object, Object) method to create a new scenario and add it to the collection.
Use Scenarios(index), where index is the scenario name or index number, to return a single Scenario object.
Properties
| Application |
Returns an Application object that represents the Microsoft Excel application. |
| Count |
Returns the number of objects in the collection. |
| Creator |
Returns a 32-bit integer that indicates the application in which this object was created. |
| Parent |
Returns the parent object for the specified object. |
Methods
| Add(String, Object, Object, Object, Object, Object) |
Creates a new scenario and adds it to the list of scenarios that are available for the current worksheet. |
| CreateSummary(XlSummaryReportType, Object) |
Creates a new worksheet that contains a summary report for the scenarios on the specified worksheet. |
| GetEnumerator() | |
| Item(Object) |
Returns a single object from a collection. |
| Merge(Object) |
Merges the scenarios from another sheet into the Scenarios collection. |