There's an excellent article on Spreadsheet::WriteExcel in this month's The Perl Journal... it
sounds like pretty much just what you want to do. I
don't know how to get you a copy of the article without trampling on TPJ's copyright,
but it looks like they're going to put the articles on their website soon.