Excel Conversion to Wrap

Tags: Help, XLW

Your wrap will look like the original spreadsheet (however some compromise occurs as HTML tables don't follow exactly the same specification as Excel). We believe we get a pretty good match. It is possible to fully debug inside Excel before conversion to wrap so your wrap will function just as your spreadsheet does.

EXCEL FUNCTIONS - Almost all Excel Functions are converted into JavaScript functions: ABS, ACCRINT, ACOS, ACOSH, AND, ASC, ASIN, ASINH, ATAN, ATAN2, ATANH, AVEDEV, AVERAGE, AVERAGEA, BESSELY, BETADIST, BIN2DEC, BIN2HEX, BIN2OCT, BINOMDIST, CEILING, CHAR, CHIDIST, CHIINV, CHOOSE, CLEAN, CODE, COLUMN, COLUMNS, COMBIN, CONCATENATE, CONFIDENCE, CORREL, COS, COSH, COUNT, COUNTA, COUNTIF, COVAR, CUMIPMT, CUMPRINC, DATE, DATEDIF, DATEVALUE, DAY, DAYS360, DB, DDB, DEC2BIN, DEC2HEX, DEC2OCT, DEGREES, DELTA, DISC, DOLLAR, DOLLARDE, DOLLARFR, EDATE, EFFECT, EOMONTH, ERF, ERFC, EVEN, EXACT, EXP, FACT, FALSE, FDIST, FIND, FINV, FISHER, FISHERINV, FIXED, FLOOR, FORECAST, FTEST, FV, FVSCHEDULE, GAMMALN, HEX2BIN, HEX2DEC, HEX2OCT, HLOOKUP, HOUR, HYPERLINK, HYPGEOMDIST, IF, IFERROR, INDEX, INT, INTERCEPT, INTRATE, IPMT, IRR, ISBLANK, ISERR, ISERROR, ISEVEN, ISLOGICAL, ISNA, ISNONTEXT, ISNUMBER, ISODD, ISPMT, ISREF, ISTEXT, LARGE, LEFT, LEN, LN, LOG, LOG10, LOGINV, LOGNORMDIST, LOOKUP, LOWER, MATCH, MAX, MID, MIN, MINUTE, MIRR, MOD, MONTH, MROUND, N, NA, NEGBINOMDIST, NETWORKDAYS, NOMINAL, NORMDIST, NORMINV, NORMSDIST, NORMSINV, NOT, NOW, NPER, NPV, OCT2BIN, OCT2DEC, OCT2HEX, ODD, OR, PEARSON, PERCENTILE, PERCENTRANK, PERMUT, PI, PMT, POISSON, POWER, PPMT, PRICEDISC, PRODUCT, PROPER, PV, QUARTILE, QUOTIENT, RADIANS, RAND, RANDBETWEEN, RANK, RATE, REPLACE, REPT, RIGHT, ROMAN, ROUND, ROUNDDOWN, ROUNDUP, ROW, ROWS, RSQ, SEARCH, SECOND, SIGN, SIN, SINH, SLN, SLOPE, SMALL, SQRT, STANDARDIZE, STDEV, STDEVA, STDEVP, STDEVPA, SUBSTITUTE, SUBTOTAL, SUM, SUMIF, SUMPRODUCT, SUMSQ, SUMX2MY2, SUMX2PY2, SUMXMY2, SYD, T, TAN, TANH, TEXT, TIME, TIMEVALUE, TODAY, TRIM, TRIMMEAN, TRUE, TRUNC, UPPER, VALUE, VAR, VARA, VARP, VARPA, VLOOKUP, WEEKDAY, WEIBULL, WORKDAY, XIRR, XNPV and YEAR. Custom functions are also supported but will require the assistance of ExcelWraps for custom conversion. 

Excel Conditional Formatting is supported but some specific features of conditional formatting are currently unsupported: Above/Below standard deviation, Color Scale with more than 2 criteria, Inside 2 colors scale, we only support Highest to Lowest type, Duplicate/unique, Top/bottom n percent and any conditional formatting that depends on formulas.

Excel Charts are converted to HTML charts and whilst functionally they are the same there will be slight variation in appearance. Some Excel functionality is not supported (e.g. data labels). Please keep charts as simple as possible.