Roody
01-24-2003, 05:50 PM
By Neil J. Rubenking
In Excel 2000, is there any easy way to save a block of rows and columns as a simple HTML table? I regularly get Excel spreadsheets that I need to publish to the Web, but I don't want all the extra formatting junk that Microsoft embeds to make the file specific to Internet Explorer. I just want the basic HTML, which I'll adjust in my Web editor.
When you save a workbook as HTML, Excel does indeed dump in a load of extra formatting. I don't see any way to avoid that, but you can create your unformatted table in a few simple steps.
Save the Excel file as tab-delimited text, and load the resulting file into Word. Search for tab (^t) and replace each occurrence with </TD><TD>. Search for end-of-line (^p) and replace each instance with </TD></TR>^p<TR><TD>. You now have an extra <TR><TD> on a blank line at the bottom, and the same text missing at the start of the very first line. Move the extra text to the beginning of the first line. Add the <TABLE> tag at the top and </TABLE> at the end and you're ready to copy the document into your HTML page.
In Excel 2000, is there any easy way to save a block of rows and columns as a simple HTML table? I regularly get Excel spreadsheets that I need to publish to the Web, but I don't want all the extra formatting junk that Microsoft embeds to make the file specific to Internet Explorer. I just want the basic HTML, which I'll adjust in my Web editor.
When you save a workbook as HTML, Excel does indeed dump in a load of extra formatting. I don't see any way to avoid that, but you can create your unformatted table in a few simple steps.
Save the Excel file as tab-delimited text, and load the resulting file into Word. Search for tab (^t) and replace each occurrence with </TD><TD>. Search for end-of-line (^p) and replace each instance with </TD></TR>^p<TR><TD>. You now have an extra <TR><TD> on a blank line at the bottom, and the same text missing at the start of the very first line. Move the extra text to the beginning of the first line. Add the <TABLE> tag at the top and </TABLE> at the end and you're ready to copy the document into your HTML page.