3 ms·

A fundamental difference is Excel just doesn't work with the tools devs are used to for ensuring code quality. How to you version control Excel sheets? I guess

A fundamental difference is Excel just doesn't work with the tools devs are used to for ensuring code quality. How to you version control Excel sheets? I guess you can technically use git but the diffs will be completely useless. How do you run unit/integration tests on an excel sheet?

pjacotg 4y ago
In my previous job I used a Python library called openpyxl to write a suite of unit tests for some unwieldy spreadsheets that our team owned. The tests were run every time the sheets were updated so we had a form of test driven development when working with the sheets. There was a long running project on the go to retire the spreadsheets and replace them with a proper application but that was a multiyear effort.