Apache POI - How to write to XLS in parts

Asked Mar 19 '13 at 11:02

Active Mar 19 '13 at 11:54

Viewed 234 times

I use Apache POI and I have a lot of data that I want to write to *.xls file in parts. Now I use:

FileOutputStream fileOutputStream = null;
File tmpFile = new File("blabla.xls");
Workbook workbook = null;

try {
    for(int i = 1; i <= pageNumber; i++) {            
        workbook = xlsGenerator.generateWorkbook(someData, i);
        fileOutputStream = new FileOutputStream(tmpFile);
        workbook.write(fileOutputStream);
     }
}

But it doesn't work. It always replace old data instead of appending new data to workbook. So, are there ways to write in parts?

edited Mar 19 '13 at 11:54

Dani

3,744
4
27
35

asked Mar 19 '13 at 11:02

user1048261

1

You do know that the .xls file format doesn't support appending, don't you? – Gagravarr Mar 19 '13 at 15:01
POI will allow you to open an XLS. See here: http://stackoverflow.com/questions/5836965/how-to-open-xlsx-files-with-poi-ss – Darius X. Mar 19 '13 at 21:17

Apache POI - How to write to XLS in parts

0 Answers0