I am using Aspose Cells for Java.
Here is what i do:
I have a Workbook of huge size.
I need to edit just a single sheet of that workbook and write the workbook back to disk.
Since reading the whole workbook takes quite some time, I am using:
to load just the sheet which I want to edit.
Now here is the problem.
If I load only the sheet i need and write back the workbook, the rest of the sheets data are gone.
And if I load the entire Workbook, it takes considerable amount of time which affects the performance.