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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 | |
|
|
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 |