There are many nodes on this topic, foremost of which is the excellent tutorial Using Win32::OLE and Excel - Tips and Tricks by cacharbe. Use Super Search and you can find many others.