Freepages-Help-L Archives

Archiver > Freepages-Help > 2010-10 > 1287184474


From: Nick Reddan <>
Subject: Re: [FreeHelp] Excel to HTML - tip regarding Excel's auto
Date: Sat, 16 Oct 2010 10:14:34 +1100
References: <mailman.17.1287160054.15313.freepages-help@rootsweb.com>
In-Reply-To: <mailman.17.1287160054.15313.freepages-help@rootsweb.com>


There is an easy way to convert Excel tables without formatting to
HTML tables using formulae.

in say cell "K3" put the following formula
="<td>&A3&"</td>"
Copy this formula down and across to get the rows and columns you want.

Then in a cell further to the right put the following formula
="<tr>"&K3&L3&M3&"</tr>"
for a three column table

concatenate more cells between the "<tr>" and "</tr>" for wider tables

Put a <table> above and </table> below then copy into your text editor
and the code will produce the table data without any extraneous formatting.

See:
http://members.iinet.net.au/~nickred/temp/little_table.htm


Regards


/Nick/


Home
http://members.iinet.net.au/~nickred/
<http://members.iinet.net.au/%7Enickred/>;
Sites managed
http://freepages.genealogy.rootsweb.ancestry.com/~registryofdeeds/index.html
<http://freepages.genealogy.rootsweb.ancestry.com/%7Eregistryofdeeds/index.html>;
http://www.igrsoc.org/index.htm
http://members.iinet.net.au/~nickred/majuratennis/
<http://members.iinet.net.au/%7Enickred/majuratennis/>;



This thread: