"Read Excel and Data Import Error Unable to Recognize OLE Stream"

robben
robben New Altair Community Member
edited November 5 in Community Q&A
Hi,
i have problems reading Excel files. I've tested simple single procedure with Read Excel operator working with file forced to be saved in Excel 97/2003 and it works ok.
But I should have to loop to read many of them (some hundrends) and they are named .xls  (but i think they are in Excel 2007/2010 new format) and i don't have any other way to save them.
When i try to test reading one of them i got Data Import Error that says "Error occurred importing ...filename... jxl.read.biff.BiffException: Unable to recognize OLE Stream".
Is there any step to solve the problem without converting all the hundreds of input files i have?
Thanks a lot

Tagged:

Answers

  • MariusHelf
    MariusHelf New Altair Community Member
    Does it work if you rename the files to.xlsx?

    Would it be an option to rename all files and then run the RapidMiner process? Of course that would not have to happen by hand, but you can also use RapidMiner or some command line magic to batch-rename all files.

    Best regards,
    Marius
  • robben
    robben New Altair Community Member
    Ciao Marius,
    thanks for your interest. I have tried renaming the file in .xlsx but it countinues to give same error
    Any other solution?
    Roberto
  • MariusHelf
    MariusHelf New Altair Community Member
    Ciao Roberto,

    questo é strano, I suppose you can open the files without any problems in Excel? Can you mail me one of the files in question such that we can investigate the problem? In this case I would send you my mail address via PM.

    Saluti,
    Marius
  • MariusHelf
    MariusHelf New Altair Community Member
    Roberto, the files are actually HTML files. You can see that when you open them in a plain text editor.

    Best regards,
    Marius

Categories