Copy to Excel and row number

[MartinF]

Hi,
I have the same problem using PL/SQL Developer 7.xx and 8.

When using "Copy to Excel" functionnality, it also export the row number that appear in the grid of PL/SQL Developer. Is there a way to prevent this column from being exported in Excel, since Excel already display a row number.

Thank

 

[Worker]

You can select/highlight columns by clicking on the column headers. When you "Copy to Excel", only selected columns are copied.

 

[MartinF]

You're right, it's possible to select all column manually. But It's still strange to import the row number when Excel already have this kind of column

 

[RobertK]

You can select/highlight columns by clicking on the column headers. When you "Copy to Excel", only selected columns are copied.

that's rather impractical when you have more than like 8 columns

 

[Wim]

Hi,
I have the same problem using PL/SQL Developer 7.xx and 8.

When using "Copy to Excel" functionnality, it also export the row number that appear in the grid of PL/SQL Developer. Is there a way to prevent this column from being exported in Excel, since Excel already display a row number.

Thank

I have been wondering about that the last few days too. Some way to tick this in the preferences would indeed be welcome.

 

[Marco Kalter]

I have added this to the list of enhancement requests.

 

[Bernhard S]

You can select/highlight columns by clicking on the column headers. When you "Copy to Excel", only selected columns are copied.

that's rather impractical when you have more than like 8 columns

You can just click on the first column header and shift click on the last column header to select all, except the empty header for the row numbers.

 

[matjazc]

You could write ( or record ) a macro in excel that just deletes first column.