Excel sheet opening in read-only mode

[swati.jyoti]

If am trying to open an excel sheet(through web application) to edit any information,Its opening in read-only mode and displaying the msg that if I have to edit I have to save it in local and then i can make changes.But that i dont want,It should be saved and afterwards whoever opens it,they should get the latest information.Also i have checked the permission in excel sheet,It has both read and write permission.


How can i make the excel sheet to open in read and write mode so that user can edit it.

I am using Java,servlets in the business logic and Jsp for my pages.

Thanks

[Tolls]

If am trying to open an excel sheet(through web application) to edit any information,Its opening in read-only mode and displaying the msg that if I have to edit I have to save it in local and then i can make changes.But that i dont want,It should be saved and afterwards whoever opens it,they should get the latest information.Also i have checked the permission in excel sheet,It has both read and write permission.


How can i make the excel sheet to open in read and write mode so that user can edit it.

I am using Java,servlets in the business logic and Jsp for my pages.

Thanks

That's not how a web app works.
The excel sheet is always read only in a web app...it does not hold a reference to the original sheet or anything like that. All you can do, therefore, is save the file for edit...edit it...then upload it back to the server. However, since this is apparently shared, I woudl suggest this is possibly not a good idea. How would you deal with concurrency issues (user A edits the file, user B also edits the file, both save, who has precedence)?

[swati.jyoti]

Thanks then i have to thnk for other option...

:)