Transcript Creating HTML Pages

Lecture
Creating HTML Pages in Excel
2007
Save File as Web Page
CHOOSE: File | Save As | Other
Formats
CHOOSE: Web Page
TYPE: Filename (Remember HTML
rules!)
Save: Entire Workbook or Chart or
Sheet
Excel converted to HTML
“Helper Folder”
• When you save an Excel file to HTML,
if there are any graphics or multiple
sheets, Excel will create a “helper”
folder automatically that has contains
all the support files:
“Helper Folder” (con’t)
• This folder must exist in the same location
as the HTML file in order for the HTML file
to display properly in the web page.
• If you don’t save directly to U:\web-docs,
use Win-SCP to transfer the entire folder to
web-docs along with the HTML file
• Check to insure your files are not Forbidden
Linking new HTML page
• Link your newly converted Excel files
to your HTML document the same way
you have linked all previous files:
<a href=“analysis.htm”>See the Five
Year anaylsis here>
• Insure that the helper folder is in your
web-docs folder too!
Linking Excel files in HTML
• Use <A HREF> tag
• <a href=“budget.xls”>Budget</a>