Spreadsheets are a pretty useful and powerful tool when it comes to doing ad-hoc data analysis, but it's kind of annoying to get data in and out of them from command line tools.
I'm actually working on this, although for various reasons I had to reimplement the formula parser (corner cases are a pain). Screenshot (in progress): http://i.imgur.com/snyBhYH.png
Comments
Very cool!
Slightly related... I reckon a command line / ncurses version of Excel would be really useful. Am I crazy?
e.g. something like http://upload.wikimedia.org/wikipedia/en/e/ec/Lotus-123-3.0-...
Spreadsheets are a pretty useful and powerful tool when it comes to doing ad-hoc data analysis, but it's kind of annoying to get data in and out of them from command line tools.
I'm actually working on this, although for various reasons I had to reimplement the formula parser (corner cases are a pain). Screenshot (in progress): http://i.imgur.com/snyBhYH.png
Just download VisiCalc: http://www.bricklin.com/history/vcexecutable.htm
I have no idea how easy it is to pipe input into and out of it, but it certainly want designed for it.
Fat-finger errors are already terrifying in spreadsheets. How would you help prevent them in command line tools?
Isn't that true for a lot of tools? Including programming languages?
GNU Oleo has a curses mode.
there is also "sc", "spreadsheet calc"
I would love a maintained {n,}curses mode spreadsheet that can handle excel1040.com.
R?