Hello ! I would like to work with an .ods file in Talend (Open Document Spreadsheet). I try to use tFileInputExcel composant to read it, but I have an error which says "Unable to recognize OLE stream". I also try with tFileInputDelimited but without success. Encoding does not seem to be good and talend returns me unreadable symbols. Do you have a solution for reading ODS files ?
Hi, please check Apache Tika, using it from tJava may help you. As a side note it can be interesting to review the possibility of having an optional/separately downloadable Apache Tika Talend component which would process most of the well-known file formats out of the box Sergey