Copy to Excel issue

[cassiusdrow]

If you execute a query larger than about 32K in an SQL window and then select the results, right click and select "Copy to Excel", Excel will report that there is unreadable data in the file.

I am using PL/SQL Developer version 7.0.3.1123, Oracle 8i, and Microsoft Excel 2003 SP3.

Steps to reproduce:

1. Run this query in an SQL window to generate a very large query:

SELECT 'SELECT ''12345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678'' x FROM DUAL WHERE 1=2 UNION ALL' x
  FROM (
         SELECT 1 just_a_column
           FROM dual
          GROUP BY CUBE(1,2,3,4,5,6,7,8,9)
       )
 WHERE ROWNUM <= 163
UNION ALL
SELECT 'SELECT ''123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567'' x FROM DUAL;' x
  FROM dual;

2. Copy this query to another SQL window and run it. Select the resulting column, right click, select Copy to Excel. This will produce the error.

3. Edit the query from step 2 to remove the last 7 from the last line and repeat step 2. Excel will open without any errors.

Since this appears to be a limitation of Excel, perhaps the query could be loaded into the "SQL Statement" worksheet in a different way when the query is larger that 32k.

 

[Marco Kalter]

We'll fix it.

 

[cassiusdrow]

As a work around, I found that unchecking "Export to Excel with SQL statement" in Tools, Preferences, Files, Format would not cause the error because the SQL statement was not included in the spreadsheet.