RootsWeb.com Mailing Lists
Total: 1/1
    1. Re: [FreeHelp] FREEPAGES-HELP Excel to HTML - tip regarding Excel's auto numbering
    2. Ralph Taylor
    3. To convert an Excel (or other spreadsheet) table to HTML, I prefer the method introduced here by Barry Carlson a few years ago. It involves saving the file as plain text before converting it to HTML. One advantage is that it requires knowing only those few HTML codes used in tables. It is the most efficient procedure I've found for producing a HTML table from spreadsheet data without "code bloat" and I've used it many times. Step-by-step: 1. Insert a new, blank column before the first column of data and columns between each data column. This avoids over-writing the data with HTML codes. 2. On a blank row before the data, enter the table-opening tag, <table>; on a blank row after the data, enter the closing table tag, </table>. 3. In the first column (the one you inserted), enter the codes to open a table row and a table cell, <tr><td>. For the header row, substitute <tr><th>. Copy the <tr><td> codes all the way down the column to the end of the table. 4. Between data columns, enter the codes to close one cell & open another, </td><td>. (Header row: </th><th>.) Copy the codes all the way down the table. CSS: If you want CSS styling of some cells, step 4 is the time to specify the class. 5. In the column after the data, enter the codes to close a cell and a row, </td></tr>. Copy the codes all the way down the table. 6. IMPORTANT! "Save as" the file as a plain text file, with a .txt file name extension. DO NOT SAVE AS WEB PAGE! This strips out any formatting that hasn't been given a HTML code. (You'll notice that the text file has tab spaces between each former Excel cell, you can use Control-H to strip these out if desired.) 7. Open the file in Notepad or other plain-text editor; alternatively, open it in your Web editor. Add in the other stuff (doctype, document header, body tags, includes, etc.); if you've created a template, you'll mostly copy and paste. 8. "Save as" the file with a .htm extension. You now have an HTML file with only the formatting that you specifically choose. There is no bloated code to strip out. You can continue to work with it in your Web editor. Two tips: 1. It's helpful to use a second version of the file, so that the original is available in case of mistakes. Save the second version frequently during the processing. 2. For multi-column tables, I like to start with the last column and work from right to left. -rt_/)

    10/15/2010 07:58:24