in reply to munging csv into excel or otherwise

What you need to do is trivial with Spreadsheet::WriteExcel, and if you need to parse an excel sheet for your reports, Spreadsheet::ParseExcel works just as well. These two modules save me hours a day at work.

However, if you are pulling data from a CSV file, you will need a different module for that part.