B4J Question Export to Excel creates ReadOnly file

[Victor Pavlov]

We created Excel file through jexcel library the file stays in ReadOnly mode. The message from Excel is: The file is locked for editing by "".

Please, advice.

 

[Erel]

Not sure why it is locked. However you can write the table to a temporary file and then copy it:

File.Copy(File.DirApp, "1.xls", File.DirApp, "2.xls")

You can then use the same temporary file again.

 

[alienhunter]

hmmm
i noticed that too everything that fx writes is locked , but like erel wrote I copy it in a different place to be able to open a file with another application when fx is running

 

[Crock]

Even though the workbook is closed, NumberOfSheets returns 1 and I get no error.
...

'add some cells etc
wb.Write
wb.Close
Log("sheetcount=" & wb.NumberOfSheets)

But if I try another wb.close it raises an error, as expected.

Unlike alienhunter's experience, I find that if the jar is still running, I still cannot open the xls from another Windows folder. I wonder if wb.close is not properly closing the file and releasing the lock. Can someone confirm the above?

 

[Erel]

wb.Close calls the native close method.

Have you tried the code I posted in post #2?

 

[Crock]

wb.Close calls the native close method.

Have you tried the code I posted in post #2?

Thanks, I can see that is a workaround but it makes no sense that the native close method keeps a file locked. Is this a Java "feature"?

 

[Erel]

It is not related to Java. It seems like an issue with the native JXL library.

 

[Crock]

It is not related to Java. It seems like an issue with the native JXL library.

Thanks Erel. I just had a good search and found nothing about this read-only issue. If I find anything else I'll post back here.