GrapeCity.Documents.Excel.IWorksheet.Scenarios

Scenarios Property

Scenarios

Gets the IScenarios object that represents the collection of What-If analysis scenarios in the worksheet.

Use the returned collection to add, retrieve, and iterate worksheet scenarios.

Declaration

IScenarios Scenarios { get; }

ReadOnly Property Scenarios As IScenarios

Examples

worksheet.Range["C4"].Value = 0.8;
IScenarios scenarios = worksheet.Scenarios;
scenarios.Add("80% highest", worksheet.Range["C4"]);
IScenario scenario = scenarios["80% highest"];