Spring上传Excel后Apache POI提示文件损坏或格式异常求助

Hey there, let's dig into this annoying issue where your Excel file works locally but throws "corrupted or invalid format" errors after upload with Spring and POI 3.17. I've run into similar headaches before—here are the most likely fixes to try:

1. Confirm the Uploaded File is Complete #

First up, make sure the file isn't getting truncated mid-upload. Sometimes Spring's default multipart settings are too strict, cutting off larger files before they fully reach your server.

• Add a quick check in your controller to compare the uploaded file size with your local copy:

  @PostMapping("/uploadExcelFile")
  public String handleUpload(@RequestParam("file") MultipartFile file) {
      System.out.println("Uploaded file size: " + file.getSize() + " bytes");
      // Your parsing logic here
  }
  

• If the sizes don't match, update your application.properties to increase upload limits:

  spring.servlet.multipart.max-file-size=15MB
  spring.servlet.multipart.max-request-size=15MB
  

2. Ensure File Format Compatibility with POI 3.17 #

POI 3.17 has specific support limits for Excel formats—let's rule out compatibility gaps:

• For .xls (HSSF): Double-check the file wasn't saved in "compatibility mode" with newer Excel features that break older parsers.
• For .xlsx (XSSF): If the file was created in Excel 2016+, it might use minor modern features POI 3.17 doesn't recognize. Try re-saving the file as Excel 2007-2019 Workbook (the standard xlsx format) and re-upload.
• Avoid files generated by non-Microsoft tools (WPS, online exporters)—these often have non-standard markup that trips up POI.

3. Fix Stream Handling in Your Parsing Code #

Most "corrupted file" errors stem from mishandling the input stream. Follow these best practices:

• Use try-with-resources to auto-close streams and prevent leaks that can cause parsing failures:

  try (InputStream inputStream = file.getInputStream()) {
      Workbook workbook;
      String fileName = file.getOriginalFilename();
      if (fileName.endsWith(".xlsx")) {
          workbook = new XSSFWorkbook(inputStream);
      } else if (fileName.endsWith(".xls")) {
          workbook = new HSSFWorkbook(inputStream);
      } else {
          throw new IllegalArgumentException("Unsupported file type");
      }
      // Process your workbook here
  } catch (IOException e) {
      e.printStackTrace();
      // Handle the error gracefully
  }
  

• Never re-use the same input stream—once it's read, it can't be reliably read again for multipart files.

4. Fix File Name Encoding Issues #

If your file name has special characters (Chinese, spaces, accents), Spring might parse it incorrectly, leading to wrong format detection. Normalize the file name first:

String originalFileName = file.getOriginalFilename();
String normalizedFileName = new String(originalFileName.getBytes("ISO-8859-1"), "UTF-8");

5. Test with a Minimal Excel File #

Create a super simple Excel file (just 2-3 rows of plain text, no formulas, macros, or images) and upload it. If this works, your original file likely has complex content that POI 3.17 can't handle. Options here:

• Upgrade to a newer POI version (4.x or 5.x have better support for modern Excel features)
• Preprocess the original file to remove problematic elements (like macros or custom formatting)

内容的提问来源于stack exchange，提问作者Ian Nato