xlUnit – Unit testing for Excel

You may also like...

7 Responses

  1. The screenshot created a big smille on my face!

    I think this is the first Unit Test in Excel 🙂

  2. You’re not blind, it was a really simple solution completely fixed for my project. So not worth sharing.

  3. Marko says:

    The idea sounds great! Is it possible to share your xlUnit with the rest of us?

  4. Hmmm, seems I’ve deleted a comment by accident, the one before the “You’re not blind” one.

    Anyway, it wasn’t a framework, just some methods. A main method (behind the start button in the screenshot) just executed all other methods. There was (for example) an Assert.Equals method that compared two parameters to see if the result was expected, including a parameter to let the assert method know what row it should show a red or green light. All functions in the screenshot were on a fixed location, so that was the row I had to give the Assert.Equals function.

    Just plain and simple. Like KIS (Keep It Simple). 🙂 But I had fun doing it.

  5. Nick says:

    Thanks Klaus vbaunit is good


  6. This is well known that cash can make us disembarrass. But what to do if someone has no money? The one way is to get the loan and term loan.

Click on a tab to select how you'd like to leave your comment

Leave a Reply

Your email address will not be published. Required fields are marked *