html table - please assist

  • Thread starter Thread starter Mark G.
  • Start date Start date
M

Mark G.

I have a spreadsheet that was created in Excel 2003 and would like to turn
it into a HTML table. Just a simple table. The save as web page option
doesn't quite give me the options or look that I am after. I would like it
to export and be just like a table would be if created in HTML or an editor
like MS FrontPage 2003 (which I have as well). From this, if it is possible,
I want to be able to apply some JavaScript to the newly created table. I
hope I have made clear what I am after. Can someone help me with this? I did
a Google search and found old programs and info that just do not cut it.

So something like:

<table>

--data from excel spreadsheet--

</table>

Thanks much for any input any of you can provide.
 
While I am at it, I am curious, is there an easy way to upload the new info
that is periodically updated in the spreadsheet without having to completely
redo all of this each time the spreadsheet has a change? Thanks much.
 
For what you want, you would need to read all the data in a loop and output
to a text file adding the HTML tags yourself. It is not trivial, I have done
it with Word.
 
Hi Mark,
I can't make sense of just a simple table ... as if created in Front Page.
Those are at quite opposite extremes of the spectrum, especially if you
were to paste Excel into Front Page then you get round tripping code as well.

I can make sense of Bob's answer about making the table yourself, see
http://www.mvps.org/dmcritchie/excel/xl2html.htm
http://www.mvps.org/dmcritchie/excel/code/xl2htmlx.txt
I don't bother with trying to make it look like Excel, and if you have
HTML source in the cells it is passed through unchanged so it becomes
part of the HTML tags. Very limited font changes.

I'm not going to get into automation, I think you should see if the above
is what you are looking for or not; although it does create a complete HTML
file the purpose was to copy the table and paste it into my own HTML files.
You can always add your Meta tags later.
 
As an aside, I found with my Word problem that it was actually easier to
process an HTML file and create a Word doc rather than the other way around.

Of course, your situation may not give you that option, but it was easier,
for me.

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
I had some REXX macros for use with ISPF to read text, is that
close enough. I even had PC versions. <grin>

Actually the old Rich Text Format (RTF2HTML) probably did a much
nicer job than what you forced into now. I thought it was bad that it
put the widths into each cell of a table when you only needed it for
the first row (if you needed it at all), and I went to the trouble of
removing those unnecessary widths to make the file shorter as
if anyone would have noticed.
 
Back
Top