Re: how best to convert Excel spreadsheet to HTML?

by "Paul Roberts" <roberts_paul(at)bigfoot.com>

 Date:  Wed, 18 Apr 2001 07:51:30 +0100
 To:  <bryan.westbrook(at)amd.com>,
<hwg-techniques(at)hwg.org>
 References:  amd
  todo: View Thread, Original
excel 97 was loads better than 2000 at this, it would even insert the data
into your own template file and the code comes out fairly clean.

how about using mail merge to fill the data into the cells in catalogue
mode.
i.e.
<tr>
    <td> <<mergedata1>> </td>
    <td> <<mergedata2>> </td>
    <td> <<mergedata3>> </td>
    <td> <<mergedata4>> </td>
    <td> <<mergedata5>> </td>
    <td> <<mergedata6>> </td>
    <td> <<mergedata7>> </td>
</tr>

should give a clean table if you paste it in and add table tags.

Paul Roberts

roberts_paul(at)bigfoot.com
+++++++++++++++++++++
----- Original Message -----
From: <bryan.westbrook(at)amd.com>
To: <hwg-techniques(at)hwg.org>
Sent: Thursday, April 12, 2001 6:34 PM
Subject: RE: how best to convert Excel spreadsheet to HTML?


| This is one hack (in the good sense of the word) that I will have to
| remember.  I wish I had seen this a few days ago.
|
| I took a spreadsheet and saved it as tab delimited text and then used
| EditPad's find and replace feature to turn those tabs into cell divisions.
| It was a bit more time consuming to do it my way, but I was able to get my
| indents and line breaks where I wanted them too so I guess the trade off
was
| worth it.
|
|
| -----Original Message-----
| From: Dennis Lapcewich [mailto:dlapcewich(at)intira.com]
| Sent: Thursday, April 12, 2001 10:55 AM
| To: hwg-techniques(at)hwg.org
| Cc: 'Robert Clendaniel'
| Subject: RE: how best to convert Excel spreadsheet to HTML?
|
|
| Quick and dirty method - Use Excel to do it.
|
|
|

HWG hwg-techniques mailing list archives, maintained by Webmasters @ IWA