When designing an Excel template you can easily test the outcome directly from Excel.
Prerequisite
Steps
Open your Excel template.
Go to the dox42 ribbon and select Generate.

dox42 ribbon in Microsoft Excel
Depending on your configuration, an input parameter dialog might open.
Optional: Select or enter a value for the input parameter and select Generate.
Result
You have generated a test document.

Generated Excel document