| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Missing Cloumn data when importing external data | Excel Discussion (Misc queries) | |||
| Importing:Data Connection Wizard Doesn't see Source Data - No Impo | Excel Discussion (Misc queries) | |||
| Removing Data Tables formed from importing data from Access | Excel Discussion (Misc queries) | |||
| Importing Data: OLE DB and data link properties dialog | Excel Discussion (Misc queries) | |||
| Data types when importing Excel data to SQLServer | Excel Discussion (Misc queries) | |||
Linear Mode
