3 ms·
I always like these threads where programmers talk about tools like Excel and say they’re fine for small stuff but grow out of hand, as if 90% of codebases buil
by thom 7y ago
I always like these threads where programmers talk about tools like Excel and say they’re fine for small stuff but grow out of hand, as if 90% of codebases built by professional programmers aren’t exactly the same.
- davedx 7y agoBut professional programmers (emphasis on professional) are well aware of how codebases can grow out of hand and employ entire categories of theories, strategies and tools to keep their software maintainable, even when under delivery/time pressure. Excel doesn't really have much in this category of theories and tools.
- fzumstein 7y agoYou can actually unit test your Spreadsheets surprisingly easily with Python: https://www.slideshare.net/xlwings/automated-testing-of-excel-workbooks https://www.slideshare.net/xlwings/automated-testing-of-exce...
- giardini 7y agoYou really should look at some of the links I provide above to Jocelyn Ireson-Paine's work.
- marcosdumay 7y agoThe usual out of hand Excel file has a completely different size from the usual out of hand codebase.