GrapeCity.Documents.Excel.IScenario.Index

Index Property

Index

Returns the index of this scenario in the worksheet's scenario collection.

Use this property to get the scenario's position within the worksheet's scenario collection.

Declaration

int Index { get; }

ReadOnly Property Index As Integer

Examples

worksheet.Range["B2:B3"].Value = new object[,] {{10}, {20}};
IScenario scenario = worksheet.Scenarios.Add("Sales Plan", worksheet.Range["B2:B3"], null);
int index = scenario.Index;