++++++ POI problem

Confluence Development
#1

Thank you for your attention.

I have a custom plugin of Confluence. Users can export Excel file from some page.
Sometimes, it works smoothly. But sometimes, some errors occur.

error
error3104×1536 1.86 MB

A dependency already exists in pom.xml.

<dependency>
  <groupId>org.apache.poi</groupId>
  <artifactId>poi</artifactId>
  <version>3.1.4</version>
</dependency>

import org.apache.poi.hssf.util.CellRangeAddress;
import org.apache.poi.hssf.util.CellRangeAddressList;
#2

Hi, @tg.box.

Checking your error and comparing it with the classes you imported, there has been some discrepancies in the packages, the one you are using uses xx.poi.hssf.util.xx while the error states xx.poi.ss.util.xx. Digging in further, I decompiled poi 3.1-FINAL (I cannot find v3.1.4) and it does not have the xx.ss.xx package, hence, the error you are having. Try using the latest poi which is 3.17 (based on maven repo), I believe that should fix the CNFE.

Cheers,
Ian

1 Like
#3

Hi, @iragudo , Thank you so much.
If you decompiled poi 3.1.4, you will find that org.apache.poi.hssf.util.CellRangeAddress extends org.apache.poi.ss.util.CellRangeAddress, and the super class locates in the same jar file. But I don’t know why it can not be found while running the plugin.
Anyway, thank you so much. I will try the latest version of poi.