B4J Question jExcel does not close workbook

Discussion in 'B4J Questions' started by fixit30, Jun 23, 2015.

  1. fixit30

    fixit30 Active Member Licensed User

    I am trying to use jExcel in a non UI server project.

    I can successfully open a template, create a new WritableWorkbook, modify the contents and save. However it appears that even though I call Close, the new file remains locked and can only be opened in Excel Read Only until the Java application is closed.

    [​IMG]

    Does anyone have any idea what might be wrong?

    Attached is a very simple (UI) app that reproduces the issue.

    I'm using the latest version of jxl.jar (v2.6.12)
     

    Attached Files:

  2. Erel

    Erel Administrator Staff Member Licensed User

    This is a known issue with this library.
    Work with a temporary file and then make a copy with File.Copy to create the final file.
     
  3. fixit30

    fixit30 Active Member Licensed User

    Thank you it works!
     
Loading...
  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice