export workbook to html

  • Thread starter Thread starter Jim Madsen
  • Start date Start date
J

Jim Madsen

I was exporting some spreadsheets to html, and I accidentally exported a
whole workbook. To my surprise, all the worksheets showed up on the web
page, and theey worked OK both in IE and Mozilla.

I looked at the web page source, and I didn't see in the code (or didn't
understand in the code) how these worksheet tabs are created so the
browsers can interpret them.

Would appreciate if someone could share their knowledge of this with me.

Jim
 
Hi Jim,
They are lot bigger than they look like they are. You will also
have to look in a folder that looks something like workbook_files
 
David--

So I noticed. I needed to change one of the cell borders on the web
page, and decided to do it in html as a learning exercize. I had to
sift through all the styles, until I finally found the correct style
class that did the needed formatting for that cell. I think some of the
styles automatically generated during the export weren't even used on
the web page. But I couldn't find what created the page tabs in the
html code.

Jim
 
Hi Jim,
If you ever want to just convert a selection of cells to HTML to
insert into your own page take a look at (no style sheets)
http://www.mvps.org/dmcritchie/excel/xl2html.htm
Trying to comprehend style sheets like those is way beyond
what I would want to manually manipulate.

If you want to see the code open in Firefox, then select several
sheets by selecting right across them, then right click and choose
"view Source".

---HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm
 
Back
Top