Oracle Developer version 2.55.149 - Excel Unreadable Content

Discussion of open issues, suggestions and bugs regarding database management and development tools for Oracle
Post Reply
berlinhammer
Posts: 2
Joined: Tue 24 Aug 2010 12:38

Oracle Developer version 2.55.149 - Excel Unreadable Content

Post by berlinhammer » 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

Viktor
Devart Team
Posts: 68
Joined: Thu 06 May 2010 08:12

Post by Viktor » Wed 08 Sep 2010 13:47

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.

Post Reply