Monday, January 09, 2006
I often find myself needing to compile reports for management in Excel. In cases where there is a lot of data massaging I have found it easiest to to massage with Perl and export to a text file. I then take the text file into Excel using a standard text file import. This is clunky for reports that you do over and over again. It would be great to automate this process. Now you can with the Spreadsheet::WriteExcel module. Using this module you can write Perl data directly to files readable to Excel including formatting and formulas. Woohoo!