5 ms·
I feel the real problem with excel is that it’s not reusable. Otherwise it’s a decent tool, but the fact that you write your code in a cell that is so tied to
by daft_pink 1y ago
I feel the real problem with excel is that it’s not reusable.
Otherwise it’s a decent tool, but the fact that you write your code in a cell that is so tied to other cells with non-useful names that it’s impractical to reuse is a reason why it sucks.
Whereas many of these visual worksflow tools at least can export to json and be manipulated programatically in a useful way.
- skydhash 1y agoExcel is high level assembly. Immediately executable, worthless on other platforms without reverse engineering.
- daft_pink 1y agoI don't mean reusing excel formulas on other platforms. I mean if you write a really long formula in a cell, it's not really practical to use that formula in another workbook that doesn't have the exact same structure. If you compare that to say a Jupyter notebook which is cell based, you can at least reuse your function in another notebook or cell within any other jupyter notebook rapidly and quickly if you wrote it correctly. Excel not so much.
- narcraft 1y agoYou can have named ranges and cells in Excel, and Excel even has lambda/anonymous functions now. So in latest editions of excel functions can be as general or brittle as they are in any other language or environment, it just depends on how they're written.
- sas224dbm 1y agoof course it's re-usable .. most passionate excel jockeys would agree, as long it's their VBA that gets reused