Another possibility is to use Win32::OLE. The link below tells how to first record a macro in Excel to do what needs to be done, then look at the VBA code and translate to Perl.

Use The Macro Recorder, Luke (Re: Using Win32::OLE and Excel - Tips and Tricks)