How to export Image to Excel

Support
#1

Hi
I’m using Jmix 2.5, and I want to export logo in excel using the ExcelEportAction.

Here is my code :

companiesDataGridExcelExportAction.addColumnValueProvider(“logo”, context → {
Company comp = context.getEntity();
try {
return Base64ImageTools.getBase64Image(fileStorage,comp.getLogo());
} catch (IOException e) {
throw new RuntimeException(e);
}
});

But I encounter an error.
Is it possible to export Image in cell?
Best regards
Alexandre

#2

Hi,

When exporting to Excel, each cell is represented by org.apache.poi.ss.usermodel.Cell class. As far as I see, it doesn’t support images as cell values.

Regard,
Gleb