9 ms·
I've built a unit testing framework for Excel using Python and the openpyxl library. I work in a bank and using Excel was unavoidable in some cases. You'd basic
by pjacotg 3y ago
I've built a unit testing framework for Excel using Python and the openpyxl library. I work in a bank and using Excel was unavoidable in some cases. You'd basically build a test suite for a spreadsheet in Python and run it like a regular test suite. It helped a lot in catching issues. Obviously it would be nicer if unit testing was built into Excel, but it is possible to build side tools around it.
- riffraff 3y agoI know a guy who worked at $BIGBANK and did the same with Ruby, he gave us a presentation about it at a local user group meetup many years ago. IIRC, he was pretty proud of being able not only to have a regression test suite, but also being able to do TDD-excel :)
- pjacotg 3y agoI completely appreciate that. I was also attempting to tell regular excel users about the virtues of TDD! I had grander plans where I imagined creating centralised test suites that caught more generic issues and anybody in the bank could upload their spreadsheet for validation. It didn't quite get that far though.