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: <>
In-Reply-To: <>

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

in say cell "K3" put the following formula
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
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.




Sites managed

This thread: