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...