用jett导出到Excel时出错500

Question

当我用jett导出Excel时，我会得到这个错误。因为这个我损失了几天时间

Maven：

    <!-- https://mvnrepository.com/artifact/org.apache.poi/poi-ooxml -->
    <dependency>
        <groupId>org.apache.poi</groupId>
        <artifactId>poi-ooxml</artifactId>
        <version>5.0.0</version>
    </dependency>

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

    <dependency>
        <groupId>com.github.ozlerhakan</groupId>
        <artifactId>poiji</artifactId>
        <version>3.1.7</version>
    </dependency>

    <!-- https://mvnrepository.com/artifact/net.sf.jett/jett-core -->
    <dependency>
        <groupId>net.sf.jett</groupId>
        <artifactId>jett-core</artifactId>
        <version>0.11.0</version>
    </dependency>

代码：

public <S, T> void exportToExecl(HttpServletResponse response, List<S> listError, String template) {

    try {
        Map<String, Object> beans = new HashMap<>();
        beans.put("excel",listError);

        Resource resource = new ClassPathResource("/templates/" + template);
        InputStream fileIn =new BufferedInputStream(resource.getInputStream());

        ExcelTransformer transformer = new ExcelTransformer();
        Workbook workbook = transformer.transform(fileIn, beans);

        response.setHeader("Content-Disposition", "attachment; filename=Erorr_" + template);
        ServletOutputStream out = response.getOutputStream();

        workbook.write(out);
        out.flush();
        out.close();

    } catch (IOException e) {
        throw new InfoCityException(e.getMessage());
    } catch (InvalidFormatException e) {
        throw new InfoCityException(e.getMessage());
    }
}

消息错误：

{
    "timestamp": "2022-04-22T03:44:01.120+00:00",
    "status": 500,
    "error": "Internal Server Error",
    "message": "'int org.apache.poi.ss.usermodel.Cell.getCellType()'"
}

Answer 1

正如您在评论中已经提到的，问题在于您使用的是ApachePOI5.0，而JETT 0.11.0需要运行POI 3.14。

为了支持最新的POI版本，在JETT论坛上进行了讨论，但据我所知，什么也没有发生。