Technical error with Excel.swapped names.Andreas Babler elected SPÖ party leader

Re:Technical error with Excel.swapped names.Andreas Babler e... by pjacotg on Monday June 05, 2023 @01:06PM (#36199410)

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.

[ Parent | on HN ]

Re:Technical error with Excel.swapped names.Andreas Babler e... by riffraff on Monday June 05, 2023 @01:45PM (#36200074)

I 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 :)

[ Parent | on HN ]

Re:Technical error with Excel.swapped names.Andreas Babler e... by pjacotg on Tuesday June 06, 2023 @12:16AM (#36208024)

I 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.

[ Parent | on HN ]