java - 如何在 Excel 中取消扩展警告

Question

我已经从我的 JTable 创建了一个 Excel 文件。创建它的同一个按钮也会打开它。但它给出了提示:

The file you are trying to open is in a different format than specified by the file extension. Verify that the file is not corrupted and is from a trusted user before opening the file. Do you want to open the file?

当我单击“确定”时，文件打开。我正在使用 Office 2007 并将文件保存为 .xls。有没有办法从代码级别停止提示？下面是创建和打开文件的代码:

if (obj == btnExport) {
  File f = new File("Student Results");
  f.mkdir();
  try {
    TableModel model = DataBaseTable.getModel();
    FileWriter excel = new FileWriter("Student Results/" + exam  + "_"+ level + "_" + year + ".xls");
    for(int i = 0; i < model.getColumnCount(); i++){
      excel.write(model.getColumnName(i) + "\t");
    }

    excel.write("\n");

    for(int i=0; i< model.getRowCount(); i++) {
      for(int j=0; j < model.getColumnCount(); j++) {
        excel.write(model.getValueAt(i,j).toString()+"\t");
      }
      excel.write("\n");
    }

    excel.close();
    JOptionPane.showMessageDialog(this, "File Exported to " + f.getAbsolutePath(),
    "Success", JOptionPane.INFORMATION_MESSAGE);
    File opn = new File("Student Results/" + exam  + "_"+ level + "_" + year + ".xls");
    Desktop.getDesktop().open(opn);

  } catch (Exception se) {
    JOptionPane.showMessageDialog(this, se,
    "Error", JOptionPane.ERROR_MESSAGE);
  }
}

Answer 1

This MSDN提供了几种方法(组策略或注册表操作)来抑制警告，但我认为两者都不是特别实用。

我建议改为制作 CSV，因为您只是在编写文件。这些也由 Excel 打开。我相信您所要做的就是用逗号替换代码中的两个 \t。