Forum Home
Press F1
 
Thread ID: 79556 2007-05-24 01:10:00 Excel as a web page DeSade (984) Press F1
Post ID Timestamp Content User
552583 2007-05-24 01:10:00 I know you can save a spreadsheet as a html document but can you also edit that excel sheet from the web?

Is there a way to do that?
DeSade (984)
552584 2007-05-24 07:06:00 It might be a good idea to clarify your question. What you ask sounds like nonsense. Greg (193)
552585 2007-05-24 08:05:00 Fair enough
I know there is a option to save a excel spreadsheet as a webpage
Office 2003
File/
Save As Web Page

I want to post this saved page to my web site which seems simple enough, however I want someone else to be able to edit this spreadsheet from the website.
Reason is I administer the site but I want someone else who is responsible for a member listing to be able to edit the spreadsheet with these details. I do not want to give this person ftp access to upload their own sheet with changes as I am not even sure I could do so, I do not run the server this is on.

Hopefully thats clearer
DeSade (984)
552586 2007-05-24 08:17:00 If you are "always connected", or your friend is, you could maintain the page on one of your computers, and just have a link on the web page. From time to time there would be problems, and the link would return an error. That probably wouldn't cause the immediate end of all animate life on the earth. You would need to be very careful with your firewalls and security updates. Graham L (2)
552587 2007-05-24 08:31:00 Fair enough
I know there is a option to save a excel spreadsheet as a webpage
Office 2003
File/
Save As Web Page

I want to post this saved page to my web site which seems simple enough, however I want someone else to be able to edit this spreadsheet from the website.
Reason is I administer the site but I want someone else who is responsible for a member listing to be able to edit the spreadsheet with these details. I do not want to give this person ftp access to upload their own sheet with changes as I am not even sure I could do so, I do not run the server this is on.

Hopefully thats clearer

You can do this with PHP and mysql. However if you don't know how to set it up, you would need to hire a deveoper to set it up for you.
rogerp (6864)
552588 2007-05-24 08:47:00 You can do this with PHP and mysql. However if you don't know how to set it up, you would need to hire a deveoper to set it up for you.

This is far beyond what we want to do for the site, its simply a gaming site with a member listing. Doing something like that would be overkill
DeSade (984)
552589 2007-05-24 11:53:00 Since you are wanting to use the data on a web and have someone edit it - then Excel is the wrong tool. PHP/Mysql would be a preferred option in this case.

Excel has some "web" capabilities but these are limited to displaying data.

A php/mysql solution is a simple solution if you have access to the skill set.

Alternatively you could put the data in a text file, use server side include to produce an SHTML file which presents the data in a webpage correctly formated. To edit this file would only require either a php or cgi script to overwrite the text file. This script only needs to be in a password protected folder on your site, so only admin with credentials can access it.
hkeyzer (9827)
552590 2007-05-24 12:49:00 This is far beyond what we want to do for the site, its simply a gaming site with a member listing. Doing something like that would be overkill

It is probably the only way to do it as you have described. You could hire a developer from india who maybe able to set it up for you for under $NZ100
rogerp (6864)
552591 2007-05-24 17:21:00 I think the simplest way to achieve what you want is to simply create a table in an html page and give the other user ftp access to it.

If you'd care to send me the excel doc I could check to see if my idea is feasible, and if yes then I'd gladly do it for you. fatkat at gmail.com
Greg (193)
552592 2007-05-24 21:00:00 I appreciate the offer to do it for me but if I went the table route I can easily code that myself, my html will stretch that far :)

I don't have the knowledge of PHP and I am not willing to pay a developer for this so thats out.

Think I might have to go for a table, a saved excel sheet I have discovered looks like utter crap when intergrated with a website.

So few options to check out here but looks like excel isn't going to cut it no matter how its implemented. Cheers for the replies guys, we can let this thread die :)
DeSade (984)
1