Can I ask what you have tried with SXXSF? I have absolutely no experience
with this API but the javadoc does seem to suggest that it is possible to
work with an existing file, for example;
"public SXSSFWorkbook(XSSFWorkbook workbook,
int rowAccessWindowSize)
Constructs an workbook from an existing workbook. "
and there is a method to obtain a sheet from the workbook using either it's
name or index number and I would assume - even though that is VERY dangerous
- that it is possible to get at the index of the last row on the sheet and
then append further rows to it. If that is how you can then proceed, I do
not know but it might be better if you could create a very simple test case
- some code that atempts to op0en an existing workbook using SXSSF and then
append data to a sheet - that illustrates your problem and then post it here
so that others with far more knowledge of this strand of the API than I can
comment.
--
View this message in context:
http://apache-poi.1045710.n5.nabble.com/SXSSF-for-Writing-huge-data-on-exisitng-excel-tp5712656p5712660.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]
