Note
Access to this page requires authorization. You can try signing in or .
Access to this page requires authorization. You can try .
Scenarios Interface
Definition
- Namespace:
- Microsoft.Office.Interop.Excel
- Assembly:
- Microsoft.Office.Interop.Excel.dll
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. |
Applies to
Feedback
Was this page helpful?