Oracle Developer version 2.55.149 - Excel Unreadable Content

Oracle Developer version 2.55.149 - Excel Unreadable Content

Postby 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
berlinhammer
 
Posts: 2
Joined: Tue 24 Aug 2010 12:38

Postby 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.
Viktor
Devart Team
 
Posts: 68
Joined: Thu 06 May 2010 08:12


Return to dbForge for Oracle