Forum Moderators: phranque

Message Too Old, No Replies

Possible to allow users to update an excel file from a webpage?

creating an excel files that is interactive and able to be updated online.

         

ruhbehka

4:00 pm on Nov 11, 2003 (gmt 0)

10+ Year Member



Does anyone know if it's possible to create an excel file that a user can access from the internet, load in their browser, make changes, and save those changes to the file on the server, without having to download the file and FTP it back up?

I have it to the point where they can see it in their browser and make interactive changes, but I can't figure out if it's possible to let them save it back to the server.

what i'm trying to create is a calendar that four people in our office can update their schedules on (just when they will be out doing service calls on the road, about one to two entries per month), from their laptops. security is not a big issue.

they are all familiar with excel, but anything beyond that would be too 'high tech'. ;)

Anyone know if it's possible, or have a different way that I could do this? I want them to be able to see a whole calendar on one page, easy to glance at everyone's schedules and make changes to it, if necessary.

HughMungus

5:42 pm on Nov 11, 2003 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member



I'm not SURE but I'd think the file would have to be in a writable directory for this to work (I just tried it on my IIS server and tho I could see the file, I couldn't save any changes). What about a very simple web page with form input? Seems like that would be a lot easier.

coopster

6:53 pm on Nov 11, 2003 (gmt 0)

WebmasterWorld Administrator 10+ Year Member



One issue you are going to have with your idea/design is file replacement (lack of file locking).

For example:
------------
EMPLOYEE#1 "downloads" a copy of the file and simply walks off to get coffee. In the meantime, EMPLOYEE#2 comes along and downloads a copy of the same file, updates it and posts it back. Now EMPLOYEE#1 returns to his desk, updates the file and posts it back up, OVERWRITING any changes made by EMPLOYEE#2.

I may be overcomplicating things, but it's something you are going to need to consider.

bcolflesh

7:16 pm on Nov 11, 2003 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member



You need to install or have access to a server with the Office Web Components enabled - more info here:

microsoft.com/office/ork/xp/five/wgtb06.htm