Did you read any of the replies to this thread, or super search this before posting this question? This question comes up a lot. You can automate Excel using Win32::OLE, or perhaps you would prefer to use one of the other modules on cpan. See Using Win32::OLE and Excel - Tips and Tricks for an example.

Installing Modules from the tutorials section is a good resource if you need help installing modules.

Martin