ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Importing CSV Data from Web? (https://www.excelbanter.com/excel-worksheet-functions/230296-importing-csv-data-web.html)

aandmstudios

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