3 ms·
This is pretty cool. Spreadsheets are so powerful and really great and producing one-off solutions, but when you want to automate them you always need to redo
by dev_snd 5y ago
This is pretty cool.
Spreadsheets are so powerful and really great and producing one-off solutions, but when you want to automate them you always need to redo most of the work in a "serious" programming language and wrap all of it in an API etc.
I always wondered how one could bridge the gap between creating a PoC computation in a spreadsheet and getting the same code to run in production without the rewrite. This could be a nice first step for a python server application designed in a spreadsheet.
- arthurcolle 5y agoThere is a tool called wings iirc that lets you pull out DataFrames from an xlsx and vice versa
- quag 5y agoIt’s called xlwings. Not a bad tool. https://docs.xlwings.org/en/stable/quickstart.html https://docs.xlwings.org/en/stable/quickstart.html