Skip to Main Content
Forums

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Export Data to Excel Instance

751486Feb 4 2010 — edited Feb 4 2010
How to Export the data results to Excel Instance? This feature is available in Toad. Is there a similar functionality with SQL Developer ?

Regards
Shiva Bodipudi

Comments

_Dylan_
Like right clicking your query results -> Export Data -> xls...

If that's what you mean, how hard are you really looking?
751486
Thanks for the reply. Right Clicking on Data results -> save as -> excel file allows us to save it as an excel file. But, In TOAD, you can save it as excel instance which actually opens the unsaved excel file with data on it. In short, right click-> save as excel instance -> Excel opens up with the data in it.

-Shiva
_Dylan_
Oh, I think I got what you're looking for now. I don't know of any save as "excel instance", but when you save as an excel file, you can choose to save to the clipboard instead of a file. Then you can switch over to excel and paste into a worksheet.
125857
I've never seen that SQL Developer can do that-it'll just save the data in the specified format and that's it.
1 - 4
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Mar 4 2010
Added on Feb 4 2010
#excel, #sql-developer
4 comments
1,527 views