Edytuj

Udostępnij za pośrednictwem


Scenarios Interface

Definition

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