Skip to Main Content

SQL Developer

Announcement

For appeals, questions and feedback, please email oracle-forums_moderators_us@oracle.com

Excel does not support empty numbers

Laurent SchneiderJul 23 2014 — edited Jul 23 2014

When I export a table in Excel-XML format, SCOTT.EMP, the tag <Data ss:type="Number"></Data> does shows as 0 in Excel

To have it empty, I have to edit my XML and replace it by <Data ss:type="String"/>

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 20 2014
Added on Jul 23 2014
4 comments
482 views