Re: how best to convert Excel spreadsheet to HTML?

by "Frank Boumphrey" <bckman(at)ix.netcom.com>

 Date:  Thu, 12 Apr 2001 21:25:28 -0400
 To:  "Dennis Lapcewich" <dlapcewich(at)intira.com>,
<hwg-techniques(at)hwg.org>
 Cc:  "'Robert Clendaniel'" <robert(at)baylogic.com>
 References:  dbn
  todo: View Thread, Original
You can use VB (or C or Java or Perl) to do it. I can send you an
example of the VB code if you wish. It's too long to post here.

Frank


----- Original Message -----
From: "Dennis Lapcewich" <dlapcewich(at)intira.com>
To: <hwg-techniques(at)hwg.org>
Cc: "'Robert Clendaniel'" <robert(at)baylogic.com>
Sent: Thursday, April 12, 2001 11:55 AM
Subject: RE: how best to convert Excel spreadsheet to HTML?


> > -----Original Message-----
> > From: Robert Clendaniel [mailto:robert(at)baylogic.com]
> >
> > We need to convert a basic Excel spreadsheet, 6-7 columns by 75
> > rows with no special formatting, into HTML that is at least
> > FAIRLY clean - unlike the hopelessly awful XML stuff Excel itself
> > outputs.
> >
>
>
> Robert,
>
> Quick and dirty method - Use Excel to do it.
>
> 1)  Make a copy of your spreadsheet and use that (Always preserve
the
> original!).
>
> 2)  Insert one additional column between every column of data.  That
means
> your original columns were all data - A, B, C, D, E.  Now they
should be A
> (empty column), B (data), C (empty column), D (data), E(empty
column), F
> (data), and so on.
>
> 3)  In the first cell of the first column, type in:  <tr><td>  Now
duplicate
> that in all the rows of that column.
>
> 4)  In all the other first cells of the remaining columns, type in:
> </td><td> and duplicate that in all the rows of those columns.
>
> 5)  In the empty column after the last column of data, type in:
</td></tr>
> and duplicate that in all the rows of that column.
>
> 6)  Insert a new first row at the top and enter in cell A1:  <table>
>
> 7)  In the last row, first cell, type in:  </table>
>
> 8)  Cut/paste that into a web page, save it, upload it and Bob's yer
uncle!
> :)
>
>
> If that's unclear, send me an email privately and I'll pop off a
simple
> spreadsheet to you of what I just wrote. No charge today.
>
> Dennis

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