Best bet is to look at to work out how to do stuff. Excel Object Model Reference
Then the CPAN Win32::OLE (Mentioned in first reply) on the syntax of how to call methods and set/get attributes documented in the Excel Object Model Reference