The idea is to implement a batch program that can accept a CSV file that looks like this:
A | B
1 | 2
3 | 4
=A1+B1 | =A2+B2
And outputs:
A | B
1 | 2
3 | 4
3 | 7
Basically a simple Excel engine without any UI.
$ go build
$ ./minicel csv/sum.csv| Type | Description | Examples |
|---|---|---|
| Text | Just a human readable text. | A, Test, Total Amount, etc |
| Number | Anything that can be parsed as a float by strconv.ParseFloat | 1, 2.0, 1e-6, etc |
| Expression | Always starts with =. Excel style math expression that involves numbers and other cells. |
=A1+B1, =69+420, =A1+69 etc |
| Clone | Always starts with :. Clones a neighbor cell in a particular direction denoted by characters <, >, v, ^. |
:<, :>, :v, :^ |
Inspired by minicel