Github user kaspersorensen commented on the issue:

    https://github.com/apache/metamodel/pull/194
  
    I think our tests should cover most of the stuff, but the one thing that I 
will admit was somewhat complicated was what I noted in the third commit:
    
    > I ran into an issue that reminded me of what we saw some time back [1]
    > with writing to a file-based workbook failing with message "user-mapped
    > section open". I found a reasonable workaround where workbooks are being
    > loaded based on their InputStream rather than their File reference
    > whenever we access the workbook in an update callback.
    > 
    > [1] https://bz.apache.org/bugzilla/show_bug.cgi?id=58480
    
    Or in terms of testing ... It would be interesting to compare performance 
and ability to do multiple inserts into the same sheet. I have a small fear 
that this new approach is slower because it is instantiating the Workbook based 
on `InputStream` instead of `File`. But OTOH I don't know of an alternative, 
because the `File` based thing is creating file system locks that prevent those 
inserts from happening without having to do very silly sleeps or something like 
that.


---

Reply via email to