OraFAQ Forum: Client Tools » unable to paste header(column) names result to excel

Home » Other » Client Tools » unable to paste header(column) names result to excel

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

unable to paste header(column) names result to excel [message #560056]

Tue, 10 July 2012 04:48

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

Report message to a moderator

Re: unable to paste header(column) names result to excel [message #560058 is a reply to message #560056]

Tue, 10 July 2012 05:07

John Watson
Messages: 8964
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.

Report message to a moderator

Re: unable to paste header(column) names result to excel [message #560060 is a reply to message #560056]

Tue, 10 July 2012 05:14

Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: unable to paste header(column) names result to excel [message #560062 is a reply to message #560058]

Tue, 10 July 2012 05:18

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

Report message to a moderator

Re: unable to paste header(column) names result to excel [message #560064 is a reply to message #560062]

Tue, 10 July 2012 06:10

Littlefoot
Messages: 21823
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":

/forum/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>.

/forum/fa/10301/0/

The result:

/forum/fa/10302/0/

Attachment: sqld_export_1.png
(Size: 13.17KB, Downloaded 3275 times)
Attachment: sqld_export_2.png
(Size: 11.57KB, Downloaded 3297 times)
Attachment: sqld_export_3.png
(Size: 22.71KB, Downloaded 3295 times)

Report message to a moderator

Re: unable to paste header(column) names result to excel [message #560065 is a reply to message #560062]

Tue, 10 July 2012 06:10

Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: unable to paste header(column) names result to excel [message #560066 is a reply to message #560065]

Tue, 10 July 2012 06:12

Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

But Littlefoot's solution is far better.

Regards
Michel

Report message to a moderator

Re: unable to paste header(column) names result to excel [message #560151 is a reply to message #560064]

Tue, 10 July 2012 23:41

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

Report message to a moderator

Re: unable to paste header(column) names result to excel [message #560153 is a reply to message #560151]

Wed, 11 July 2012 00:05

Littlefoot
Messages: 21823
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.

Report message to a moderator

Re: unable to paste header(column) names result to excel [message #561522 is a reply to message #560060]

Mon, 23 July 2012 08:43

wvu1999
Messages: 40
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/

Report message to a moderator

Previous Topic:	utl file setup
Next Topic:	How to define ED command in sql*plus?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Feb 05 23:55:18 CST 2025