Win32::OLE enables you to do anything you can do from the face of the spreadsheet or from VBA. It needs Excel to be installed. Despite the name, it runs on 64 bit as well as 32 bit systems. Much goodness exists in Using Win32::OLE and Excel - Tips and Tricks.

Regards,

John Davies