SXSSF for Writing huge data on exisitng excel
I have been using apache poi for quit sometime . i have found that for writing large excel files apache asks the developer to use SXSSF .
I have tried out this but the problem is that using SXSSF it creates a new file entirly.
It allowing to read an existing xlsx and write data on that.
Since the data that needs to be appended in an existing sheet is huge because of which i am not able to use XSSF (because it takes a lot of memory).
Could anyone please help me out in this as what can be done here .