Toad World® Forums

Excel Export


#1

For some reason when I export to excel, my data ends up in 2 excel worksheets. There’s about 80 rows so but i have excel 2010 and it handles much more rows than 80k.


#2

There are a few ways to export data to excel. Can you specify exactly what you are doing?

From: Cburl [mailto:bounce-Cburl@toadworld.com]

Sent: Wednesday, July 10, 2013 2:01 PM

To: toadoracle@toadworld.com

Subject: [Toad for Oracle - Discussion Forum] Excel Export

Excel Export

Thread created by Cburl

For some reason when I export to excel, my data ends up in 2 excel worksheets. There’s about 80 rows so but i have excel 2010 and it handles much more rows than
80k.

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - General
notifications altogether.

Toad for Oracle - Discussion Forum

Flag
this post as spam/abuse.


#3

sure. I run my query then go to the data grid. I then right click and select export dtasheet.


#4

And then in the dialog that appeared, did you choose “Excel file” or “Excel Instance”?

If you chose “Excel Instance”, and excel was already running, Toad will create a new sheet and then put the data on the new sheet. If you want Toad to start
the dataset in a particular cell in Excel, click in the cell in Excel, and in Toad, in the “export” dialog, check “Start at active cell”.