Am i way off here and being really stupid.

Don't tell this, I understand it's difficult to move the first steps in a totally unknown world full of many ways to do stuff.

Back to business, I think that a simple search for Excel in CPAN will be useful for you. I haven't used any of them, but I think that you'll be able to understand how to solve your problem.