报表在导出图片后台报null

##### 版本号：
1.3.793

##### 问题描述：
在制作报表中，excel中含有图片，在进行导出excel的时候出现null,在生成pdf的时候出现Image format cannot be recognized.数据库图片后台存的是url地址

##### 错误日志&截图：
excel报错信息及截图:
10:34:00.936 [http-nio-80-exec-8] ERROR c.r.f.w.e.GlobalExceptionHandler - [notFount,67] - 访问的URL[/jmreport/exportAllExcel]发生异常null
java.lang.NullPointerException: null
	at org.jeecg.modules.jmreport.desreport.service.a.k.a(JmReportExportExcelImpl.java:1860)
	at org.jeecg.modules.jmreport.desreport.service.a.k.a(JmReportExportExcelImpl.java:306)
	at org.jeecg.modules.jmreport.desreport.service.a.k.exportExcel(JmReportExportExcelImpl.java:120)
	at org.jeecg.modules.jmreport.desreport.a.a.a(DesignReportController.java:1010)
	at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
	at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.base/java.lang.reflect.Method.invoke(Method.java:566)
	at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:190)
	at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:138)
	at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:105)
	at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:878)
	at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:792)
	at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87)
	at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1040)
	at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:943)
	at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1006)
	at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:909)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:652)
	at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:883)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:733)
	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)
    ![输入图片说明](https://images.gitee.com/uploads/images/2021/0902/103419_5318d13f_1746992.png "屏幕截图.png")

导出pdf错误信息及截图:

table的宽度：[F@c97c720
10:35:39.415 [http-nio-80-exec-25] ERROR c.r.f.w.e.GlobalExceptionHandler - [notFount,67] - 访问的URL[/jmreport/exportPdf]发生异常Image format cannot be recognized.
com.itextpdf.io.IOException: Image format cannot be recognized.
	at com.itextpdf.io.image.ImageDataFactory.createImageInstance(ImageDataFactory.java:580)
	at com.itextpdf.io.image.ImageDataFactory.create(ImageDataFactory.java:82)
	at com.itextpdf.io.image.ImageDataFactory.create(ImageDataFactory.java:91)
	at org.jeecg.modules.jmreport.desreport.b.f.a(TableRender.java:664)
	at org.jeecg.modules.jmreport.desreport.b.f.a(TableRender.java:562)
	at org.jeecg.modules.jmreport.desreport.b.f.a(TableRender.java:432)
	at org.jeecg.modules.jmreport.desreport.b.f.a(TableRender.java:272)
	at org.jeecg.modules.jmreport.desreport.service.a.l.exportPdf(JmReportExportPdfImpl.java:185)
	at org.jeecg.modules.jmreport.desreport.a.a.b(DesignReportController.java:1472)
	at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
	at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.base/java.lang.reflect.Method.invoke(Method.java:566)
	at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:190)
	at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:138)
	at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:105)
	at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:878)
	at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:792)
	at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87)
	at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1040)
	at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:943)
	at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1006)
	at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:909)

![输入图片说明](https://images.gitee.com/uploads/images/2021/0902/103553_15efc57b_1746992.png "屏幕截图.png")

##### 重现步骤：
设计新的报表，在点击导出excel和pdf报错
导出的配置为:
insert into jimu_report(api_code,create_time,name,template,del_flag,id,view_count,note,status,thumb,update_time,create_by,api_url,type,css_str,update_by,js_str,code,json_str,api_method) values (null,'2021-08-30 14:19:09','苹乳化验',0,0,'592205152940163072','60',null,null,null,'2021-09-02 10:00:51','admin',null,'datainfo',null,'admin',null,'20210830141908','{"loopBlockList":[],"area":false,"excel_config_id":"592205152940163072","printConfig":{"paper":"A4","width":210,"height":297,"definition":1,"isBackend":false,"marginX":10,"marginY":10,"layout":"portrait"},"zonedEditionList":[],"rows":{"0":{"cells":{"0":{"style":20,"rendered":"","config":"","display":"img"},"1":{"text":"","rendered":"","config":""}}},"1":{"cells":{"0":{"text":"#{test.paper_chromatography}","rendered":"","config":"","display":"img"},"1":{}}},"3":{"cells":{"0":{"text":"","rendered":"","config":""},"1":{"text":"","rendered":"","config":"","display":"img"}}},"4":{"cells":{"1":{"text":"","rendered":"","config":""}}},"5":{"cells":{"1":{"rendered":"","config":""}}},"7":{"cells":{"0":{"text":"","rendered":"","config":""},"1":{"text":"","rendered":"","config":""}}},"8":{"cells":{"3":{"text":"","rendered":"","config":""}}},"9":{"cells":{"6":{"text":"","rendered":"","config":""}}},"len":100},"dbexps":[],"dicts":[],"rpbar":{"show":true,"btnList":[]},"freeze":"A1","dataRectWidth":259,"displayConfig":{},"background":false,"name":"sheet1","autofilter":{},"styles":[{"font":{"size":15}},{"font":{"size":9}},{"font":{"size":9},"align":"center"},{"font":{"size":9},"align":"left"},{"font":{"size":9},"align":"right"},{"font":{"size":9},"align":"left","bgcolor":"#71ae47"},{"font":{"size":9},"bgcolor":"#71ae47"},{"font":{"size":9,"bold":true},"align":"left","bgcolor":"#71ae47"},{"font":{"size":9,"bold":true},"bgcolor":"#71ae47"},{"font":{"size":9,"bold":false},"align":"left","bgcolor":"#71ae47"},{"font":{"size":9,"bold":false},"bgcolor":"#71ae47"},{"font":{"size":9,"bold":false,"name":"宋体"},"align":"left","bgcolor":"#71ae47"},{"font":{"size":9,"bold":false,"name":"宋体"},"bgcolor":"#71ae47"},{"font":{"size":9,"bold":true,"name":"宋体"},"align":"left","bgcolor":"#71ae47"},{"font":{"size":9,"bold":true,"name":"宋体"},"bgcolor":"#71ae47"},{"font":{"size":15,"bold":true,"name":"宋体"},"align":"left","bgcolor":"#71ae47"},{"font":{"size":15,"bold":true,"name":"宋体"},"bgcolor":"#71ae47"},{"font":{"size":15,"bold":true,"name":"宋体"},"align":"left","bgcolor":"#71ae47","textwrap":true},{"font":{"size":15,"bold":true,"name":"宋体"},"align":"left","bgcolor":"#71ae47","textwrap":false},{"font":{"size":15,"bold":true,"name":"宋体"},"align":"center","bgcolor":"#71ae47","textwrap":false},{"font":{"size":15,"bold":true,"name":"宋体"},"align":"center","bgcolor":"#ffffff","textwrap":false}],"validations":[],"cols":{"0":{"width":259},"1":{"width":249},"len":50},"merges":[]}',null);
insert into jimu_report_db(db_code,db_ch_name,is_list,create_time,db_type,db_key,db_source,id,jimu_report_id,db_dyn_sql,is_page,update_time,tb_db_table_name,create_by,api_url,json_data,db_table_name,update_by,tb_db_key,java_type,java_value,api_method,api_convert,db_source_type) values ('test','图片测试u','1','2021-08-31 09:43:18','0',null,'592133138209103872','592498234969522176','592205152940163072','select *  from qa_malolactic_test','0','2021-08-31 09:43:18',null,'admin',null,'',null,null,null,null,null,null,'','mysql');
insert into jimu_report_db_field(create_time,widget_type,order_num,search_mode,field_text,dict_code,id,search_flag,update_time,create_by,jimu_report_db_id,widget_width,search_value,update_by,field_name,search_format) values ('2021-08-31 09:43:18','String',0,null,'id',null,'592498235045019648',null,null,'admin','592498234969522176',null,null,null,'id',null);
insert into jimu_report_db_field(create_time,widget_type,order_num,search_mode,field_text,dict_code,id,search_flag,update_time,create_by,jimu_report_db_id,widget_width,search_value,update_by,field_name,search_format) values ('2021-08-31 09:43:18','String',1,null,'sample_id',null,'592498235095351296',null,null,'admin','592498234969522176',null,null,null,'sample_id',null);
insert into jimu_report_db_field(create_time,widget_type,order_num,search_mode,field_text,dict_code,id,search_flag,update_time,create_by,jimu_report_db_id,widget_width,search_value,update_by,field_name,search_format) values ('2021-08-31 09:43:18','string',2,null,'sample_name',null,'592498235120517120',null,null,'admin','592498234969522176',null,null,null,'sample_name',null);
insert into jimu_report_db_field(create_time,widget_type,order_num,search_mode,field_text,dict_code,id,search_flag,update_time,create_by,jimu_report_db_id,widget_width,search_value,update_by,field_name,search_format) values ('2021-08-31 09:43:18','String',3,null,'sample_pot',null,'592498235166654464',null,null,'admin','592498234969522176',null,null,null,'sample_pot',null);
insert into jimu_report_db_field(create_time,widget_type,order_num,search_mode,field_text,dict_code,id,search_flag,update_time,create_by,jimu_report_db_id,widget_width,search_value,update_by,field_name,search_format) values ('2021-08-31 09:43:18','String',4,null,'sample_pot_id',null,'592498235183431680',null,null,'admin','592498234969522176',null,null,null,'sample_pot_id',null);
insert into jimu_report_db_field(create_time,widget_type,order_num,search_mode,field_text,dict_code,id,search_flag,update_time,create_by,jimu_report_db_id,widget_width,search_value,update_by,field_name,search_format) values ('2021-08-31 09:43:18','String',5,null,'malic_acid',null,'592498235208597504',null,null,'admin','592498234969522176',null,null,null,'malic_acid',null);
insert into jimu_report_db_field(create_time,widget_type,order_num,search_mode,field_text,dict_code,id,search_flag,update_time,create_by,jimu_report_db_id,widget_width,search_value,update_by,field_name,search_format) values ('2021-08-31 09:43:18','String',6,null,'inorganic_nitrogen',null,'592498235229569024',null,null,'admin','592498234969522176',null,null,null,'inorganic_nitrogen',null);
insert into jimu_report_db_field(create_time,widget_type,order_num,search_mode,field_text,dict_code,id,search_flag,update_time,create_by,jimu_report_db_id,widget_width,search_value,update_by,field_name,search_format) values ('2021-08-31 09:43:18','String',7,null,'organic_nitrogen',null,'592498235258929152',null,null,'admin','592498234969522176',null,null,null,'organic_nitrogen',null);
insert into jimu_report_db_field(create_time,widget_type,order_num,search_mode,field_text,dict_code,id,search_flag,update_time,create_by,jimu_report_db_id,widget_width,search_value,update_by,field_name,search_format) values ('2021-08-31 09:43:18','String',8,null,'paper_chromatography',null,'592498235284094976',null,null,'admin','592498234969522176',null,null,null,'paper_chromatography',null);
insert into jimu_report_db_field(create_time,widget_type,order_num,search_mode,field_text,dict_code,id,search_flag,update_time,create_by,jimu_report_db_id,widget_width,search_value,update_by,field_name,search_format) values ('2021-08-31 09:43:18','String',9,null,'remark',null,'592498235300872192',null,null,'admin','592498234969522176',null,null,null,'remark',null);
insert into jimu_report_db_field(create_time,widget_type,order_num,search_mode,field_text,dict_code,id,search_flag,update_time,create_by,jimu_report_db_id,widget_width,search_value,update_by,field_name,search_format) values ('2021-08-31 09:43:18','String',10,null,'bz1',null,'592498235372175360',null,null,'admin','592498234969522176',null,null,null,'bz1',null);
insert into jimu_report_db_field(create_time,widget_type,order_num,search_mode,field_text,dict_code,id,search_flag,update_time,create_by,jimu_report_db_id,widget_width,search_value,update_by,field_name,search_format) values ('2021-08-31 09:43:18','String',11,null,'bz2',null,'592498235388952576',null,null,'admin','592498234969522176',null,null,null,'bz2',null);
insert into jimu_report_db_field(create_time,widget_type,order_num,search_mode,field_text,dict_code,id,search_flag,update_time,create_by,jimu_report_db_id,widget_width,search_value,update_by,field_name,search_format) values ('2021-08-31 09:43:18','String',12,null,'bz3',null,'592498235414118400',null,null,'admin','592498234969522176',null,null,null,'bz3',null);

JEECG/JimuReport

内容风险标识

评论 (2)

JEECG/JimuReport .gitee-modal { width: 500px !important; }

内容风险标识