Read a Input ExcelFile with image column

[Anonymous]

Hello guys,

I use the talend everyday to made some load's at my Database ( Oracle ) .

I use VBA to generate files for me, and talend to made this load to the database.

And now i'm facing a issue, because one of my automactily reports generate a excel file (xlsx) with a column who is fill by image not text. In the excel file the figure have a kind of name for the 3 differents options of the image.

I tried to read this excel with tInputExcel but obsvisualy he is not showing the values of this column who have images.

Have any possibility at the talend to read this excel file ? I can not ignore this column because his image values bring important informations.

If anybody at anytime face this problem could suggest me any alternative ?

Talend ViewColumn in excelThe subtitle of the image in excelColumn in excelColumn in excel

[fdenis]

Talend use "Apache POI class" to manage excel file. you can make you own component (or use tjava flex) to read images (and data) using Picture interface https://poi.apache.org/apidocs/dev/org/apache/poi/ss/usermodel/Picture.html

it's not a simple job to buil but I think there is no easy way to do it.