Formed in 2009, the Archive Team (not to be confused with the archive.org Archive-It Team) is a rogue archivist collective dedicated to saving copies of rapidly dying or deleted websites for the sake of history and digital heritage. The group is 100% composed of volunteers and interested parties, and has expanded into a large amount of related projects for saving online and digital history.
EFP (Excel Formula Parser)
Using EFP (Excel Formula Parser) you can get an Abstract Syntax Tree (AST) from Excel formula.
Installation
go get github.com/xuri/efpExample
package main
import "github.com/xuri/efp"
func main() {
ps := efp.ExcelParser()
ps.Parse("=SUM(A3+B9*2)/2")
println(ps.PrettyPrint())
}Get AST
SUM <Function> <Start>
A3 <Operand> <Range>
+ <OperatorInfix> <Math>
B9 <Operand> <Range>
* <OperatorInfix> <Math>
2 <Operand> <Number>
<Function> <Stop>
/ <OperatorInfix> <Math>
2 <Operand> <Number>
Contributing
Contributions are welcome! Open a pull request to fix a bug, or open an issue to discuss a new feature or change.
Credits
EFP (Excel Formula Parser) is a Go language port of E. W. Bachtal's Excel formula parser.
Licenses
This program is under the terms of the BSD 3-Clause License. See https://opensource.org/licenses/BSD-3-Clause.
