Scenarios Interface

Definition

Namespace:

Microsoft.Office.Interop.Excel

Assembly:

Microsoft.Office.Interop.Excel.dll

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.IEnumerable

Public Interface Scenarios
Implements IEnumerable

Attributes

GuidAttribute InterfaceTypeAttribute

Implements

IEnumerable

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.