Exporting from Data grid to Excel allows only 65000 rows per sheet. Is there a way to export all the rows to one Excel spreadsheet?
Starting with Toad for Oracle 10.5 export the data to one Excel spreadsheet is possible with Microsoft Excel 2007. Enter a file name with an .xlsx extension. In the Save As pop-up window, manually type .XLSX as the file extension type.