Getting Exception(org.apache.poi.openxml4j.exception – no content type [M1.13]) when reading xlsx file using Apache POI?

by

The error is telling you that POI couldn’t find a core part of the OOXML file, in this case the content types part. Your file isn’t a valid OOXML file, let alone a valid .xlsx file. It is a valid zip file though, otherwise you’d have got an earlier error

Can Excel really load this file? I’d expect it wouldn’t be able to, as the exception is most commonly triggered by giving POI a regular .zip file! I suspect your file isn’t valid, hence the exception

.

Update: In Apache POI 3.15 (from beta 1 onwards), there’s a more helpful set of Exception messages for the more common causes of this problem. You’ll now get more descriptive exceptions in this case, eg ODFNotOfficeXmlFileException and OLE2NotOfficeXmlFileException. This raw form should only ever show up if POI really has no clue what you’ve given it but knows it’s broken or invalid.

More Related Contents:

  1. Reading Specific rows of an excel [closed]
  2. How to load a large xlsx file with Apache POI?
  3. How can I read numeric strings in Excel cells as string (not numbers)?
  4. Apache POI error loading XSSFWorkbook class
  5. Docx to Pdf Converter in java
  6. Embed files into Excel using Apache POI
  7. Apache POI – FileInputStream works, File object fails (NullPointerException)
  8. Apache poi Excel line chart points
  9. How to set axis’ labels in a Line Chart using Apache Poi
  10. Cannot import XSSF in Apache POI
  11. Removing a row from an Excel sheet with Apache POI HSSF
  12. Apache POI autoSizeColumn Resizes Incorrectly
  13. How do I set cell value to Date and apply default Excel date format?
  14. Basic Excel currency format with Apache POI
  15. how to read exact cell content of excel file in apache POI
  16. Alternative to deprecated getCellType
  17. Create Bar Chart in Excel with Apache POI
  18. Excel Cell Style issue
  19. How to insert a row between two rows in an existing excel with HSSF (Apache POI)
  20. Apache POI Streaming (SXSSF) for Reading
  21. Exception when writing to the xlsx document several times using apache poi 3.7
  22. How to Cache InputStream for Multiple Use
  23. Export to Excel JSF and PrimeFaces
  24. Create a password protected Excel file using Apache POI?
  25. Embed files into XSSF sheets in Excel, using Apache POI
  26. How to check if an excel cell is empty using Apache POI?
  27. Determine MS Excel file type with Apache POI
  28. How to avoid java.lang.NoSuchMethodError: org.apache.poi.util.IOUtils.copy(Ljava/io/InputStream;Ljava/io/OutputStream;) in Apache POI
  29. Limitation while generating excel drop down list with Apache POI
  30. Make column read-only using apache poi

Leave a Comment