Submitting forms on the support site are temporary unavailable for schedule maintenance. If you need immediate assistance please contact technical support. We apologize for the inconvenience.
Can Toad export to an Excel worksheet without overwriting other sheets?h
설명
Is it possible to export data to an excel worksheet without overwiting other sheets in the file?
해결 방안
Make a copy of Excel file (for backup)
Open the Excel file
Create a new worksheet and name it, or empty data that is currently in the required worksheet
Position the cursor in the first cell of the required worksheet
In Toad, run a query and use the 'Excel Instance' option when doing an 'Export Dataset'.
Check the option 'Start at active Cell'
Specify the name of the worksheet in 'Sheet Name'
Click 'OK' to run the Export
Note: This operation cannot be undertaken if scheduling the 'export dataset' as part of the Automation Designer as the excel file needs to be open and the cursor positioned in the correct cell.
