PLSQL developer Save results from Grid without line number

[dwwallac]

This is probably just an option that i haven't configured properly, but I was wondering how can I set the results grid for the SQL Window , so when i export or copy the data, it doesn't copy or export with the line number in the output ?
eg. if i have multi line output from select * from dba_objects where rownum < 10
and I copy paste or export to excel , my output looks like this
(line number column) OWNER OBJECT_NAME SUBOBJECT_NAME OBJECT_ID ....
where i'd prefer this :
OWNER OBJECT_NAME SUBOBJECT_NAME OBJECT_ID

Thanks,
David

 

[null0000]

Have you tried instead highlighting all by clicking on the upper left corner just highlight columns that you need and then copy to Excel from context menu?
;-)

 

[T-Gergely]

Yeah, but is there _anybody_ who needs the extra line numbers in Excel?
Hint-hint, Marco?

 

[Benjamin L]

I like the extra line numbers, and if i don't need it i only mark the header and not the hole Grid.

 

[T-Gergely]

OK, it should be set in preferences then.

 

[dwwallac]

Thanks null0000, i hadn't used that column highlight option previously, so i'll use that in future for part copies. However this query was prompted by one of our end users , who we've recently convinced to switch from Toad to PLSQL Developer, and who's using the product as an Oracle GUI interface rather than as a development tool. So saving multi column , multi row output to Excel is something they do often, hence the requirement to be able to set this globally as an option

 

[Sree]

Though an old post, I want to share that there is an option to exclude the row number during copy/paste/export to excel. I am using version 12.0.2.1818

Preferences --> Window Types --> SQL Window --> "Include row number with export and copy"

If you uncheck this option, the row number is no longer copied.

 

[Cloink]

And for those on an old version which does not have that option in the preferences, the Export BUTTON on the toolbar directly above the grid does NOT include the row number on export.

(Whereas right-click in grid > Export DOES include the row number.)

* Right-click in grid > Export reproduces the contents of the grid, which may be an incomplete result-set.
* Export Button exports the results of the query, so it will re-run the query in the background to fetch/export all rows.