Java POI the supplied data appears to be in the Office 2007+ XML

by

According to the Apache POI Quick Guide, the POIFSFileSystem (or similarly, NPOIFSFileSystem) is only used with .xls (Excel versions through 2003) documents.

The equivalent for .xlsx documents (Excel 2007+) is OPCPackage.

OPCPackage pkg = OPCPackage.open(new File("file.xlsx"));

You can create an XSSFWorkbook from the OPCPackage:

XSSFWorkbook wb = new XSSFWorkbook(pkg);

Or you can just create it directly:

XSSFWorkbook wb = new XSSFWorkbook(new File("file.xlsx"));

Generally it’s better to create the workbook using a File instead of an InputStream, to save memory.

Also, if you want code that doesn’t care whether it’s an .xls or an .xlsx:

// or "file.xlsx"
Workbook wb = WorkbookFactory.create(new File("MyExcel.xls"));

More Related Contents:

  1. Excel Cell Style issue
  2. How to load a large xlsx file with Apache POI?
  3. Processing large xlsx file
  4. How can I read numeric strings in Excel cells as string (not numbers)?
  5. Apache POI error loading XSSFWorkbook class
  6. Best language to parse extremely large Excel 2007 files [closed]
  7. How to read Excel cell having Date with Apache POI?
  8. Embed files into Excel using Apache POI
  9. Apache POI – FileInputStream works, File object fails (NullPointerException)
  10. Apache POI add a Series name into LineChart
  11. Apache poi Excel line chart points
  12. How to set axis’ labels in a Line Chart using Apache Poi
  13. Removing a row from an Excel sheet with Apache POI HSSF
  14. Apache POI autoSizeColumn Resizes Incorrectly
  15. What is the better API to Reading Excel sheets in java – JXL or Apache POI [closed]
  16. Merging cells in Excel using Apache POI
  17. Password Protected Excel File
  18. how to read exact cell content of excel file in apache POI
  19. Create Bar Chart in Excel with Apache POI
  20. How to insert a row between two rows in an existing excel with HSSF (Apache POI)
  21. Exception when writing to the xlsx document several times using apache poi 3.7
  22. Apache-POI sorting rows in excel
  23. Java POI : How to read Excel cell value and not the formula computing it?
  24. Create a password protected Excel file using Apache POI?
  25. Apache POI evaluate formula
  26. Embed files into XSSF sheets in Excel, using Apache POI
  27. Apache POI Line Chart colors
  28. Determine MS Excel file type with Apache POI
  29. Limitation while generating excel drop down list with Apache POI
  30. Make column read-only using apache poi

Leave a Comment