Posting data from a spreadsheet to a web page

[Guest]

I'm very new at createing web pages. And have a few questions regarding MS
Excel & MS Frontpage.

First of all, I have created a spreadsheet that is set to automatically
refresh every 1 minute to collect a value that is at a external web site.
This spreadsheet takes that value and performs a couple calculations for me
and places them in 3 seperate cells within the spreadsheet. Of course, i'm
assuming this refreshing is going on automatically since the spreadsheet is
placed on my server, right?

Next I want to have those three calculations placed in a cell within a web
page and have them refreshed say every 5 minutes. How do I do this?

 

[Stefan B Rusynko]

Not possible
- you will need to use server side scripting depending on what your host supports
Excel is not designed to be a web server

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
To find the best Newsgroup for FrontPage support see:
http://www.frontpagemvps.com/FrontPageNewsGroups/tabid/53/Default.aspx
_____________________________________________


| I'm very new at createing web pages. And have a few questions regarding MS
| Excel & MS Frontpage.
|
| First of all, I have created a spreadsheet that is set to automatically
| refresh every 1 minute to collect a value that is at a external web site.
| This spreadsheet takes that value and performs a couple calculations for me
| and places them in 3 seperate cells within the spreadsheet. Of course, i'm
| assuming this refreshing is going on automatically since the spreadsheet is
| placed on my server, right?
|
| Next I want to have those three calculations placed in a cell within a web
| page and have them refreshed say every 5 minutes. How do I do this?
|
|
|

 

[Anonymous Chief]

With excel, you can save your file as a web page, just like most other
office programs, like word. What I know is that you can set excel to
automatically save and html copy of your xls file on your server to update
the one that has already published. I do not know however, how to get excel
to save the file every 5 minutes. You would probably need a macro that would
click on "save" every 5 minutes.

This is how you do what i think you can do with excel

1. Select the area you would like to be displayed on the website then go to
File>>Print Area>>Select Print Area. This will define the are on that
spreadsheet that would be published (remember that excel has 65535 rows and
256 columns, we would not want all that empty space going on your web
server...lol)

2. Go to File>>Save as webpage

3. You will notice that the file name is the same as the name of the excel
file, but the extension is html. You can change the filename part to
anything you want. I usually avoid spaces cos you would get %20 in the place
where the space was.

4. Select "Selection: Print Area". You may click "change title" to set the
wording for the title bar of the published page since excel publishes a
whole page.

5. If you do not want the published document to be a whole page and you want
it to be contained like as a table within another page, you may want to
consider inserting it as an inline frame. Click the publish button, type in
the publish path to your website where it says "File name" and select
"Autopublish everytime this workbook is saved. Leave "Open published web
page in browser" selected

6. You will now be prompted for your webserver login details then the page
will be displayed

7.You're done, and here is your diploma

============
Anonymous Chief