A
aandmstudios
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=20090508
Here's the page format:
<HTML>
<HEAD>
<TITLE>Time Report</TITLE>
</HEAD>
<BODY>
<pre>name, 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>
<pre>model_name,percentage,private_time_sec,login_time_sec,break_time_sec</
pre>
</BODY>
</HTML>
Any help is appreciated... thanks!
Mike
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=20090508
Here's the page format:
<HTML>
<HEAD>
<TITLE>Time Report</TITLE>
</HEAD>
<BODY>
<pre>name, 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>
<pre>model_name,percentage,private_time_sec,login_time_sec,break_time_sec</
pre>
</BODY>
</HTML>
Any help is appreciated... thanks!
Mike