Domain Manage

html tables help please

Discussion in 'Website Design' started by pendragon, Nov 20, 2006.

Thread Status:
Not open for further replies.
  1. pendragon United Kingdom

    pendragon Well-Known Member

    Joined:
    Aug 2006
    Posts:
    3,919
    Likes Received:
    12
    Anyone know a quick way of converting a table in excel to html. The table is 200x5 so i dont really want to have to type it all out again.

    Also, is there a quick way of extracting a hyperlink from a word in one cell and getting the hyperlink to show in full in a separate cell?
     
  2. Domain Forum

    Acorn Domains Elite Member

    Joined:
    1999
    Messages:
    Many
    Likes Received:
    Lots
     
  3. rob

    rob Founding Member

    Joined:
    Jan 2005
    Posts:
    5,953
    Likes Received:
    68
    Would suggest two options for the above:

    1 - save the excel table as HTML then trim as needed.
    2 - select > cut > open word/frontpage and paste in , then save as html.

    Each will give you a microsoft mess of HTML but table form that can be cleaned up by hand or 'remove MS crap' option in dreamweaver et al.
     
  4. mishmash

    mishmash Active Member

    Joined:
    Jan 2005
    Posts:
    160
    Likes Received:
    12
    Open a good text editor - one that supports regex search and replace.

    Copy and paste the content from Excel - it should emerge as tab separated variables with one row per line.

    Search and replace:
    Code:
    \t (tab) for </td><td>
    Code:
    ^ for <tr><td>
    Code:
    $ for </td></tr>
    Then top and tail as required.


    If I had to do it more than once I'd write a perl script which automated the above steps.
     
Thread Status:
Not open for further replies.

Share This Page