在做easypoi导出的时候遇到的一些问题
1.pom文件依赖的easypoi版本 为3.2.0版本
<!--easypo
<dependency
<groupId>cn.afterturn</groupId
<artifactId>easypoi-base</artifactId>
(version>3.2.0</version>
</dependency>
<dependency>
<groupId>cn.afterturn</groupId
<artifactId>easypoi-web</artifactId>
<version>3.2.0</version
</dependency>
<dependency>
<groupId>cn.afterturn</groupId>
<artifactId>easypoi-annotation</artifactId>
<version>3.2.0</version>
</dependency>
之后运行报错为 :java.lang.NoSuchMethodError: org.apache.poi.ss.usermodel.CellStyle.setAlignment(S)V
DConsole Debugger 三立 YEndpoints 工
at io.undertow.serylet.handlers.ServletInitialHandler$2.call(ServletInitialHandler.java:135)
at io.undertow.servlet.core.ServletRequestContextThreadSetupActions1.ca11(ServletRequestContextThreadSetupAction.java:48)
at io.undertow.servlet.core.ContextclassLoaderSetupActions1.cal1(ContextClassLoaderSetupAction.java:43)
at io.undertow.servlet.handlers.ServletInitialHandler.dispatchRequest(ServletInitialHandler.java:272)
at io.undertow.servlet.handlers.ServletInitialHandler.access$00(ServletInitialHandler.java:81)
at io.undertow.servlet.handlers.ServletInitialHandler$1.handleRequest(ServletInitialHandler.iava:104)
at io.undertow.server.Connectors.executeRootHandler(Connectors.java:364)
at io.undertow.server.HttpServerExchanges1.run(HttpServerExchange.java:830) 田 <2internal cal1s>
atjava.lang.Thread.run(Thread.java:748)
Caused by:java.lang.NoSuchMethodError:org.apache.poi.ss.usermodel.Cel1Style.setAlignment(S)V
at cn.afterturn.easypoi.excel.export.styler.ExcelExportStylerDefaultImpl.stringNoneStyle(ExcelExportStylerDefaultImpl.java:69)
at cn.afterturn.easypoi.excel.export.styler.AbstractExcelExportStyler.createstyles(AbstractExcelExportStyler.java:44)
at cn.afterturn.easypoi.excel.export.styler.ExcelExportStylerDefaultimpl.<init>(ExcelExportStylerDefaultImpl.java:31) <4internalcal1s
at cn.afterturn.easypoi.excel.export.ExcelExportService.insertDataToSheet(ExcelExportService.java:159)
at cn.afterturn.easypoi.excel.export.ExcelExportService.createSheetForMap(ExcelExportService.java:145)
at cn.afterturn.easypoi.excel.export.ExcelExportService.createSheet(ExcelExportService.java:115)
131commonframesomitted
之后在网上查证说是版本依赖问题
后将pom中相关easypoi版本改为4.2.0
<!--sasypo 自动POI依赖版本为3.15-->
一 <dependency>
<groupId>cn.afterturn</groupId>
<artifactId>easypoi-base</artifactId
<version>4.1.0</version>
</dependency>
<dependency
<groupId>cn.afterturn</groupId
<artifactId>easypoi-web</artifactId>
<version>4.1.0</version
一 </dependency>
<dependency
<groupId>cn.afterturn</groupId>
<artifactId>easypoi-annotation</artifactId
<version>4.1.0</version>
</dependency>
<!--sasypo 自动POI依赖版本为3.15-->
一 <dependency>
<groupId>cn.afterturn</groupId>
<artifactId>easypoi-base</artifactId
<version>4.1.0</version>
</dependency>
<dependency
<groupId>cn.afterturn</groupId
<artifactId>easypoi-web</artifactId>
<version>4.1.0</version
一 </dependency>
<dependency
<groupId>cn.afterturn</groupId>
<artifactId>easypoi-annotation</artifactId
<version>4.1.0</version>
</dependency>
之后报错有变化变成了数组下标越界异常 :java.lang.IndexOutOfBoundsException: Index: 0, Size: 0
at 1o.undertow.servlet.handlers.ServletinitialHandler$2.call(ServletInitialHandler.java:135)
at io.undertow.serylet.core.ServletRequestContextThreadsetupActions1.cal1(ServletRequestContextThreadSetupAction.java:48)
at io.undertow.servlet.core.ContextclassLoaderSetupActions1.cal1(ContextclassLoaderSetupAction.java:43)
IG
at io.undertow.servlet.handlers.ServletInitialHandler.dispatchRequest(ServletInitialHandler.java:272)
at io.undertow.servlet.handlers.ServletInitialHandler.access$00(servletInitialHandler.java:81)
at io.undertow.servlet.handlers.ServletInitialHandlers1.handleRequest(ServletInitialHandler.java:104)
at io.undertow.server.Connectors.executeRootHandler(Connectors.java:364)
at io.undertow.server.HttpServerExchanges1.run(HttpServerExchange.java:830) <2internalcal1s
at java.lang.Thread.run(Thread.java:748)
Caused by: java.lang.IndexOutOfBoundsException:Index:,Size:
atjav L
at java.util.ArrayList.get(ArrayList.java:433)
at cn.afterturn.easypoi.excel.export.base.BaseExportService.createCel1s(BaseExportService.java:72)
at cn.afterturn.easypoi.excel.export.ExcelExportService.insertDataToSheet(ExcelExportService.java:249)
at cn.afterturn.easypoi.excel.export.ExcelExportService.createSheetForMap(ExcelExportService.java:206)
at cn.afterturn.easypoi.excel.export.ExcelExportService.createSheet(ExcelExportService.java:176)
129common frames omitted
希望能帮帮忙,非常感谢!!