HSSFWorkbook is imported, XSSFWorkbook is not, why? Apache Poi 5.0.0

0
votes

SCREENSHOT HSSFWorkbook is imported, XSSFWorkbook is not, why? I make an application with reading .xls and .xlsx files with Apache poi 5.0.0. Here are my imports. Here are my build.gradle. Maybe I need to connect multidex?

1
javaapache-poiopenxml

1 Answers

2
votes

You're missing the OOXML schema. Add the following to your build.gradle dependencies (additionally to the already existing org.apache.poi.poi dependency):

implementation: 'org.apache.poi', name: 'poi-ooxml', version: '5.0.0'