Dokumentacija HotXLS Vsebina Domov Pregled TGridToXLS IXLSWorkbook Domov Vsebina 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

Skladnja

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

Primer

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

Skladnja

Primer

Glej tudi