[Bug 57666] SXSSFWorkbook.dispose() does not delete temp xml files of sheets copied from an existing XSSFWorkbook at construction time

[bugzilla]

https://bz.apache.org/bugzilla/show_bug.cgi?id=57666

--- Comment #4 from Yaniv Kunda <ya...@kundas.net> ---
I also found a workaround applicable for my situation -

This is my problematic code:

            // open a template with a single sheet
            XSSFWorkbook template = new XSSFWorkbook("data/template.xlsx");
            SXSSFWorkbook wb = new SXSSFWorkbook(template);
            try {
                Sheet templateSheet = template.getSheetAt(0);
                // read some stuff from the template
                ...

                // create new sheet
                Sheet sheet = wb.createSheet("Data");

                // remove sheet copied from template
                wb.removeSheetAt(0);

                // fill the new sheet with data
                ...

                wb.write(out);
            } finally {
                wb.dispose();
            }

The workaround is to call wb.dispose() before creating the new sheet.

-- 
You are receiving this mail because:
You are the assignee for the bug.

---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org
For additional commands, e-mail: dev-h...@poi.apache.org