Home » SQL & PL/SQL » Client Tools » unable to paste header(column) names result to excel
unable to paste header(column) names result to excel [message #560056] Tue, 10 July 2012 04:48 Go to next message
srikanth_d5
Messages: 39
Registered: June 2012
Location: hyderabad
Member
hi experts,

when i'm saving the result in excel sheet....results are saving but unable to paste coulmn/header names....

can anyone kindly guide me how to overcome this problem.....
Re: unable to paste header(column) names result to excel [message #560058 is a reply to message #560056] Tue, 10 July 2012 05:07 Go to previous messageGo to next message
John Watson
Messages: 4370
Registered: January 2010
Location: Global Village
Senior Member
Did you mean to post this question in a Microsoft Excel forum? It doesn't seem to have anything to do with Oracle.
Re: unable to paste header(column) names result to excel [message #560060 is a reply to message #560056] Tue, 10 July 2012 05:14 Go to previous messageGo to next message
Michel Cadot
Messages: 58501
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
when i'm saving the result in excel sheet.


Post what you do.
Tell us which tool you use. SQL*plus and SQL script file? Custom application?...

Regards
Michel
Re: unable to paste header(column) names result to excel [message #560062 is a reply to message #560058] Tue, 10 July 2012 05:18 Go to previous messageGo to next message
srikanth_d5
Messages: 39
Registered: June 2012
Location: hyderabad
Member
sorry...

i'm working on sql developer....and i'm pasting the results in excel sheet...results are copying but column names in the select list are not saving....
for example

select employee_id,name,salary
from employee

result:-
employee_id name salary
101 john 10000
102 smith 11100

but
copied results and pasted in excel sheet

101 john 10000
102 smith 11100






Re: unable to paste header(column) names result to excel [message #560064 is a reply to message #560062] Tue, 10 July 2012 06:10 Go to previous messageGo to next message
Littlefoot
Messages: 19303
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Well, don't copy/paste - use SQL Developer's Export utility.

Write a query; execute it. Right-click the results grid and choose "Export":

./fa/10299/0/

Choose the output file format ("xls" or "xlsx" for Excel files). Name the output file ("Save As"; in my example, c:\export.xls). Check the "Header" checkbox (if it is not checked).
Click <Next>, click <Finish>.

./fa/10301/0/

The result:

./fa/10302/0/

Re: unable to paste header(column) names result to excel [message #560065 is a reply to message #560062] Tue, 10 July 2012 06:10 Go to previous messageGo to next message
Michel Cadot
Messages: 58501
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
This is the expected result.
Do it in 2 passes: 1) select the column name from user_tab_columns, copy and paste into excel, then your query and copy and paste into the same excel sheet.

Regards
Michel
Re: unable to paste header(column) names result to excel [message #560066 is a reply to message #560065] Tue, 10 July 2012 06:12 Go to previous messageGo to next message
Michel Cadot
Messages: 58501
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
But Littlefoot's solution is far better.

Regards
Michel
Re: unable to paste header(column) names result to excel [message #560151 is a reply to message #560064] Tue, 10 July 2012 23:41 Go to previous messageGo to next message
srikanth_d5
Messages: 39
Registered: June 2012
Location: hyderabad
Member
Thank u...

but when i tried same as in screen shots of you...My "header" file box is not displaying.....i think mine is older version of Sql developer......


Thanks and regards...
Re: unable to paste header(column) names result to excel [message #560153 is a reply to message #560151] Wed, 11 July 2012 00:05 Go to previous messageGo to next message
Littlefoot
Messages: 19303
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Quote:
i think mine is older version of Sql developer

Since when is that a problem? Download (for free!) a new version and install it.
Re: unable to paste header(column) names result to excel [message #561522 is a reply to message #560060] Mon, 23 July 2012 08:43 Go to previous message
wvu1999
Messages: 38
Registered: April 2007
Member

Ctrl+Shift+C will copy data and headers, no need to use the Export wizard if you don't want to

http://www.thatjeffsmith.com/archive/2012/02/stupid-copy-paste-tricks/
Previous Topic: utl file setup
Next Topic: How to define ED command in sql*plus?
Goto Forum:
  


Current Time: Wed Jul 23 11:11:58 CDT 2014

Total time taken to generate the page: 0.10790 seconds