Linking Excel and Frontpage

  • Thread starter Thread starter Joan
  • Start date Start date
J

Joan

hi does anyone know how to embed an Excel Spreadsheet on
a server to a webpage in frontpage so that you can enter,
edit data etc. via the webpage which will then show the
updated results on the page preferably without using
hyperlinks

thanks
 
Joan said:
hi does anyone know how to embed an Excel Spreadsheet on
a server to a webpage in frontpage so that you can enter,
edit data etc. via the webpage which will then show the
updated results on the page preferably without using
hyperlinks

thanks
Click to expand...

Ya can't. If it is a public web server you'd have read/write access open to
the world, and that would be bad.

If it is an Intranet, try looking into SharePoint Services, that will allow
various users to cooperate on a document.
 
Joan said:
hi does anyone know how to embed an Excel Spreadsheet on
a server to a webpage in frontpage so that you can enter,
edit data etc. via the webpage which will then show the
updated results on the page preferably without using
hyperlinks

thanks
Click to expand...

Simplistically, it's easy to simply put the Excel spreadsheet on the web
site, and from an HTML file link to it. Then, when user clicks on the
link the browser downloads a COPY of this spreadsheet to user it and
recognizes it's an XLS file. If user has Excel, then browser will lauch
portions of Excel to load their individual copy of the file into the
browser to display with the help of the Excel components.

However, the problems are (that you must think through) that a COPY of
the file has been delivered to the user. The ORIGINAL on the web server
is not locked to stop other people from making their own independant
changes to their own different copies that they independantly have
downloaded.

And once copies are made you need a way for user(s) to copy the new
version of file back to the web server. Even if the users could write
back directly to the web server, how would the web server handle the
potential for simultaneous write-backs, and how would the web server
decide whose version is the one to actually write? It would be chaos.

Frankly, all that is much too complicated for a web site. You need other
technology to achieve this.

Think of the web site as a way to PUBLISH the information for viewing.
If needing to write back information, have a controlled/managed
write-back procedure (preferably independant of HTTP). I've done this
by simply giving designated people access to the File Share on a mapped
LAN drive. Even then somehow or another users have to know to REFRESH
to get updates of changed information.
 
-----Original Message-----
hi does anyone know how to embed an Excel Spreadsheet on
a server to a webpage in frontpage so that you can
enter, edit data etc. via the webpage which will then
show the updated results on the page preferably without
using hyperlinks
Click to expand...

You can do this by setting up a named range in Excel,
putting field names at the top of the range, and then
setting up a database connection to the spreadsheet.

Having done this, you can then use HTML forms to add
records to the range, and the Database Results Wizard to
do reporting.

However, at this point you're using Excel like a database
(which it isn't) things start to get flakey. You're much
better off using a database.

Editing data is going to be tougher. For that, you really
need to use a database and write a little application
that runs on the server (i.e. in ASP or ASP.NET).

Jim Buyens
Microsoft FrontPage MVP
(e-mail address removed)
http://www.interlacken.com
Author of:
*------------------------------------------------------*
|\----------------------------------------------------/|
|| Microsoft Office FrontPage 2003 Inside Out ||
|| Microsoft FrontPage Version 2002 Inside Out ||
|| Web Database Development Step by Step .NET Edition ||
|| Troubleshooting Microsoft FrontPage 2002 ||
|| Faster Smarter Beginning Programming ||
|| (All from Microsoft Press) ||
|/----------------------------------------------------\|
*------------------------------------------------------*
 
Back
Top