History

Marvin Preuss dc00175f01 first commit		2023-03-29 13:26:21 +00:00
..
CODE_OF_CONDUCT.md	first commit	2023-03-29 13:26:21 +00:00
efp.go	first commit	2023-03-29 13:26:21 +00:00
LICENSE	first commit	2023-03-29 13:26:21 +00:00
PULL_REQUEST_TEMPLATE.md	first commit	2023-03-29 13:26:21 +00:00
README.md	first commit	2023-03-29 13:26:21 +00:00
SECURITY.md	first commit	2023-03-29 13:26:21 +00:00

README.md

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/efp

Example

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 Golang 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.