WorksheetBase.Evaluate(Object) Method

Reference

Definition

Namespace:: Microsoft.Office.Tools.Excel

Assembly:: Microsoft.Office.Tools.Excel.v4.0.Utilities.dll

Important

Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.

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

public:
 System::Object ^ Evaluate(System::Object ^ name);

public object Evaluate (object name);

member this.Evaluate : obj -> obj

Public Function Evaluate (name As Object) As Object

Parameters

name: Object

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

Returns

Object

Examples

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;
    MessageBox.Show(this.Evaluate("SIN(A1)").ToString());
}

Private Sub EvaluateSIN()
    Me.Range("A1").Value2 = 90
    MsgBox(Me.Evaluate("SIN(A1)").ToString())
End Sub

Remarks

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.

Applies to