Show a Excel Worksheet in a Web page

[rocknrisk]

Hi all,

I have seen this done before, but have no idea how it's done (and now I cannot seem to find an example).

How do you display a Excel Worksheet in a Web page?

Thank you in advance. "Finish what you started"

 

[rocknrisk]

Hi all,

As no-one has replied yet, I'l elaborate on my question.

Could anyone please tell how to embed an excel sheet into a web page.

I've tried:
<EMBED src=&quot;file.xls&quot; width=&quot;100%&quot; height=&quot;400&quot;>Embedded File</EMBED>

but, this does not work. I cannot find any help on this (after searching the Web for approx. 4 hours).

Thank you in advance. &quot;Finish what you started&quot;

 

[theocraticmind]

ok, there are 2 options.

option the first:

in exel...file>save as web page
ok, this option isn't as good as it seems. it saves as xml (xmlns). this isn't very easy to edit, and you may want to, because there will be no table boarder.

option the second:

only works in IE, but if you link to the xls file directly, it will open in the browser. kinda like pdf files do. is NS4, it asks if you want to download. in NS6, it askes, if you want to download, or open in exel (i'm asuming this is only if the user has exel on thier comp).

 

[tiggertail]

I use the excel save as web page, and then publish. This gives the option to include excel functionality with the embedded object. The script is ugly, but microsoft mark clearly which section is the xl sheet, so adding other things round it is fairly easy. Using this method also means you can re-publish/update your xl without rewriting the page.

 

[theocraticmind]

glad it worked (-:

 

[rocknrisk]

Hi TheocraticMind & tiggertail,

Problem with this is that the Web page created by Excel is a whoping 459Kb (the original xls document is 57Kb). This is unexceptable.

I find it hard to believe that one can embed a movie, sound file, etc, but not an Office document. There has to be a way. Challenge of the day.

The thing is that I have seen this been done. I found a site yesterday that does this using frames (I can't because of my JavaScrpt menu.

For now, I am just linking to the xls document, but there has to be a way. I'll keep looking.

Thanks
Clinton &quot;Finish what you started&quot;

 

[MarcLodge]

Rocknrisk,
This article shows how to create and maintain an excel spreadsheet from an HTML page using JScript and VBScript

http://support.microsoft.com/default.aspx?scid=kb;EN-US;q234774

Alternatively pay money and buy Excelwriter for $199 here:

http://www.softartisans.com/softartisans/excelwriter.html

although I don't think that this is what you want.

HTH
Marc