There are tons of code in this forum which address your question. You might want to start with Using Win32::OLE and Excel - Tips and Tricks and then use Super Search to search further for Win32::OLE and Excel.