How to import images from excel ?

2
Hi Team, I need to import one excel file in which one column contains images. what needs to be done to implement this? Thanks in adv
asked
2 answers
2

Are the images inserted as image or as a base64 string?

In the first case; no clue how to approach this, as images inserted in an excel aren't linked to a particular cell.

Second case: you can use Base64DecodeToFile of the Community commons module

answered
1

Excel reading is done via the Apache POI java library. Both the default Mendix functionality as well as Excel Exporter module use this library.

Probably easiest to create a separate java action to read this from the imported Excel. See an example code snippet and especially the answer from Apache POI guru Axel Richter. 

fetch-image-from-excel-using-java

answered