使用java删除Excel中的'0‘和'n/a’

import java.io.FileInputStream;
import java.io.FileOutputStream;
import org.apache.poi.ss.usermodel.*;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;

String filePath = "path/to/your/excel/file.xlsx";
Workbook workbook = new XSSFWorkbook(new FileInputStream(filePath));
Sheet sheet = workbook.getSheetAt(0); // 假设要操作的是第一个工作表

for (Row row : sheet) {
    for (Cell cell : row) {
        if (cell.getCellType() == CellType.STRING) {
            String cellValue = cell.getStringCellValue();
            if (cellValue.equals("0") || cellValue.equalsIgnoreCase("n/a")) {
                cell.setCellValue(""); // 设置单元格值为空
            }
        }
    }
}

String outputFilePath = "path/to/your/output/file.xlsx";
workbook.write(new FileOutputStream(outputFilePath));
workbook.close();