How to automatically fill Excel template

Question

Hi,

At work each three months we have to write reports about past activities. For writing reports we have been given Excel template which contains columns to describe activity, date, time spent for the activity some combo box elements to select predefined location and some formulas.

As it takes a lot of time to rewrite all the details from personal evidence I was thinking about writing an application to write personal evidence into database and at the end of month fill the Excel template with stored data.

Does anyone know for any good resource which could be helpful for creating a solution described above?

Thanks

Answer 1

You should take a look at this MSDN page which is the starting point for the documentation of the Microsoft Office Development tools. You will find information on how to use the Office APIs which should help you do exactly what you want.

There is a dll given with the Office version that has classes to manage Excel documents. More specifically you can look at this other MSDN page that explains with an example how to create and edit an Excel workbook using Excel Interop.