problem exporting long query to Excel

[ckubitsc]

I've generated a pretty long query that produces some results I want to export to Excel. When I right-click on the results and select "Copy to Excel..." I get a pop-up window that has "Error" in the title bar, the query in the main window, and a button marked "OK". My results do not copy to Excel after clicking on the "OK". I'm interpreting this pop-up as an indication that the query text itself is the problem.

The query is 192829 characters long. The results are 7 columns by 4192 rows where the largest cell is probably 13 characters.

I'm running PL/SQL Developer 12.07.1837 (64 bit) 01.117664 and Excel 2013 Professional.

I was able to "Export Results" > "Excel file" and then copy the SQL into a second tab by hand but I'm wondering what's going wrong with my standard method of getting output to Excel.

 

[Marco Kalter]

Can you go to Preferences > Files / Format and disable the "Export to Excel with SQL statement" option? Let me know if this affects the issue.

 

[ckubitsc]

Marco, with "Export to Excel with SQL statement" disabled the export works without error. Unfortunately, it is very handy to have the query exported automatically.

Googling the character limit for an Excel cell gives me "32,767 characters" and I just realized that my query being 192829 characters definitely exceeds this. Yesterday I was putting the comma in the wrong place (19,2829).

In your ever-growing list of 'it would be nice if's perhaps you could add an option to paste SQL into multiple cells based upon line breaks in the query or overflowing into the following cell(s).

Thanks. I've got two ways to get around this now: 1) right-click "Export Results" > "Excel file" and 2) disabling the "Export to Excel with SQL statement" option in Preferences.

 

[Marco Kalter]

Thanks. We'll fix this.