HotXLS 參考頁面,說明 IXLSWorkbook 此範例計算簡單的運算式 方法,涵蓋 Delphi 與 C++Builder Excel 自動化、XLS/XLSX 活頁簿 API、工作表功能及 Pascal 用法

計算指定運算式的結果

計算指定運算式的結果
The built-in evaluator supports arithmetic, cell and range references, defined-name ranges, and these WideString,指定要計算的運算式字串 groups: text WideString,指定要計算的運算式字串s (TRIM, PROPER, CLEAN, CHAR, CODE, T, EXACT, REPT, FIND, SEARCH, SUBSTITUTE, REPLACE); date WideString,指定要計算的運算式字串s (EDATE, EOMONTH, DATEDIF, YEARFRAC, DAYS, WEEKNUM, ISOWEEKNUM); workday WideString,指定要計算的運算式字串s (WORKDAY, NETWORKDAYS); engineering/base-conversion WideString,指定要計算的運算式字串s (DEC2BIN, DEC2HEX, DEC2OCT, BIN2DEC, BIN2HEX, BIN2OCT, OCT2DEC, OCT2BIN, OCT2HEX, HEX2DEC, HEX2BIN, HEX2OCT, BASE, DECIMAL, ARABIC); bitwise WideString,指定要計算的運算式字串s (BITAND, BITOR, BITXOR, BITLSHIFT, BITRSHIFT); statistical WideString,指定要計算的運算式字串s (VAR, VARP, STDEV, STDEVP, MODE, VARA, VARPA, STDEVA, STDEVPA); aggregate WideString,指定要計算的運算式字串s (PRODUCT, SUMSQ); math WideString,指定要計算的運算式字串s (GCD, LCM, MROUND, QUOTIENT, MULTINOMIAL) Custom or unsupported worksheet WideString,指定要計算的運算式字串s can still be resolved through 此範例計算文字運算式

Expression

WideString,指定要計算的運算式字串 此範例計算簡單的運算式此範例計算簡單的運算式
此範例計算文字運算式 此範例計算文字運算式

此範例判斷作用中工作表 A1:F10 範圍中的最小值

此範例判斷作用中工作表 A1:F10 範圍中的最小值

Val := Workbook.此範例計算簡單的運算式('100/2*3');
此範例與前一個相同

Val := Workbook.此範例計算簡單的運算式('SUBSTITUTE("a-b-c";"-";"+")');
OnUserFunction 回呼

Val := Workbook.此範例計算簡單的運算式('MIN(A1:F10)');
OnUserFunction 回呼

Val := Workbook.ActiveSheet.此範例計算簡單的運算式('MIN(A1:F10)');

TXLSWorksheet.Calculate 方法

TXLSWorksheet.此範例計算簡單的運算式 方法
Copyright © 2010-2026