Freepages-Help-L Archives

Archiver > Freepages-Help > 2010-10 > 1287219948


From: "Barry Carlson" <>
Subject: Re: [FreeHelp] Excel to HTML - tip regarding Excel's auto numbering
Date: Sat, 16 Oct 2010 22:05:48 +1300
References: <mailman.127.1287212431.32753.freepages-help@rootsweb.com><4CB95BC8.70809@webone.com.au>


Nick Reddan's example of creating an HTML table format within the
spreadsheet is a good one. I've had a look at it and found that one stage
can be eliminated, and when the spreadsheet example found at:-

http://countjustonce.com/test/simple-table.html

- is opened, the formula found in cell G11 is all that is needed to copy the
table to its left. Just copy and "fill down" the desired number of rows and
the table will be copied over complete with the HTML formatting.

The additional HTML formating above and below the table contents is also
entered in column "G" using the standard format in the formula field, e.g
="<!doctype html>'" etc..

To copy the result into your text editor, just highlight, copy and paste the
contents in column "G" into your editor and save.

Thanks Nick for sharing the simplified HTML table generation method.

Barry

This thread: