Exporting a data set to Excel - can you make TOAD export different worksheets?

[Evelyn]

I would like to have one spreadsheet with different worksheets for each database. I see there is an Excel Instance but it's unclear what it does.



------------------------------------

Yahoo! Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/toad/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/toad/join
(Yahoo! ID required)

<*> To change settings via email:
toad-***@yahoogroups.com
toad-***@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
toad-***@yahoogroups.com

<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/

[John Dorlon]

Excel Instance connects to a running instance of excel and exports the dataset on a new sheet. It does not save the file - you have to do that on your own.



From: ***@yahoogroups.com [mailto:***@yahoogroups.com] On Behalf Of Evelyn
Sent: Thursday, March 21, 2013 4:42 PM
To: ***@yahoogroups.com
Subject: [toad] Exporting a data set to Excel - can you make TOAD export different worksheets?



I would like to have one spreadsheet with different worksheets for each database. I see there is an Excel Instance but it's unclear what it does.

[ss052111]

Excel Instance exports the data to and existing instance of Excel running on your machine, if on eexists. If not, it creates one.

I'm not sure what you mean by "different worksheets for each database". each export will create a new Worksheet in the selected Workbook (in the specified Excel document or currently running instance, depending on your selection).

I'm in no position to change Toad, but that's been my experience with how it works.

Sean

Post by Evelyn
I would like to have one spreadsheet with different worksheets for each database. I see there is an Excel Instance but it's unclear what it does.

------------------------------------

Yahoo! Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/toad/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/toad/join
(Yahoo! ID required)

<*> To change settings via email:
toad-***@yahoogroups.com
toad-***@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
toad-***@yahoogroups.com

<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/