Pages: [1]
  Print  
Author Topic: Read Excel and Data Import Error Unable to Recognize OLE Stream  (Read 922 times)
robben
Newbie
*
Posts: 9


« on: July 22, 2013, 01:18:30 PM »

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

Logged
Marius
Administrator
Hero Member
*****
Posts: 1793



WWW
« Reply #1 on: July 22, 2013, 01:23:19 PM »

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
Logged

Please add [SOLVED] to the topic title when your problem has been solved! (do so by editing the first post in the thread and modifying the title)
Please click here before posting.
robben
Newbie
*
Posts: 9


« Reply #2 on: July 22, 2013, 01:35:20 PM »

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
Logged
Marius
Administrator
Hero Member
*****
Posts: 1793



WWW
« Reply #3 on: July 22, 2013, 01:40:02 PM »

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
Logged

Please add [SOLVED] to the topic title when your problem has been solved! (do so by editing the first post in the thread and modifying the title)
Please click here before posting.
Marius
Administrator
Hero Member
*****
Posts: 1793



WWW
« Reply #4 on: July 23, 2013, 10:41:02 AM »

Roberto, the files are actually HTML files. You can see that when you open them in a plain text editor.

Best regards,
Marius
Logged

Please add [SOLVED] to the topic title when your problem has been solved! (do so by editing the first post in the thread and modifying the title)
Please click here before posting.
Pages: [1]
  Print  
 
Jump to: