Export Data To Xls Format Generates Empty File (Doc ID 562781.1)

Last updated on OCTOBER 27, 2016

Applies to:

Oracle SQL Developer - Version 1.2.1 and later
Information in this document applies to any platform.

Symptoms

***Checked for relevance on 23-Aug-2011***


When generating XLS output, the generated file is empty. The other options under "Export Data" work well, e.g. XML

-- Steps To Reproduce --
Open SQL Worksheet
Enter query. E.g.:
   select sysdate from dual
Run query with green triangle option
Right click on the results screen on the data
Choose "Export Data" -> XLS
Click <apply>
This generates a file, but it is zero bytes in size.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms