It's great to get this such a task automated once and for all if the OP was going to have to generate this sort of report every other while. Excel alone can be fun to work with of course but not when you want to extend some of its capabilities. Now I don't know which of the modules can be better to work with, I have worked with Spreadsheet::WriteExcel sometime but I faced a problem of not being able to append to an excel file no matter how I tried...so if this is a known issue that should be a disadvantage.
Excellence is an Endeavor of Persistence.
Chance Favors a Prepared Mind.