A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Excel to HTML Conversion



 
 
Thread Tools Display Modes
  #1  
Old November 18th, 2004, 03:28 PM
Keith Young
external usenet poster
 
Posts: n/a
Default Excel to HTML Conversion

I basically developed the way a website looks, as well as the content, in an
Excel workbook. I realize that this is likely not a good way to develop a
website but I am very familiar with Excel and it was easiest to at least
develop the "look" using Excel.

Included in this Excel "website" file are different sheets for the different
pages, pictures, lots of background coloring, different fonts, text boxes
with special coloring effects, etc. I have also included hyperlinks in the
cells to jump to the appropriate page (i.e., worksheet).

I basically know nothing about creating websites or html programming but I
did discover the "save-as" option that will convert the workbook to an html
file. Everything looks pretty good in Internet Explorer when I open the
html file (even the hyperlinks in the Excel file were converted to
hyperlinks in html) and everything works as planned. I was surprised to see
that the "Worksheet Tabs" were preserved in the conversion as well so it
still sort of maintains the look of a multiple sheet workbook.

So here are my questions: (1) Can the converted html file (and associated
directory with all of the pictures, graphics etc) simply be uploaded and
used as the basis for a web site? (2) Or, do some adjustments to the code
need to be made? (3) Or, is this type of html file not even usable as a
starting point for an actual web site. (4) If it can be used, what happens
to the "Worksheet Tabs" in the html file - is it possible to have this sort
of thing on a web page (I have never seen it)?

I did read some of David McRitchie's information on his site that seems to
indicate that all sorts of extra code specific to Excel is generated in the
conversion; however, even with all of this extra code, the file(s) are
relatively small. I also see that Mr. McRitchie also has some VBA code to
convert an Excel file without all of the "junk" but I would need to preserve
all of the formatting, colors, pictures etc.

If I need to, the converted html file can be given to a web site
designer/programmer and they can use it as the basis for developing some
decent/efficient code, but I am wondering if I can somehow skip this step
altogether and maybe use what I have as a starting point while I am learning
html programming.

Any advice, suggestions, comments would be appreciated.

Using Excel 2002.

Thanks in advance, Keith


 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Windows in Taskbar Chevy General Discussion 8 October 15th, 2004 03:57 PM
Outputting from HTML to excel? Rob New Users 2 September 22nd, 2004 10:59 PM
Saving Excel as HTML Dennis Diehl General Discussion 1 September 9th, 2004 08:27 PM
outputting memo fields to excel John Baker Running & Setting Up Queries 7 August 12th, 2004 01:23 PM
Excel will not open from HTML link Greg Setting up and Configuration 1 January 28th, 2004 04:13 PM


All times are GMT +1. The time now is 08:54 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.