/** * Removes sheet at the given index * * @param index of the sheet to remove (0-based) */ @Override public void removeSheetAt(int index) { // Get the sheet to be removed XSSFSheet xSheet = _wb.getSheetAt(index); SXSSFSheet sxSheet = getSXSSFSheet(xSheet); // De-register it _wb.removeSheetAt(index); deregisterSheetMapping(xSheet); // Clean up temporary resources try { sxSheet.dispose(); } catch (IOException e) { logger.log(POILogger.WARN, e); } }
/** * Removes sheet at the given index * * @param index of the sheet to remove (0-based) */ public void removeSheetAt(int index) { XSSFSheet xSheet=_wb.getSheetAt(index); _wb.removeSheetAt(index); deregisterSheetMapping(xSheet); }
XSSFSheet tmpSheet = workbook.getSheetAt(i); if (!tmpSheet.getSheetName().equals(sheetName)) { workbook.removeSheetAt(i);
private void cleanDataSheets(XSSFWorkbook workbookTemplate) { int numberOfQueries = extraction.getQueries().size(); // DATA[maxIndex][minIndex] --> ex : DATA00, DATA01, ..., DATA10 int maxIndex = 0; int minIndex = 0; while (maxIndex < numberOfQueries) { String sheetName = DATA_SHEET_NAME + maxIndex + minIndex; Sheet sheet = workbookTemplate.getSheet(sheetName); if (sheet == null) { maxIndex++; minIndex = 0; } else { workbookTemplate.removeSheetAt(workbookTemplate.getSheetIndex(sheet)); if (minIndex == 0) { if (workbookTemplate.getSheetIndex(sheetName)== -1){ workbookTemplate.createSheet(sheetName); } } minIndex++; } } }
/** * Removes sheet at the given index * * @param index of the sheet to remove (0-based) */ @Override public void removeSheetAt(int index) { // Get the sheet to be removed XSSFSheet xSheet = _wb.getSheetAt(index); SXSSFSheet sxSheet = getSXSSFSheet(xSheet); // De-register it _wb.removeSheetAt(index); deregisterSheetMapping(xSheet); // Clean up temporary resources try { sxSheet.dispose(); } catch (IOException e) { logger.log(POILogger.WARN, e); } }
book.removeSheetAt(book.getSheetIndex(sheetName));