Table of Contents generated with DocToc
The local file currently supports CSV and Excel
Excel 97-2003 and above (inclusive)
CSV files will automatically recognize the file encoding and do not support manual setting.
| Type | CSV | Excel |
|---|---|---|
| Maximum File Size | 200M | 20M |
Supports direct row and column references (A1, B2, etc.), does not support table references ([Column1], [Column2], [@Column3], etc.)
Supports formulas starting with '=', does not support the '{=…}' format, the list of supported Excel functions is as follows
ABS, ACOS, ACOSH, ADDRESS, AND, ASIN, ASINH, ATAN, ATAN2, ATANH, AVEDEV, AVERAGE, CEILING, CHAR, CHOOSE, CLEAN, CODE, COLUMN, COLUMNS, COMBIN, CONCATENATE, COS, COSH, COUNT, COUNTA, COUNTBLANK, COUNTIF, DATE, DAY, DAYS360, DEGREES, DEVSQ, DGET, DMIN, DOLLAR, ERROR.TYPE, EVEN, EXACT, EXP, FACT, FALSE, FIND, FIXED, FLOOR, FV, HLOOKUP, HOUR, HYPERLINK, IF, INDEX, INDIRECT, INT, INTERCEPT, IPMT, IRR, ISBLANK, ISERR, ISERROR, ISLOGICAL, ISNA, ISNONTEXT, ISNUMBER, ISREF, ISTEXT, LARGE, LEFT, LEN, LN, LOG, LOG10…
Not supported