A little tool I glued together after getting frustrated with excel. Allows writing excel formulas with if-elseif-else blocks and operators that for some reason where not included in excel's grammar (like && or ||). As output it spits out standard excel formulas (hence 'transpiler'). As a bonus the tool translates function names to the target language and allows setting decimal point and list separator characters (which is always a gaint pain in the ass if your native language is not English).
Oh, and the editor uses the awesome ACE editor with a custom syntax highlighter to make life easier.
ifexpressionthenexpressionifexpressionthenexpressionelseexpressionifexpressionthenexpressionelseifexpressionthen[...]
If-blocks can be enclosed in braces like any other expressions
- normal numbers:
1234.12 - scientific numbers:
12e12 - hexadecimal numbers:
0x1234 - binary numbers:
0b10101 - strings:
"yo!"(supported escape sequences\\,\",\n,\r,\t,\xhhand\uhhhh) - boolean values:
trueandfalse
Decimal point has to be a dot, but output decimal point can be set to any character
- normal:
c1,c$1,$c$1 - range:
c1:c2 - external:
[foo]bar!c4
- English names
trim(c1) - Chosen language names
usuń.zbędne.odstępy(c1)
Arguments have to be separated with a comma, but the output list separator can be set to any character. English names get translated when necessary.
Standard line commnents // and block comments /* */ are supported.
- logical or:
|| - logical and:
&& - equal:
== - not equal:
!= - shift left:
<< - shift right:
>> - modulo:
% - negation:
!
Bitwise or, and, and xor where not added as the standard symbols where already taken.
- standard arithmetic:
+,-,/,* - exponential:
^ - string concatenation:
& - standard inequalities:
<,<=,>=,> - unary minus:
-
npm installnpm run build