> Microsoft Excel has the ability to import data via a web query. If I
create
> a query and run it on the following URL, a table with stock price
> information will be displayed on an Excel worksheet.
> http://finance.yahoo.com/q?s=%5EIXIC+%5EDJI+RHAT++&d=v1
> Now to the Perl/CGI question. What techniques and functions would I
use in
> Perl to retrieve data from the above URL and save to a comma delimited
data
> file?
I see two basic options:
Drive Excel using perl.
Use perl to do it all.
In the former case, I would suggest:
Use existing perl module to drive Excel using Automation
In the latter case, I would suggest:
Use existing perl module to get the content for the URL
Use existing perl module to parse the content
Write the code to write what you want to a CSV
To seek out existing modules, use cpan:
http://search.cpan.org/
hth.
