Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > HTML > html table to excel

Thread Tools

html table to excel

hanan hanan is offline
Junior Member
Join Date: Apr 2007
Posts: 1
I am a beginner in the area. I would like to copy a large amount of tables from a certain web site (there is an index page with links to many web pages with tables inside each web link)into an excel sheet. I need to do this on a weekly basis, that's why I don't just copy-paste the information.
I need to copy those into 1 long excel sheet for further analysis (a script probably).
Before each table there is always a unique sentence, so I probably can search for it inside the html to locate the tables? (I am a beginner and don't really know how to approach this)
If the page is on the web, how can I search in it with a script? I need to download the html file to my computer? can my script do this automatically? (many many web pages)
Be glad to any tips... tutorial... code...
(I am a beginner but with motivation... )
Thanks a lot!
Reply With Quote

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
How to convert excel table to clean minimal html table KiwiBrian NZ Computing 4 08-24-2008 08:36 PM
Re: Open an Excel File in Excel, not HTML viza HTML 0 07-07-2008 11:04 PM
GridView to Excel then Excel to database table. ASP .Net 0 11-06-2007 06:40 PM
Problem with Excel reports ::::Excel 2003 Migration To Excel 2007 =?Utf-8?B?c2hhc2hhbmsga3Vsa2Fybmk=?= ASP .Net 15 10-24-2007 01:34 PM
MS Excel - How can I summarize a table? Will Pivot Table Reports do this for me? hugh jass Computer Support 3 09-10-2003 11:02 PM