On Mon, 18 Nov 2013, Дмитрий Омелечко wrote:
I have big, complex worksheet and time limit for calc output cells from
this math model.
Is it possible to run formula evaluation of the same worksheet in
different threads?
My hunch is no. In general, POI requires that one and only one thread
interact with a given workbook. You can have multiple threads each working
on their own workbook, as the code is thread-safe at that level, but
within one open file there's a requirement that only one thread be
touching it.
Josh did a lot of work a few years ago to speed up formula evaluation, and
I know he got it running pretty slickly for his case. If possible, follow
the advice in http://poi.apache.org/spreadsheet/eval.html#Performance
Nick
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
