org.apache.poi.POIXMLException: org.apache.poi.openxml4j.exceptions.InvalidFormatException:

by

You are trying to read xls with explicit implementation poi classes for xlsx.

G:\Selenium Jar Files\TestData\Data.xls

Either use HSSFWorkbook and HSSFSheet classes or make your implementation more generic by using shared interfaces, like;

Change:

XSSFWorkbook workbook = new XSSFWorkbook(file);

To:

 org.apache.poi.ss.usermodel.Workbook workbook = WorkbookFactory.create(file);

And Change:

XSSFSheet sheet = workbook.getSheetAt(0);

To:

org.apache.poi.ss.usermodel.Sheet sheet = workbook.getSheetAt(0);

More Related Contents:

  1. Reading Specific rows of an excel [closed]
  2. What does the statement Object[][] data = new Object [][] mean?
  3. How to load a large xlsx file with Apache POI?
  4. Processing large xlsx file
  5. Get Cell Value from Excel Sheet with Apache Poi
  6. How can I read numeric strings in Excel cells as string (not numbers)?
  7. Writing a large resultset to an Excel file using POI
  8. Embed files into Excel using Apache POI
  9. Apache POI add a Series name into LineChart
  10. Replacing a text in Apache POI XWPF
  11. Cannot import XSSF in Apache POI
  12. How do I set cell value to Date and apply default Excel date format?
  13. Merging cells in Excel using Apache POI
  14. Getting Exception(org.apache.poi.openxml4j.exception – no content type [M1.13]) when reading xlsx file using Apache POI?
  15. Get the cell value as how it was presented in excel
  16. how to read exact cell content of excel file in apache POI
  17. Trying to make simple PDF document with Apache poi
  18. Excel Cell Style issue
  19. Error While Reading Large Excel Files (xlsx) Via Apache POI
  20. how to add a picture to a .docx document with Apache POI XWPF in java
  21. Creating a Table of Contents for a XWPFDocument with page numbers’ indication
  22. Export to Excel JSF and PrimeFaces
  23. How to convert HSSFWorkbook to XSSFWorkbook using Apache POI?
  24. Create a password protected Excel file using Apache POI?
  25. Apache POI evaluate formula
  26. Apache POI Line Chart colors
  27. Java POI the supplied data appears to be in the Office 2007+ XML
  28. POI DataFormatter returns 2 digits year instead of 4 digits year for date cells [duplicate]
  29. Insert picture in word document
  30. java.lang.OutOfMemoryError: Java heap space while reading excel with Apache POI

Leave a Comment