excel formula parser
https://github.com/yiminghe/kison
usage
const formula = require('@yiminghe/excel-formula-parser');
console.log(formula.parse('sum(a1,a2)'));
// or
console.log(formula.parse('sum(a1;a2)',{
lexerOptions: { env:'de' }
}));
feature
- function:
sum(a1:a2,b1)
- intersection:
sum(a1:a2 b1)
- union:
sum((a1:a2,b1))
- 3d reference:
sum(shee1:sheet2!a1:a2)
- structure reference:
sum(t[[#total],[y]],t[x])
- array formula and spilled reference:
@sum(@a1:a2 a3#)