html tables help please

[pendragon]

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?

 

[rob]

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.

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.

 

[mishmash]

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:

\t (tab) for </td><td>

^ for <tr><td>

$ 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.