Results 1 to 3 of 3
  1. #1
    swati.jyoti is offline Member
    Join Date
    Mar 2009
    Posts
    42
    Rep Power
    0

    Question Excel sheet opening in read-only mode

    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

  2. #2
    Tolls is offline Moderator
    Join Date
    Apr 2009
    Posts
    11,755
    Rep Power
    19

    Default

    Quote Originally Posted by swati.jyoti View Post
    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)?

  3. #3
    swati.jyoti is offline Member
    Join Date
    Mar 2009
    Posts
    42
    Rep Power
    0

Similar Threads

  1. SQL Query resultset into Excel Sheet
    By chandpuri in forum JDBC
    Replies: 8
    Last Post: 01-24-2011, 06:53 PM
  2. How to create excel sheet?
    By kishan in forum Advanced Java
    Replies: 3
    Last Post: 07-13-2010, 01:15 PM
  3. Export Html table to excel sheet by JS
    By roby_joshua in forum New To Java
    Replies: 1
    Last Post: 08-27-2008, 06:25 PM
  4. Replies: 0
    Last Post: 03-11-2008, 02:20 PM
  5. How to set the AutoFilter to Excel Sheet with Wither POI or JXL
    By lnarayana_boga in forum Advanced Java
    Replies: 0
    Last Post: 01-29-2008, 09:05 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •