Determine MS Excel file type with Apache POI

by

Promoting a comment to an answer…

If you’re going to be doing something special with the files, then rjokelai’s answer is the way to do it.

However, if you’re just going to be using the HSSF / XSSF / Common SS usermodel, then it’s much simpler to have POI do it for you, and use WorkbookFactory to have the type detected and opened for you. You’d do something like:

 Workbook wb = WorkbookFactory.create(new File("something.xls"));

or

 Workbook wb = WorkbookFactory.create(request.getInputStream());

Then if you needed to do something special, test if it’s a HSSFWorkbook or XSSFWorkbook. When opening the file, use a File rather than an InputStream if possible to speed things up and save memory.

If you don’t know what your file is at all, use Apache Tika to do the detection – it can detect a huge number of different file formats for you.

More Related Contents:

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

Leave a Comment