Excel Worksheets on the WEB

J

JEM

I head a section of the English department at my school. I want to put the
grade books on my web site so teachers can access them from the school or at
home and I can open them for review. I want them to be able to open a
workbook, enter and save data just as they would if they were working on the
computer that the file is saved on. How can I put Excel worsheets on my site
to do this?
 
T

Tom Miller

JEM said:
I head a section of the English department at my school. I want to put the
grade books on my web site so teachers can access them from the school or at
home and I can open them for review. I want them to be able to open a
workbook, enter and save data just as they would if they were working on the
computer that the file is saved on. How can I put Excel worsheets on my site
to do this?
Click to expand...
You will need to look in the insert components, your looking for a
spreadshee component, I think there is an update/upgrade available for
frontpage 2002 at least.

I just looked at under the insert/components menu. What I fail to see is a
way for the spreadsheet to save the information.

I think you could use the database wizard to get a similarly formated page
that would infact update/save a database.

Remember you want to secure access to those kind of pages too.

Tom
 
J

Jim Buyens

Excel and the Web aren't a very good match. The biggest
reasons are that:

o Excel is a single-user program and the Web requires
multi-user access.
o Excel is a desktop program, and Web processes need
back-end services.
o Excel data is loosely-structured. This makes it hard
for programming to process.

So, in virtually every case, you are better off using a
database. This will requires some Web programming
(probably ASP or ASP.NET) but the application seems
fairly simple.

If, however, you're tied to Excel, then you're probably
best off getting a file share on one of the school's
computers, or setting up an FTP site.

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

JEM

Thanks for the info.

Jim Buyens said:
Excel and the Web aren't a very good match. The biggest
reasons are that:

o Excel is a single-user program and the Web requires
multi-user access.
o Excel is a desktop program, and Web processes need
back-end services.
o Excel data is loosely-structured. This makes it hard
for programming to process.

So, in virtually every case, you are better off using a
database. This will requires some Web programming
(probably ASP or ASP.NET) but the application seems
fairly simple.

If, however, you're tied to Excel, then you're probably
best off getting a file share on one of the school's
computers, or setting up an FTP site.

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