![]() |
Importing CSV Data from Web?
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 |
All times are GMT +1. The time now is 11:51 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com