基本函数

SpreadJS 在报表插件中新增的自有函数

函数名	描述
SJS.UUID	UUID 通常生成一个 36 位标识符，带有 4 位串联“-”，并且该数字可以设置为 32 以删除串联
SJS.ENDWITH	返回文本是否以给定字符串结尾
SJS.STARTWITH	返回文本是否以给定字符串开始

支持的函数

FUNCTION NAME
SUM	EOMONTH	ISBLANK	NORMINV
COUNT	ISOWEEKNUM	ISERR	PEARSON
AVERAGE	NETWORKDAYS	ISERROR	PERCENTILE.EXC
CHAR	NETWORKDAYS.INTL	ISEVEN	PERCENTILE.INC
DATE	TIMEVALUE	ISFORMULA	PERCENTRANK.EXC
MAX	WEEKNUM	ISLOGICAL	PERCENTRANK.INC
MIN	WORKDAY	ISNA	PERMUT
TIME	WORKDAY.INTL	ISNONTEXT	PERMUTATIONA
ABS	YEARFRAC	ISNUMBER	PHI
CEILING	BESSELI	ISODD	POISSON.DIST
COMBIN	BESSELJ	ISTEXT	PROB
EVEN	BESSELK	N	QUARTILE.EXC
EXP	BESSELY	NA	QUARTILE.INC
FACT	BIN2DEC	SHEET	RANK.AVG
FLOOR	BIN2HEX	SHEETS	RANK.EQ
INT	BIN2OCT	FALSE	RSQ
LN	BITAND	IFERROR	SKEW
LOG	BITLSHIFT	IFNA	SKEW.P
LOG10	BITOR	IFS	SLOPE
MOD	BITRSHIFT	NOT	SMALL
PI	BITXOR	TRUE	STANDARDIZE
POWER	COMPLEX	XOR	STDEV.P
PRODUCT	CONVERT	ADDRESS	STDEV.S
RAND	DEC2BIN	COLUMN	STDEVA
RANDBETWEEN	DEC2HEX	COLUMNS	STDEVPA
ROUND	DEC2OCT	FORMULATEXT	STEYX
ROUNDDOWN	DELTA	HYPERLINK	T.DIST
ROUNDUP	ERF	ROWS	T.DIST.2T
SIGN	ERF.PRECISE	ACOT	T.DIST.RT
ODD	ERFC	ACOTH	T.INV
SQRT	ERFC.PRECISE	ARABIC	T.INV.2T
SUMSQ	GESTEP	BASE	T.TEST
TRUNC	HEX2BIN	CEILING.MATH	TRIMMEAN
SIN	HEX2DEC	CEILING.PRECISE	VAR.P
COS	HEX2OCT	COMBINA	VAR.S
TAN	IMABS	COT	VARA
SINH	IMAGINARY	COTH	VARPA
COSH	IMARGUMENT	CSC	WEIBULL.DIST
TANH	IMCONJUGATE	CSCH	Z.TEST
ASIN	IMCOS	DECIMAL	ASC
ACOS	IMCOSH	FACTDOUBLE	BAHTTEXT
ATAN	IMCOT	FLOOR.MATH	CLEAN
ATAN2	IMCSC	FLOOR.PRECISE	CONCAT
ASINH	IMCSCH	GCD	DBCS
ACOSH	IMDIV	ISO.CEILING	DOLLAR
ATANH	IMEXP	LCM	FINDB
DEGREES	IMLN	MROUND	FIXED
RADIANS	IMLOG10	MULTINOMIAL	JIS
CODE	IMLOG2	QUOTIENT	LEFTB
CONCATENATE	IMPOWER	ROMAN	LENB
EXACT	IMPRODUCT	SEC	MIDB
FIND	IMREAL	SECH	REPLACEB
LEFT	IMSEC	SERIESSUM	REPT
LEN	IMSECH	SQRTPI	RIGHTB
LOWER	IMSIN	SUMIF	SEARCH
MID	IMSINH	SUMIFS	SEARCHB
PROPER	IMSQRT	SUMPRODUCT	T
REPLACE	IMSUB	SUMX2MY2	TEXT
RIGHT	IMSUM	SUMX2PY2	TEXTJOIN
SUBSTITUTE	IMTAN	SUMXMY2	UNICHAR
TRIM	OCT2BIN	AVEDEV	UNICODE
UPPER	OCT2DEC	AVERAGEA	ENCODEURL
DATEDIF	OCT2HEX	AVERAGEIF	WEBSERVICE
DAY	ACCRINT	AVERAGEIFS	EURO
DAYS360	ACCRINTM	BETA.DIST	EUROCONVERT
HOUR	AMORDEGRC	BETA.INV	ISOMITTED
MINUTE	AMORLINC	BINOM.DIST	LAMBDA
MONTH	COUPDAYBS	BINOM.DIST.RANGE	OBJECT
NOW	COUPDAYS	BINOM.INV	PROPERTY
SECOND	COUPDAYSNC	CHISQ.DIST	REFRESH
TODAY	COUPNCD	CHISQ.DIST.RT	REDUCE
WEEKDAY	COUPNUM	CHISQ.INV	SCAN
YEAR	COUPPCD	CHISQ.INV.RT	CHITEST
AND	CUMIPMT	CHISQ.TEST	MEDIAN
IF	CUMPRINC	CONFIDENCE.NORM	RANGEBLOCKSPARKLINE
OR	DB	CONFIDENCE.T	RANK
SWITCH	DDB	COUNTA	HBARSPARKLINE
ROW	DISC	COUNTBLANK	VBARSPARKLINE
VALUE	DOLLARDE	COUNTIF	VARISPARKLINE
CORREL	DOLLARFR	COUNTIFS	PIESPARKLINE
BETADIST	DURATION	COVARIANCE.P	AREASPARKLINE
BETAINV	EFFECT	COVARIANCE.S	SCATTERSPARKLINE
BINOMDIST	FV	DEVSQ	LINESPARKLINE
CHIDIST	FVSCHEDULE	EXPON.DIST	COLUMNSPARKLINE
CONFIDENCE	INTRATE	F.DIST	WINLOSSSPARKLINE
COVAR	IPMT	F.DIST.RT	BULLETSPARKLINE
CRITBINOM	IRR	F.INV	SPREADSPARKLINE
EXPONDIST	ISPMT	F.INV.RT	STACKEDSPARKLINE
FDIST	MDURATION	F.TEST	BOXPLOTSPARKLINE
FTEST	MIRR	FINV	CASCADESPARKLINE
GAMMADIST	NOMINAL	FISHER	PARETOSPARKLINE
GAMMAINV	NPER	FISHERINV	MONTHSPARKLINE
HYPGEOMDIST	NPV	FORECAST	YEARSPARKLINE
MODE	ODDFPRICE	GAMMA	GAUGEKPISPARKLINE
NEGBINOMDIST	ODDFYIELD	GAMMA.DIST	HISTOGRAMSPARKLINE
NORM.INV	ODDLPRICE	GAMMA.INV	STDEV
NORMDIST	ODDLYIELD	GAMMALN	BC_QRCODE
NORMSDIST	PDURATION	GAMMALN.PRECISE	BC_EAN13
NORMSINV	PMT	GAUSS	BC_EAN8
PERCENTILE	PPMT	GEOMEAN	BC_CODABAR
PERCENTRANK	PRICE	GROWTH	BC_CODE39
POISSON	PRICEDISC	HARMEAN	BC_CODE93
QUARTILE	PRICEMAT	HYPGEOM.DIST	BC_CODE128
STDEVP	PV	INTERCEPT	BC_GS1_128
TDIST	RATE	KURT	BC_CODE49
TINV	RECEIVED	LARGE	BC_PDF417
TTEST	RRI	LOGNORM.DIST	BC_DATAMATRIX
VAR	SLN	LOGNORM.INV	LET
VARP	SYD	MAXA	IMAGE
WEIBULL	TBILLEQ	MAXIFS	TEXTBEFORE
ZTEST	TBILLPRICE	MINA	TEXTAFTER
CHIINV	TBILLYIELD	MINIFS	TEXTSPLIT
CHIDIST	VDB	MODE.MULT	GC.REGEXEXTRACT
LOGINV	XIRR	MODE.SNGL	GC.REGEXMATCH
LOGNORMDIST	XNPV	NEGBINOM.DIST	GC.REGEXREPLACE
DATEPART	YIELD	NORM.DIST	SJS.UUID
DATEVALUE	YIELDDISC	NORM.S.DIST	SJS.ENDWITH
DAYS	YIELDMAT	NORM.S.INV	SJS.STARTWITH
EDATE	ERROR.TYPE	SJS.REGEXEXTRACT	SJS.REGEXMATCH
SJS.REGEXREPLACE

不支持的函数

FUNCTION NAME
MAP	MDETERM	DMIN
INDEX	MINVERSE	DPRODUCT
SORT	MMULT	DSTDEV
ISREF	MUNIT	DSUM
TYPE	RANDARRAY	DVAR
AREAS	SEQUENCE	DVARP
CHOOSE	SUBTOTAL	DSTDEVP
FILTER	FREQUENCY	QUERY
HLOOKUP	LINEST	GETPIVOTDATA
INDIRECT	LOGEST	VSTACK
LOOKUP	TREND	HSTACK
MATCH	FILTERJSON	TOROW
OFFSET	BYCOL	TOCOL
SINGLE	BYROW	WRAPROWS
SORTBY	MAKEARRAY	WRAPCOLS
TRANSPOSE	DAVERAGE	TAKE
UNIQUE	DCOUNT	DROP
VLOOKUP	DCOUNTA	EXPAND
XLOOKUP	DGET	CHOOSEROWS
XMATCH	DMAX	CHOOSECOLS
AGGREGATE