Issue: No type library matching "Microsoft Excel" found at module name line 77 Win32::OLE(0.1703): GetOleTypeLibObject() Not a Win32::OLE::TypeLib object at C:/perl5/site/lib/Win32/OLE/Const.pm line 45

Solution:

This issue arise in windows 7, 64 bit with MS office 2013 with 64 bit, if you remove the use Win32::OLE::Const 'Microsoft Excel' line, you could not be able to read the excel file

so to avoid this error, use below standard code