How to save (or export) data from the Data Grid to an Excel file or instance.
RESOLUTION 1:
1. Copy and paste data from the Data Grid directly into Excel by selecting the desired rows, then press CTRL+C to copy the selected data
2. In the Excel file, use CTRL+ V to paste the data to the sheet
RESOLUTION 2:
1. Right-click on the data grid and select 'Export Dataset' (In older versions Toad it is 'Save As'
2. Select Excel File or Excel Instance
3. Enter the desired file path to save the file to
4. Adjust any settings relevant to your export
5. Click OK
Note: In Toad for Oracle 12.8 If the option required is to export the data grid to an Excel Instance, keep in mind:
i. In Export Format: choose Excel Instance
ii. In the middle of window check the option 'Start at active cell' in order to append rows (See image below:)
