java poi删除特定行_poi导出时删除行操作Minumum row number is 0

最新推荐文章于 2021-10-30 16:02:59 发布

weixin_39608116

最新推荐文章于 2021-10-30 16:02:59 发布

阅读量509

点赞数

文章标签： java poi删除特定行

本文链接：https://blog.csdn.net/weixin_39608116/article/details/115039947

版权

在对excel数据进行导出操作的时候报java.lang.IllegalArgumentException: Minumum row number is 0错误

具体错误如下：

删除行数17

最大行数47

删除行数16

最大行数46

删除行数15

最大行数45

删除行数14

最大行数44

删除行数13

最大行数43

删除行数12

最大行数42

java.lang.IllegalArgumentException: Minumum row number is 0

at org.apache.poi.ss.util.CellRangeAddressBase.validateRow(CellRangeAddressBase.java:63)

at org.apache.poi.ss.util.CellRangeAddressBase.validate(CellRangeAddressBase.java:51)

at org.apache.poi.xssf.usermodel.XSSFSheet.addMergedRegion(XSSFSheet.java:270)

at org.apache.poi.xssf.usermodel.helpers.XSSFRowShifter.shiftMerged(XSSFRowShifter.java:84)

at org.apache.poi.xssf.usermodel.XSSFSheet.shiftRows(XSSFSheet.java:2365)

at org.apache.poi.xssf.usermodel.XSSFSheet.shiftRows(XSSFSheet.java:2306)

at com.basis.utils.ExcelUtils.excel(ExcelUtils.java:449)

at com.basis.utils.Utils.downloadOnly(Utils.java:374)

at com.mortgage.controller.order.OrderController$ThreadForQiniuDownload.run(OrderController.java:872)

at com.mortgage.controller.order.OrderController.QiniuExcel(OrderController.java:840)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

at java.lang.reflect.Method.invoke(Method.java:498)

at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:220)

at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:134)

at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:116)

at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:827)

at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:738)

at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:85)

at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:963)

at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:897)

at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:970)

at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:872)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:660)

at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:846)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:741)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)

at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)

at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:197)

at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)

at org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:61)

at org.apache.shiro.web.servlet.AdviceFilter.executeChain(AdviceFilter.java:108)

at org.apache.shiro.web.servlet.AdviceFilter.doFilterInternal(AdviceFilter.java:137)

at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125)

at org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:66)