Win32::OLE is merely a gateway, a door, to Microsoft Excel. This is why you need Microsoft Excel installed on the machine where you want to use it. If you don't want to use it, consider SpreadSheet::WriteExcel.

As Microsoft is the manufacturer of Excel, they also have vast documentation and example code for Excel on the MSDN. It is mostly written in VBA, but translation of VBA to Perl is not really hard.