Dokumentacija HotXLS Sadržaj Početna Pregled TGridToXLS IXLSWorkbook Početna Sadržaj Pregled

Calculate metoda

Calculates the result of specified expression The worksheet evaluator shares the workbook formula engine and supports the same funkcija 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

Sintaksa

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

Primjer

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 metoda

Sintaksa

Primjer

Vidi također