Class GoalSeek

Namespace

Spire.Xls

Assembly

Spire.XLS.dll

Goal seek.

public class GoalSeek

Inheritance

object

GoalSeek

Inherited Members

object.GetType()

object.MemberwiseClone()

object.ToString()

object.Equals(object)

object.Equals(object, object)

object.ReferenceEquals(object, object)

object.GetHashCode()

Constructors

GoalSeek()

public GoalSeek()

Properties

MaxIterations

Gets or sets max iterations.

public int MaxIterations { get; set; }

Property Value

int

Methods

TryCalculate(CellRange, double, CellRange)

Try goal seek calculate.

public GoalSeekResult TryCalculate(CellRange targetCell, double targetValue, CellRange variableCell)

Parameters

targetCell CellRange

targetValue double

variableCell CellRange

Returns

GoalSeekResult

TryCalculate(CellRange, double, CellRange, double)

Try goal seek calculate.

public GoalSeekResult TryCalculate(CellRange targetCell, double targetValue, CellRange variableCell, double guess)

Parameters

targetCell CellRange

targetValue double

variableCell CellRange

guess double

Returns

GoalSeekResult