Using Toad 11 on Windows 7 with Excel 2010
Exporting a fairly large dataset (300,000 rows) to Excel (saving as .xlsx file)
"Display all results in Grid" is unchecked
It gets to the 'Writing Excel File' part then eventually fails with the following error:
"Tag stack not empty: worksheet sheet data row c"
The issue only occurs when saving to Excel with 'XLSX' as the extension.
Saving to Delimited, Excel (XLS), Excel Instance works fine. It's only saving to Excel with the .XLSX extension, does Toad fail.
WORKAROUND 1:
Export as Excel Instance, then save that as XLSX, or export to .csv or .xls.
WORKAROUND 2:
This may be related to memory handling. If possible upgrade to Toad 12.x or higher and set up as a 64bit setup. This would require both a 64-bit Oracle client and a 64-bit version of Toad for Oracle.STATUS:
Waiting for fix in a future release of Toad for Oracle.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center