[简单]poi删除excel 2007 sheet页

      见代码:

      

// 删除指定sheet页
	public void removeSheetsByName(String sheetName, Workbook wb) {
		if (wb.getSheet(sheetName) == null) {
			return;
		}
		wb.removeSheetAt(wb.getSheetIndex(sheetName));
	}

	/**
	 * @Description: 删除其他sheet页,存在部分图片无引用但未被删除的问题
	 */
	public void removeOtherSheets(String sheetName, XSSFWorkbook wb) {
		if (wb.getSheet(sheetName) == null) {
			return;
		}
		if (!wb.getSheetAt(0).getSheetName().equals(sheetName)) {
			Sheet sheet = wb.cloneSheet(wb.getSheetIndex(sheetName));
			wb.setSheetOrder(sheet.getSheetName(), 0);
		}
		for (int i = wb.getNumberOfSheets() - 1; i >= 1; i--) {
			wb.removeSheetAt(i);
		}
		wb.setSheetName(0, sheetName);
	}

 

      全文完。