My Oracle Support Banner

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

Last updated on AUGUST 04, 2018

Applies to:

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


***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.


To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.