[Java / Spring] Log4j2 could not find... / org.apache.poi.poifs.filesystem.OfficeXmlFileException: The supplied data appears to be in the Office 2007+ XML

엑셀 파일을 자바와 스프링을 활용하여 엑셀파일의 데이터를 출력 하는 과정에서 아래의 에러들이 생겼다 

 

 

ERROR StatusLogger Log4j2 could not find a logging implementation. Please add log4j-core to the classpath. Using SimpleLogger to log to the console...

Exception in thread "main" org.apache.poi.poifs.filesystem.OfficeXmlFileException: The supplied data appears to be in the Office 2007+ XML. You are calling the part of POI that deals with OLE2 Office Documents. You need to call a different part of POI to process this data (eg XSSF instead of HSSF)

at org.apache.poi.poifs.storage.HeaderBlock.<init>(HeaderBlock.java:128)
at org.apache.poi.poifs.storage.HeaderBlock.<init>(HeaderBlock.java:115)
at org.apache.poi.poifs.filesystem.POIFSFileSystem.<init>(POIFSFileSystem.java:326)
at org.apache.poi.hssf.usermodel.HSSFWorkbook.<init>(HSSFWorkbook.java:431)
at org.apache.poi.hssf.usermodel.HSSFWorkbook.<init>(HSSFWorkbook.java:411)
at com.test.test1.common.ExcelRead.xlsToExcelVoList(ExcelRead.java:38)
at com.test.test1.common.MainApp.main(MainApp.java:12)

 

해결

---

log4j2 관련 라이브러리를 dependency에 추가하지 않았기 때문에 추가 해 주었다

(참조  : https://stackoverflow.com/questions/71970035/java-lang-nosuchmethoderror-org-apache-logging-log4j-logger-atdebug-with-poi)

 

에러에서 바로 볼 수 있듯이 xls를 읽는 과정에서 HSSF를 XSSF로 바꿔달라고 해서 바꿔주었더니 읽기 성공