Oracle Developer version 2.55.149 - Excel Unreadable Content
Posted: Wed 08 Sep 2010 12:18
Hello,
I am currently working on a large query (roughly 40 columns and 17,000 rows) in OraDev 2.55.149.
I am encountering an irritating problem when exporting my data as the expdata.xls default excel file. Once I have gone through the Data Export Wizard it all seems to work fine until I open the exported excel file. I am getting the following error message:
"Excel found unreadable content in expdata.xls. Do you want to recover... etc etc" Yes/No
When I click Yes it simply says "Unable to read file".
My current bodge to get my data is to export it as a text file and then import it to Excel. This is a real pain however as it creates white space isues and mixes columns up, not to mention the extra time the process takes.
Would anybody be able to shed any light on what is causing this issue and steps to remedy it?
Thank you very much
Jon
I am currently working on a large query (roughly 40 columns and 17,000 rows) in OraDev 2.55.149.
I am encountering an irritating problem when exporting my data as the expdata.xls default excel file. Once I have gone through the Data Export Wizard it all seems to work fine until I open the exported excel file. I am getting the following error message:
"Excel found unreadable content in expdata.xls. Do you want to recover... etc etc" Yes/No
When I click Yes it simply says "Unable to read file".
My current bodge to get my data is to export it as a text file and then import it to Excel. This is a real pain however as it creates white space isues and mixes columns up, not to mention the extra time the process takes.
Would anybody be able to shed any light on what is causing this issue and steps to remedy it?
Thank you very much

Jon