How can I export multiple result sets in ADS as one excel workbook with one worksheet per result set? For example, let’s say I have SQL as follows, and it returns multiple result sets. Do I have to export each grid or is there some way to export all grids to an excel workbook?
Sent To Customer:
I am not sure there is a way to export different result sets to the same workbook on different sheets; however, you can get the results you need in one of the ways below.
1) If the result sets are not super large you can "select all" then copy paste into an Excel worksheet, I have done this with a result set of 19,000+ rows and 13 columns.
2) A little more time consuming but works is right click the results and save to Excel, then drag and drop each worksheet into one workbook.
Customer had been able to use #1 but wants something simpler if possible.
In the file menu, select Save Results… then select to save Grid Results as Excel 2007 worksheet. It will save each result set as a separate worksheet in one file.
Note: Sadly I've been told there is no way to name the resulting worksheets, so you wind up with GridResults1, GridResults2, etc.
Issue #15653 |
New |
Completion |
No due date |
No fixed build |
No time estimate |
In the file menu, select Save Results… then select to save Grid Results as Excel 2007 worksheet. It will save each result set as a separate worksheet in one file.
Note: Sadly I've been told there is no way to name the resulting worksheets, so you wind up with GridResults1, GridResults2, etc.