HotXLS-dokumentasjon Innhold Hjem Oversikt TGridToXLS IXLSWorkbook Hjem Innhold Oversikt

Calculate metode

Calculates the result of specified expression The worksheet evaluator shares the workbook formula engine and supports the same funksjon groups: text functions (TRIM, PROPER, CLEAN, CHAR, CODE, T, EXACT, REPT, FIND, SEARCH, SUBSTITUTE, REPLACE); date functions (EDATE, EOMONTH, DATEDIF, YEARFRAC, DAYS, WEEKNUM, ISOWEEKNUM); workday functions (WORKDAY, NETWORKDAYS); engineering/base-conversion functions (DEC2BIN, DEC2HEX, DEC2OCT, BIN2DEC, BIN2HEX, BIN2OCT, OCT2DEC, OCT2BIN, OCT2HEX, HEX2DEC, HEX2BIN, HEX2OCT, BASE, DECIMAL, ARABIC); bitwise functions (BITAND, BITOR, BITXOR, BITLSHIFT, BITRSHIFT); statistical functions (VAR, VARP, STDEV, STDEVP, MODE, VARA, VARPA, STDEVA, STDEVPA); aggregate functions (PRODUCT, SUMSQ); math functions (GCD, LCM, MROUND, QUOTIENT, MULTINOMIAL) Custom or unsupported worksheet functions can still be resolved through OnUserFunction / OnUserFunctionEx

Syntaks

function Calculate(Expression: WideString):Variant; Expression WideString. A string that specifies an expression which should be calculated

Eksempel

This example calculates the sum of values in a range A1:A20
Val := Workbook.Sheets[1].Calculate('SUM(A1:A20)'); This example calculates a text expression in worksheet context
Val := Workbook.Sheets[1].Calculate('REPLACE("abcde";2;3;"XY")'); This example determines the smallest value in a range A1:F10 on Worksheet one
Val := Workbook.Sheets[1].Calculate('MIN(A1:F10)');

Calculate metode

Syntaks

Eksempel

Se også