GrapeCity.Documents.Excel.IScenario.Values

Values Property

Values

Returns a list that contains the current values of the changing cells for the scenario.

Use Show() to apply these scenario values to the worksheet, or ChangingCells to retrieve the cells associated with the returned values.

Declaration

IList<object> Values { get; }

ReadOnly Property Values As IList(Of Object)

Examples

worksheet.Range["B2:B3"].Value = new object[,] {{10}, {20}};
IScenario scenario = worksheet.Scenarios.Add("Sales Plan", worksheet.Range["B2:B3"], null);
IList<object> values = scenario.Values;