How do I unit test Word AddIn written in C#

Question

I need end-to-end guidance on this topic.

Here is a scenario: I have a Word AddIn written in C#, in which I have some interop interaction with Excel. I need to unit-test that.

How?

There is no usable guidance on the topic, except this: http://clear-lines.com/blog/post/unit-testing-vsto-projects.aspx

Thanks Dragan

Answer 1

The answer to almost all questions about unit testing is "decouple from dependencies".

Refactor your code to decouple the logic (which you want to test) from the interactions with with Excel.

Remember that unit tests should answer the question "does the code I am writing do what I intend it to do" and not "does my program work properly" - that's for integration tests.

Answer 2

I haven't done this type of testing, what I would recommend is looking into how you can write office macros that utilise the functions of your add-in to test it's functionality. You should be able to add vba command buttons to a spreadsheet or document or the word toolbar that runs your tests.

I am assuming that as you are testing and adding in VSTO, you have a good working knowledge of the excel and word APIs as that would be required.