I was unable to read the Excel file from my pentaho ETL server repository. I get this error:
unable to recognize OLE stream
What does that error mean?
Asked
Active
Viewed 1,405 times
0
halfer
- 19,824
- 17
- 99
- 186
aditya goud
- 15
- 6
-
Have you checked if the file is in the right format? ie. csv saved as xls. – Adrian Sep 07 '18 at 06:20
-
1Yeah, thank you so much @Adrian it worked. The xml page was saved as xls. SO, it's working now. Thanks alot – aditya goud Sep 07 '18 at 12:51
-
Glad I could help! – Adrian Sep 10 '18 at 04:23
2 Answers
0
See the solution in comments.
The file contained an XML page that was saved as an .xls file. Converting this file solved the issue.
Adrian
- 442
- 4
- 15
0
On double clicking the Microsoft Excel Input, change the Spread Sheet Type(Engine) as Excel 2007 instead of Excel 97-2003 which will be the default selected one, now you can add your excel file and the fields will be generated.
-
This mybe usefull but still does not answer the question `What does that error mean?` please provide more details about the fix you are proposing – phoenixstudio Jan 18 '21 at 11:20