Can you automate Toad to export multiple query results to a single Excel spreadsheet?
说明
I want to automate exporting multiple query results into Excel to create a multi-sheets report and specify what each sheet name should be.
解决办法
WORKAROUND: Go to Export Wizard located in Tools | Export. There is an option to export to an Excel instance. From there you can choose the Excel file to import to and it will create a sheet with the name of the table, but unfortunately you cannot automate this nor can you change the name of the sheets.
STATUS: Enhancement request ST62288 has been submitted to Development for consideration in a future release of Toad for Data Analyst.
