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 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.
Tag as "solved" for others! Kudos to thanks!
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Part 2 of a series on Context Variables
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema