topic Re: Unable to recognize OLE stream ..While importing excel structure in Talend Studio

Unable to recognize OLE stream ..While importing excel structure

Anonymous — Sat, 16 Nov 2024 12:53:13 GMT

Hi,
I have a mapping which creates ouput as excel 2007(say FileA)
I need to create one excelinput metadata from fileA.
1.When I am going to metadata of excel and try create with this files it is giving error as "Unable to recognize OLE stream"
2.When I am going to create strcture from tinputexcel component in workbench by selecting excel 2007 option.Still I have this error.
My Talend is 4.2.
Kinldy please help out to tacle this
Sanil

Re: Unable to recognize OLE stream ..While importing excel structure

Anonymous — Tue, 07 Jun 2011 09:14:37 GMT

Hi Sanil
Can you upload a screenshot of metadata setting or send me an example file?
Best regards
Shong

Re: Unable to recognize OLE stream ..While importing excel structure

Anonymous — Tue, 07 Jun 2011 14:31:33 GMT

Hi Shong,
I figure out the issue.
My MS ecxel is 2007.
In Talend job I used the option write 2007 format but the file extension is .xls.
So texelinput componet is trying decode the file lower format but the actual content is is higher format
When I change the filename as *.xlsx it works.
Also when i got to prevous job and change the outpout file name string with .xlsx it works.
Thank you
Sanil

Re: Unable to recognize OLE stream ..While importing excel structure

Anonymous — Tue, 24 Apr 2018 13:21:01 GMT

Do save your file with the format .xlsx and check the checkbox "read excel 2007" and it works.

please check the screenshot below and let me know if the solution works.