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#)