WorksheetBase.Evaluate Method (Object)


Converts a Microsoft Office Excel name to an object or a value.

Namespace:   Microsoft.Office.Tools.Excel
Assembly:  Microsoft.Office.Tools.Excel.v4.0.Utilities (in Microsoft.Office.Tools.Excel.v4.0.Utilities.dll)

public object Evaluate(
	object name


Type: System.Object

The name of the object, using the naming convention of Excel.

Return Value

Type: System.Object

The following types of names in Excel can be used with this method:

  • Defined names. You can specify any name.

  • External references. You can use the ! operator to refer to a worksheet defined in another workbook.

The following code example uses the Evaluate method to evaluate the value of cell A1 as an input into the Excel SIN function.

This example is for a document-level customization.

private void EvaluateSIN()
    this.Range["A1"].Value2 = 90;
Return to top