After removing a sheet from an excel workbook with Apache Poi, a sheet remains?

1
votes

I'm using workbook.removeSheetAt() to remove a certain named sheet from a workbook. However, the workbook contains a new sheet called "Sheet3" after writing it out to disk. What gives? I'm not creating this new sheet anywhere in my code. Note: I am using XSSFWorkbook and all the other XSSF stuff.

Some more info: Here is a snippet from workbook.xml inside the output xlsx. I am deleting sheet with index=2, ostensibly sheetId=3. The template workbook I am starting with only has four sheets.

<sheets>
    <sheet r:id="rId1" sheetId="1" name="Sheet1"/>
    <sheet r:id="rId2" sheetId="2" name="Params" state="hidden"/>
    <sheet r:id="rId4" sheetId="4" name="Warnings" state="hidden"/>
    <sheet r:id="rId3" sheetId="5" name="Sheet3"/>
</sheets>
1
javaapacheexcelapache-poi
Remember you cannot have a workbook without sheets... – Tiago Cardoso

1 Answers

2
votes

Apache POI is using index based sheets (kinda like an array). If you have a sheet at a position that is greater than x, there must exist a sheet at position x even if it is blank. You could try moving the sheets where n > x to position n - 1 using setSheetOrder

Seems like there is a bug report similar to this: Bug Report

What about hiding the sheet: setSheetHidden