I’m using Apache poi 5.2.3 in a neo4j plugin for neo4j 4.4.30 using openjdk temurin-11.0.22. We use commons-io 2.15.1.

I originally used import org.apache.poi.xssf.usermodel.XSSFWorkbook to export data to Excel (because that’s what business users want; you know how it is…), but I’m trying to switch to org.apache.poi.xssf.streaming.SXSSFWorkbook to support streaming (because business users want more data).

When I switch those two classes, I get

NoSuchMethodError: 'java.nio.charset.Charset org.apache.commons.io.Charsets.toCharset(java.nio.charset.Charset, java.nio.charset.Charset)'

This makes no sense, because commons-io 2.15.1 does contain that function.

I do notice SXSSFWorkbook does something with CharSets that XSSFWorkbook doesn’t (not sure why), but I can’t find the exact call. Even so, commons-io 2.15.1 should be fine for poi 5.2.3 as fa as I can tell.

So I’m baffled why this isn’t working. I’m clearly not enough of a dependency guru to figure this out. Any idea where I should be looking?