Reference>IXLSWorksheet>Calculate

Calculates the result of specified expression.

Syntax

function Calculate(Expression: WideString):Variant;

Expression

WideString. A string that specifies an expression which should be calculated.

This example calculates the sum of values in a range A1:A20

Val := Workbook.Sheets[1].Calculate('SUM(A1:A20)');

This example determines the smallest value in a range A1:F10 on worksheet one.

Val := Workbook.Sheets[1].Calculate('MIN(A1:F10)');