Re:Show HN: A simple lazy Python calculation engine, with sp...
by arthurcolle on Thursday July 08, 2021 @02:49PM
(#27776224)
There is a tool called wings iirc that lets you pull out DataFrames from an xlsx and vice versa
Re:Show HN: A simple lazy Python calculation engine, with sp...
by quag on Thursday July 08, 2021 @04:22PM
(#27777128)
It’s called xlwings. Not a bad tool. https://docs.xlwings.org/en/stable/quickstart.html
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.