Display a simple Excel sheet inside a table on a FP .htm page

J

JFD

Hi gang,
OK, I've just wasted 30 minutes trying to do something I thought would be
very simple.

I have a client who produces, on a weekly basis, a simple 30 line Excel
spreadsheet. The spreadsheet does contain some formatting - colors, borders,
etc. I want to create a situation where this individual can save his
spreadsheet to the same folder in this front-page web site each week. (Yes,
the file name would be the same each time, overwriting the previous version
of the file.)
I am quite familiar with using the include page Web component and was
expecting that would be able to designate an empty table cell on my target
page and use it to display this simple spreadsheet. (Expecting that each
time the sheet was updated, assuming it didn't get any larger, that it would
just replace the previous version)

I have tried saving the spreadsheet in various formats including HTML, XML,
and xls.

While I get various results that are something like the spreadsheet - I
don't get the formatting.

When I'm in the Excel file and I do a "preview as web page" in the browser I
get a great result.

When I save as web page (HTML), import the file into the web site, and
display the file in a table on my page using the include page Web component,
the formatting of my spreadsheet doesn't look at all like it does what it's
just displayed by itself in the browser.

I know there's got to be simple easy way to display an Excel spreadsheet
inside the body of a front-page web page with formatting intact.

I have searched the Microsoft knowledge base that all of the references I
have found focus on creating an editable active-x control version of the
spreadsheet, which I absolutely do not want. Rather, just a simple display of
information with formatting intact.

If someone has actually achieved this, with formatting intact, please respond.

Respectfully, I'm only interested in a 100% Microsoft solution.
 
R

Ronx

Have you pasted the stylesheet from the excel .htm page into the
<head> section of the final display page?
When you use a FrontPage include, only the part between <body> and
</body> of the include page are added to the display page. Anything
in the <head> section (CSS, JavaScript etc.) are not included, and
must be copied by hand.

In your case, if the formatting of the spreadsheet is never changed,
then the stylesheet need only be copied once, the data include will
keep those styles for subsequent updates.
 
J

JFD

Thank you Ronx,

It worked just fine. For anyone else trying this, you should specify the
section of the worksheet that contains information, not the whole worksheet,
when you do the "save as HTML" unless you want to fight with your tables.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top