Hacker News Reader

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?

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.