| Author |
unit testing framework for Excel
|
|
| Lars Schouw 2007-07-25, 4:03 am |
| Does anyone know if there is any unit testing framework for Excel?
I tried to google it but with no luck so far.
Lars
| |
| Jim Kingdon 2007-07-25, 8:01 am |
| > Does anyone know if there is any unit testing framework for Excel?
For macros? For Visual Basic macros there seems to be:
http://code.google.com/p/excelvbaunit/
Other than that I didn't see anything at
http://en.wikipedia.org/wiki/List_o...ting_frameworks
The good news is that xunit-style frameworks don't take much work to
implement once you've seen a few of them. It is also relatively easy
to start them out small and grow them as your tests expand.
| |
| andrewmcdonagh 2007-07-25, 7:02 pm |
| On Jul 25, 6:22 am, Lars Schouw <schou...@yahoo.com> wrote:
> Does anyone know if there is any unit testing framework for Excel?
> I tried to google it but with no luck so far.
> Lars
Hi Lars,
Take a look at http://davenicolette.wikispaces.com/TDD+for+Managers
It uses Excel to demo TDD to managers....might help you see how they
do it.
Andrew
| |
| Jim Kingdon 2007-07-25, 7:02 pm |
| > Take a look at http://davenicolette.wikispaces.com/TDD+for+Managers
>
> It uses Excel to demo TDD to managers....might help you see how they
> do it.
That's interesting.
Seems like it could be a good demo if you want to show TDD to someone
who "isn't a programmer" but writes big hairy excel macros.
When I'm trying to push tests to managers, I don't really try to
explain it at this level. I'm more likely to show them something like
a build server, where they can see what the checkins were, who checked
in each thing, and whether the tests passed. Things like "we'll find
the bugs now instead of in QA" strikes me as a manager-level message.
But the advantage of something like that Excel demo is you might be
able to get into things like the difference between test-first and
test-after.
|
|
|
|