Read a Input ExcelFile with image column

Four Stars

Read a Input ExcelFile with image column

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 ?

 

 

 

 

Capture.4PNG.PNGTalend ViewCapture.PNGColumn in excelCapture1.PNGThe subtitle of the image in excelCapture2.PNGColumn in excelCapture3.PNGColumn in excel

Twelve Stars

Re: Read a Input ExcelFile with image column

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.

Francois Denis

Tag as "solved" for others! Kudos to thanks!

2019 GARTNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

Best Practices for Using Context Variables with Talend – Part 2

Part 2 of a series on Context Variables

Blog

Best Practices for Using Context Variables with Talend – Part 1

Learn how to do cool things with Context Variables

Blog

Migrate Data from one Database to another with one Job using the Dynamic Schema

Find out how to migrate from one database to another using the Dynamic schema

Blog