If you're on a Windows system and have Excel installed, you can use Win32::OLE to automate Excel. Anything that you can do manually in Excel is possible to do via Win32::OLE. But this is a case of Perl automating an external program (Excel). Personally I have not used any of the modules that attempt to manipulate Excel files without using Excel itself, so I can't comment on their capabilities or suggest an alternative.