One Star

Unable to recognize OLE stream ..While importing excel structure

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
3 REPLIES
Community Manager

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

Hi Sanil
Can you upload a screenshot of metadata setting or send me an example file?
Best regards
Shong
----------------------------------------------------------
Talend | Data Agility for Modern Business
One Star

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

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
Five Stars

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

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.read_excel.PNG