Excel导出时实体中没有图片类型数据报错“Can't read input file...
麻烦大神帮忙看一下问题出在哪里,谢谢~报错信息:
Can't read input file!
javax.imageio.IIOException: Can't read input file!
at javax.imageio.ImageIO.read(ImageIO.java:1301)
at org.jeecgframework.poi.excel.export.base.ExcelExportBase.createImageCell(ExcelExportBase.java:169)
at org.jeecgframework.poi.excel.export.base.ExcelExportBase.createCells(ExcelExportBase.java:114)
at org.jeecgframework.poi.excel.export.ExcelExportServer.createSheet(ExcelExportServer.java:146)
at org.jeecgframework.poi.excel.ExcelExportUtil.exportExcel(ExcelExportUtil.java:62)
at org.jeecgframework.poi.excel.view.JeecgSingleExcelView.renderMergedOutputModel(JeecgSingleExcelView.java:59)
at org.springframework.web.servlet.view.AbstractView.render(AbstractView.java:267)
at org.springframework.web.servlet.DispatcherServlet.render(DispatcherServlet.java:1221)
at org.springframework.web.servlet.DispatcherServlet.processDispatchResult(DispatcherServlet.java:1005)
at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:952)
at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:870)
at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:961)
at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:852)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:635)
at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:837)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:742)
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:52)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at com.alibaba.druid.support.http.WebStatFilter.doFilter(WebStatFilter.java:123)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.jeecgframework.core.aop.GZipFilter.doFilter(GZipFilter.java:114)
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:88)
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.springframework.orm.hibernate4.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:150)
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.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:198)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:478)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:80)
at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:624)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:342)
at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:799)
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:868)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1455)
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.lang.Thread.run(Thread.java:748)
实体信息:
/** 主键 */
@Excel(name = "主键(禁止修改)", type = 1, width = 20)
private java.lang.String id;
/** 设备编号 */
@Excel(name = "设备编号", type = 1, width = 15)
private java.lang.String equipmentNo;
/** 设备名称 */
@Excel(name = "设备名称", type = 1, width = 30)
private java.lang.String equipmentName;
/** 是否停产 */
@Excel(name = "是否停产(是/否)", type = 1, width = 15)
private java.lang.String isEol;
/** 设备单位 */
@Excel(name = "单位", type = 1, width = 10)
private java.lang.String unit;
/** 型号 */
@Excel(name = "型号", type = 1, width = 15)
private java.lang.String model;
/** 替换型号 */
@Excel(name = "替换型号", type = 1, width = 15)
private java.lang.String modelReplace;
/** 规格 */
@Excel(name = "规格", type = 1, width = 15)
private java.lang.String type;
/** 品牌 */
@Excel(name = "品牌", type = 1, width = 15)
private java.lang.String brand;
/** 供应商 */
@Excel(name = "供应商", type = 1, width = 30)
private java.lang.String supplier;
/** 系统类别1 */
@Excel(name = "系统类别1", type = 1, width = 15)
private java.lang.String sysLevelOne;
/** 系统类别2 */
@Excel(name = "系统类别2", type = 1, width = 15)
private java.lang.String sysLevelTwo;
/** 系统类别3 */
@Excel(name = "系统类别3", type = 1, width = 15)
private java.lang.String sysLevelThree;
/** 面价-->市场价 */
@Excel(name = "市场价", type=10, width = 15)
private java.math.BigDecimal facePrice;
/** 对外报价-->单价 */
@Excel(name = "单价", type=10, width = 15)
private java.math.BigDecimal quotation;
/** 设计成本 */
@Excel(name = "设计成本", type=10, width = 15)
private java.math.BigDecimal designCost;
/** 采购成本 */
@Excel(name = "采购成本", type=10, width = 15)
private java.math.BigDecimal cost;
/** 交货周期 */
@Excel(name = "交货周期", type = 1, width = 15)
private java.lang.String deliveryCycle;
/** 优选等级 */
@Excel(name = "优选等级(一等/二等/三等/四等)", type = 1, width = 15)
private java.lang.String bestLevel;
/** 是否可OEM */
@Excel(name = "是否可OEM(是/否)", type = 1, width = 15)
private java.lang.String isOrm;
/** 详细参数 */
@Excel(name = "详细参数", type = 1, width = 20)
private java.lang.String paramInfo;
/** 备注 */
@Excel(name = "备注", type = 1, width = 15)
private java.lang.String remake;
/** 备注 */
@Excel(name = "录入人", type = 1, width = 15)
private java.lang.String recorder;
/** 删除信息 */
@Excel(name = "删除信息", type = 1, width = 15)
private java.lang.String delete;
页:
[1]