Copy to Excel Minus rownum

[StevenRowe]

I've had a look in the forum for a solution but don't see it.

Is it possible to Copy to Excel without the rownum i.e. first column? Similar to when you Export Query Results to a CSV?

Thanks.

 

[Benjamin L]

Make sure that you don't mark the column where the rownums are inside. This is not really included in the resultset, but in the grid. And the grid is, waht is be exported.

 

[StevenRowe]

Thanks Benjamin

I guess that's a workaround but I don't see why that column would be included in an export to Excel when Excel already has row number.

 

[Bernhard S]

Yes, it's quite easy: Just instead of marking the whole result grid by clicking on the top left corner you mark the first column and then with shift+mouse-click the last column of the result grid and then via mouse-right-click -> Export Results -> CSV File
you should get your CSV without the rownum column.

 

[hellraiserTG]

good ideas, or you could just delete the first column in excel after having inserted the copy

 

[StevenRowe]

good ideas, or you could just delete the first column in excel after having inserted the copy

That's what I have always done but I thought there must be an option within PL/SQL Dev to not export the rownum

 

[mike]

I always delete the first column after copying to Excel also. In my opinion, it would be nicer to not need to do this every time.

 

[hellraiserTG]

ok, from this point of view

but i'm already so used to it... but then i would delete the first datacolumn

 

[Andrew Lindner]

Not sure the version of PL/SQL Dev that you are using (I'm on 10.0.4.1708), but I was also looking for this as I export multiple queries and having to delete the rownum is tedious.

I found that you can remove this under;

Tools > Preferences > Window Types > SQL Window
Uncheck "Include row number with export and copy"
Apply