efp

There are lot of people who use excel in their day to day operations. They are well versed with excel formulas. Having support for excel formulas in a software system would be of great value of end users. Some target groups:

Project Managers
Process Planners
BOM Managers
Finance Managers

Pre-requisites

Go version - 1.12 and above

Roadmap

Drop 1:
- ~~Support for all Logical functions~~
- ~~Support for all text functions~~
Drop 2:
- Support for building a range
- Support for Math & Trig with exception of array functions
- Support for Date & Time functions

Excel functions supported

Text Functions

CONCAT
CONCATENATE
EXACT
FIND
FIXED - Todo
LEFT
LEN
LOWER
MID
PROPER
REPLACE
REPT
RIGHT
SEARCH
SUBSTITUTE
TRIM
UPPER

Approach

Use gval to implement Excel formula language

How to install

TODO

Examples

TODO - Draft only

Use-case 1

Initialize the excel formula parse

package main

include (
    praveentiru/efp
)

func main() int {
    parser := efp.CreateParser()
}