I have a CSV formatted report, embedded in an HTML page that I'd like
to automatically import into an excel 2007 spreadsheet. The page,
requires that I log on. How can I do this?
First, I have to log on to the site. The logon page uses the post
method.
Within the URL, I have to specify the date range, in the format:
/time.php?a=overview&date_start=20090427&date_end=2 0090508
Here's the page format:
<HTML
<HEAD
<TITLETime Report</TITLE
</HEAD
<BODY
<prename, percentage, time1, time2, time3, time4, time5, time6,
time7, time8, time6, break_time_sec
Employee 1,0.0,,,,,,13272,13272,,,1716
Employee 2,0.0,,,,,,6,6,,,354
Employee 3,31.8,,14185,,,,30482,44667,821,,2255
</pre
<premodel_name,percentage,private_time_sec,login_ time_sec,break_time_sec</
pre
</BODY
</HTML
Any help is appreciated... thanks!
Mike