|Component:||HSSF||Assignee:||POI Developers List <dev>|
Description Stephen 2003-02-27 12:21:41 UTC
I am using 1.5.1 In Excel, I create a "template" xls file, with 14 worksheets. Sheet 0 has stuff on it. The other 13 are blank. Then, using POI API, I put some stuff on sheets 1 and 2. Then, I remove the sheets that are not being used. When I remove 5 sheets, it works ok. When I remove 6 sheets, it works ok. When I remove 7 sheets, it works ok. When I remove 8 or more sheets, the results is that the spreadsheet opens with only the initial sheet 0, and no other tabs. I am removing from the highest sheets, downward. I look for the name of the sheet and find the index. Then I remove the sheet based on the index. There do not seem to be any "exceptions" created. WHEN I LIMIT THE INITIAL NUMBER OF SHEETS TO 11, IT WORKS FINE. FORTUNATELY, THAT SUFFICES FOR ME FOR NOW.
Comment 1 Jason Height 2003-02-27 21:12:48 UTC
Upload your template file (use create attachment) and a simple piece of code that uses your template to demonstrate the problem.
Comment 2 Andy Oliver 2003-07-24 15:51:13 UTC
info asked for but not received.