Web Design Forums

Welcome! Please register or log in: Forgot your password? Why register?
You are here: Web Design Forums » Web Design Help » General Design Discussion » how to post editable Excel sheet RSS

how to post editable Excel sheet

This thread was started by lionheart and has been viewed 375 times, and contains 3 replies, with the last reply made by lionheart.
Post Reply
1
View lionheart's reputation
lionheart, WDF Noob Private message  
Posted May 11 '04 at 08:20 AM
      Posts: 4
Hi all,

i am working on intranet and i need to upload an excel sheet to the intranet, but can i make the different users open and edit it then those changes saved so that when another user open the file he see last changes..

Advertisement Register for free to hide these ads and participate in discussions!

2
1,325 points at 100% Repute WDFplus Member
Posted May 11 '04 at 09:13 AM
      Posts: 8,439
You will need a Document Management System if multiple people will be working on the same file. The reason is that if two people are working on the file simultaneously it will cause problems and the files will need to be merged. There are many of pre-packaged systems like Microsoft SourceSafe (probably the best known) that allow documents to be checked-out like a library book so that only one person can modify a document at a given time. There are also web-based document management systems. I know MS has one, but it's super-expensive (like $20k USD). You could probably emulate much of the functionality of a DMS using PHP, but it would be a pretty involved project. You might want to look around for existing open-source DMS projects using PHP.
Steven Moseley
President, Transio
smoseley is online now! Reply

3
1,325 points at 100% Repute WDFplus Member
Posted May 11 '04 at 09:15 AM
      Posts: 8,439
PS - The easy way to do this would be to use FTP instead of HTTP to allow them to read and write. Then, you will just have to give each author an FTP account on your document server.
Steven Moseley
President, Transio
smoseley is online now! Reply

4
View lionheart's reputation
lionheart, WDF Noob Private message  
Posted May 12 '04 at 01:18 AM
      Posts: 4
thanks a lot transio,
but how to use ftp. what i need is simply when a user clicks on a link the excel file is opened then he edit it and save changes, but how changes would be saved on server, when another user open the file later he can see the changes on the file.

Post Reply