davies kindly categorized a lot of Perl-and-spreadsheet information in Index of Spreadsheet FAQs, including a great deal of information on generating spreadsheets with Spreadsheet::WriteExcel and Win32::OLE.

I use Spreadsheet::WriteExcel a lot and find it a pleasure. And I've never seen a better-documented module.

--John