Export Data to Excel Instance

751486

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

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