html table to excel

Discussion in 'HTML and CSS' started by hanan, Apr 29, 2007.

  1. hanan

    hanan

    Joined:
    Apr 29, 2007
    Messages:
    1
    Likes Received:
    0
    Hi,
    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!
    Hanan.
     
    hanan, Apr 29, 2007
    #1
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.