Copy all to Excel - tab names

[sqldev]

How can I set tab names when using "Copy all to Excel" option?

I am trying to export result of 50 some queries and it will be great if there is an option available to set the tab names in excel.

Thanks.

 

[Marco Kalter]

There is currently no option for this. I have added this to the list of enhancement requests.

 

[sqldev]

Thanks Marco.

 

[sqldev]

Hi Marco,

Any idea when this upgrade will be available?

Thanks.

 

[Marco Kalter]

If you use the "Tab=" directive in the SQL Window, the tab names will be used in Excel as well. For example:

-- tab=Departments
select * from dept;
-- tab=Employees
select * from emp;

This will create 2 tab pages with the names "Departments" and "Employees".