Read a Input ExcelFile with image column

Anonymous — Sat, 16 Nov 2024 04:39:12 GMT

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

Re: Read a Input ExcelFile with image column

fdenis — Wed, 18 Sep 2019 08:21:01 GMT

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.

topic Re: Read a Input ExcelFile with image column in Talend Studio

Read a Input ExcelFile with image column

Re: Read a Input ExcelFile with image column