Apr 1, 2013 7:37:00 AM by Debbie Peabody
Single result sets exported to Excel may not be enough for your needs. You might have a project where the end user wants multiple results in a single page. And of course you would like to make it attractive.
You can build complex reports by sending result sets to specific cells of a worksheet. Here is a report that I run monthly to show connection types and module usage.
For this report I have an excel file that contains only the formatting. I want to save this template and always use it as my base.
So in my automation script I make a copy of template.
Then using the Select to file I export to specific cell locations. Note: In TDP 3.3 you will need to use the Export Wizard template activity to export to specific cell and named worksheet.
Written by Debbie Peabody
Debbie Peabody is a Software Development Team Lead. She joined Quest in 1997 coding for Quest’s SQL Tuning product SQLab. She brings many years of experience of development on database tool products and co-designed Toad Data Point.