The Problem consists of three parts. First, fetching the resource located by the URL. This is done easily with LWP::Simple and if you need more details, write your own LWP::UserAgent. To create a nice, simple HTTP Request use HTTP::Request::Common and if again you need more control, use HTTP::Request.

When you've retrieved the resource, you must extract data from that HTML Document the resource is. To do that correctly, don't use regular expressions but an HTML::Parser, probably most straight-forward is HTML::TokeParser.

Third, putting the stuff into an Excel table is done using Spreadsheet::WriteExcel

And if you didn't know before, now you know why the CPAN is a Good Thing.

--
http://fruiture.de