Export Data Into MS Excel

Toad for Oracle & DevOps Toolkit
1

I am impressed by Toad’s ability to export a large number of rows to Excel i.e. in excess of 150, 000, with no problems.

My question is: Can this be reproduced programmatically in code (e.g. using C# and a Toad API that exposes the functionality)?

This will be a massive help as other API frameworks have failed with out of memory exceptions.

Thanks in advance.

2

We don’t have an API, but you can use Toad’s automation Designer to set up your export, and then call it from a command prompt. Look in the help’s index under “Command line, actions” for details.

3

Thanks John.