我使用了 Apache POI 3.17，在 Java 中使用 XSSFDataValidationHelper 来为 .xlsx 文件中的日期和数值等数据添加验证。但每当我使用 MS-Excel 打开文件时，它显示：
“我们发现了<Excel_filename>中的一些内容问题。您是否希望我们尽量恢复文件？如果您信任此工作簿的来源，请点击“是”。
当我查找此错误时，我得知，当文件部分损坏或完全损坏时，就会发生此问题。
这个问题只会出现在那些使用了上述任何类型数据验证的 .xlsx 文件中，但如果我在 Linux 环境中打开该 .xlsx 文件，则不会出现此问题。
附注：我在最后关闭了工作簿和FileOutputStream，至少在工作簿下创建了一个工作表（显然）
以下是用于数据验证的代码片段：
    `XSSFDataValidationHelper dataValidationHelper = new XSSFDataValidationHelper(sheet);
    
    XSSFDataValidationConstraint numberValidationConstraint =
        (XSSFDataValidationConstraint)
            dataValidationHelper.createNumericConstraint(
                XSSFDataValidationConstraint.ValidationType.DECIMAL,
                XSSFDataValidationConstraint.OperatorType.BETWEEN,
                String.valueOf(Double.MIN_VALUE),
                String.valueOf(Double.MAX_VALUE)
            );
    
    CellRangeAddressList addressList = new CellRangeAddressList(
        2, 2000, columnCounter, columnCounter);
    XSSFDataValidation numberValidation = (XSSFDataValidation) dataValidationHelper.createValidation(
        numberValidationConstraint, addressList);
    numberValidation.setSuppressDropDownArrow(false);
    numberValidation.setShowErrorBox(true);
    numberValidation.createErrorBox("Invalid data", "Only numbers are allowed");
    sheet.addValidationData(numberValidation);`

DataValidationConstraint numberValidationConstraint = dataValidationHelper.createNumericConstraint(
 DataValidationConstraint.ValidationType.DECIMAL,
 DataValidationConstraint.OperatorType.BETWEEN,
 "-9.99999999999999E307",
 "9.99999999999999E307"
);

=ISNUMBER(OFFSET($A$1,ROW()-1,COLUMN()-1))

import java.io.FileOutputStream;
import org.apache.poi.ss.usermodel.*;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.ss.util.CellRangeAddressList;
class CreateExcelDataValidation {
 public static void main(String[] args) throws Exception {
  //Workbook workbook = new HSSFWorkbook();
  Workbook workbook = new XSSFWorkbook();
  Sheet sheet = workbook.createSheet();
  int columnCounter = 0;
  int fromRow = 2;
  int toRow = 2000;
  DataValidationHelper dataValidationHelper = sheet.getDataValidationHelper();
  /*
  DataValidationConstraint numberValidationConstraint = dataValidationHelper.createNumericConstraint(
   DataValidationConstraint.ValidationType.DECIMAL,
   DataValidationConstraint.OperatorType.BETWEEN,
   //String.valueOf(Double.MIN_VALUE),
   //String.valueOf(Double.MAX_VALUE)
   "-9.99999999999999E307",
   "9.99999999999999E307"
  );
  */
  DataValidationConstraint numberValidationConstraint = dataValidationHelper.createCustomConstraint(
   "ISNUMBER(OFFSET($A$1,ROW()-1,COLUMN()-1))"
  );
  CellRangeAddressList addressList = new CellRangeAddressList(fromRow, toRow, columnCounter, columnCounter);
  DataValidation numberValidation = dataValidationHelper.createValidation(numberValidationConstraint, addressList);
  numberValidation.setShowErrorBox(true);
  numberValidation.createErrorBox("Invalid data","Only numbers are allowed");
  sheet.addValidationData(numberValidation);
  FileOutputStream out = null;
  if (workbook instanceof HSSFWorkbook) {
   out = new FileOutputStream("CreateExcelDataValidation.xls");
  } else if (workbook instanceof XSSFWorkbook) {
   out = new FileOutputStream("CreateExcelDataValidation.xlsx");
  }
  workbook.write(out);
  workbook.close();
  out.close();
 }
}