Number 218 - July 2001

Creating an HTML Table from a Microsoft Excel 4.0 Spreadsheet
by Carl Tenning, Tacoma Open Group for Microcomputers
Have you ever wanted to display part of an Excel spreadsheet as a table in a web page? Manually constructing a table in HTML can be very tedious. Here is a way to automatically create the HTML code for the table from an Excel spreadsheet. (Later versions of Excel may do this automatically).     Highlight the cells in the Excel spreadsheet that you want to convert to an HTML table. The cells must start from Cell A 1. If they do not, then copy them into a	blank spreadsheet starting in Cell A 1. After selecting (highlighting) the cells, click Edit, Copy.     Next, open Outlook Express (this probably also works with Outlook) and select New Mail. In the message block, select Edit, Paste. The table will appear in the message block complete with borders. Then select File, Save As. Under the "Save as type", select "HTML Files" and save the file. Next, open the file with an HTML editor and you will see the spreadsheet encoded as an HTML table.
Number 218 - July 2001