Page 1 of 1

Oracle Developer version 2.55.149 - Excel Unreadable Content

Posted: Wed 08 Sep 2010 12:18
by berlinhammer
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

Posted: Wed 08 Sep 2010 13:47
by Viktor
OraDev 2.55.149
You are using an old version of our product.
Please download the recent version of the product.

Try to execute the following:

Code: Select all

Create table tmp_query as ( select .... your large query);
Export data from the tmp_query table to Excel.
Will you encounter any problems when opening the expdata.xls file?

Please send us Generate DDL of the tmp_query table, so that we could reproduce the problem.