见代码:
// 删除指定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);
}
全文完。