Handling image in exel template from data type byte array

Support
#1

For Report generation, I can not display image(logo) in my exel file. I perform value format as ${image:300x300} but i am getting a error:

ReportingException: An error occurred while inserting bitmap to xlsx file Report name [Date Wise In-Out Missing]
Unable to get image from [B@72fd4446
no protocol: [B@72fd4446

image
my jpql query is:

select c.name as companyName,
       c.address as address,
       c.compLogo as compLogo
from mdg_Company c
where c = ${compName}

Template for Date Wise In-Out Missing Report (1).xlsx (18.0 KB)

#3

Hello,

Basically, simplest solution to convert image to base64, I found same issue as you have: Report Image HTML

The solution is to use groovy band and base64 converter