minicel

README

Minicel

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.

Quick Start

$ go build
$ ./minicel csv/sum.csv

Syntax

Types of Cells

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, :^

Idea

Inspired by minicel