Package should contain a content type part [M1.13]异常的解决方式
在上传excel文件中,使用Java的POI解析excel文件,解析中出现了标题所示错误信息。
- 解决方案:
使用WorkbookFactory创建Workbook。
Workbook workbook = null;
try {
workbook = WorkbookFactory.create(in);
} catch (Exception e) {
return "你的excel版本目前poi解析不了!";
}
- 打开 WorkbookFactory.create 源代码:
public static Workbook create(InputStream inp) throws IOException, InvalidFormatException {
if (!inp.markSupported()) {
inp = new PushbackInputStream(inp, 8);
}
if (POIFSFileSystem.hasPOIFSHeader(inp)) {
return new HSSFWorkbook(inp);
}
if (POIXMLDocument.hasOOXMLHeader(inp)) {
return new XSSFWorkbook(OPCPackage.open(inp));
}
throw new IllegalArgumentException("Your InputStream was neither an OLE2 stream, nor an OOXML stream");
}