How to read a .ods file with talend

[Anonymous]

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 ?

Thanks !!

[Anonymous]

Hi,
Could you please vote for the related feature jira issue https://jira.talendforge.org/browse/TDI-26288, thanks for your contribution in talend.
Best regards
Sabrina

[Anonymous]

Done, thanks !
if someone has a workaround I'm always interested

[Anonymous]

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

[AciD1]

The question about being able to read .ods files is _still_ open in 2022.

Even more so that the ods format is ubiquitous in the administration, and even Microsoft is supporting it in its Office suite.

It's baffling that in 2019, after 2 years without any messages nor apparent activity, the https://jira.talendforge.org/browse/TDI-26288 issue as been rejected, without any explanation.

Since you cannot get an account for the Talend Jira, you cannot do much, except adding a rant here.

Please consider adding a tFileOpenDocument component, specially since the format is open and standard.

Not doing so would be foolish.