Scenarios Interface

Reference

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

Applies to

Sdílet prostřednictvím