Yes sure Mark, I agree with you, but it had been simpler for me to
perform a copy. Actually I think that the best way of "caching" data
could be always to use an xls file, but opening and closing it each time
(which now I've seen it works well with POI 3.8). I will try to modify
my script that way.
Thanks and best regards,
Flavio
Il 15/06/2012 18:50, Mark Beardsley ha scritto:
There may be alternatives that you could consider rather than building the
workbook as the processes are running. What I am thinking is, would it be
possible to cache the information as it is produced into one or more text
files - I guess that the closest analogue I can think of is a CSV file.
Images could be 'stored' into the cache files as paths (URL's I guess) along
with the row and column information. That way, you would be able to pick up
all of the data after it had been produced and use it to populate a
workbook. One downside I can see to this is that if the process is
terminated abnormally and early, how will you trigger the processing of the
cached data? The other obvious problem is if any formatting information for
the data is derived dynamically, as the processes are running. That will be
harder to capture but it might still be possible.
--
View this message in context:
http://apache-poi.1045710.n5.nabble.com/Problem-with-inserting-images-after-saving-an-HSSFWorkbook-tp5710135p5710209.html
Sent from the POI - User mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
--
Flavio Cimolin
Technical Support Engineer
CD-adapco, Turin Office
phone: +39 011 562 2194 (int 413)
email: [email protected] <mailto:[email protected]>
web: http://www.cd-adapco.com
