# List index out of bounds (538976288) when exporting dataset to Excel **URL:** \ **Category:** Toad for Oracle - Beta\ **Created:** [September 11, 2015, 1:11am UTC](https://forums.toadworld.com/t/list-index-out-of-bounds-538976288-when-exporting-dataset-to-excel/34093 "2015-09-11T01:11:31Z")\ **Posts on this page:** 9\ **Page:** 1
**Author:** ![NoDabble](https://avatars.discourse-cdn.com/v4/letter/n/9fc29f/32.png) [@NoDabble](https://forums.toadworld.com/u/NoDabble)\ **Post date:** [September 11, 2015, 1:11am UTC](https://forums.toadworld.com/t/list-index-out-of-bounds-538976288-when-exporting-dataset-to-excel/34093/1 "2015-09-11T01:11:31Z")
Toad Beta 12.8.0.26 This only happens when the dataset contains a date. To replicate, try this: Select sysdate from dual; Then right click in the data grid, choose Export Dataset, format Excel File, click OK. ---
**Author:** ![w.delange](https://avatars.discourse-cdn.com/v4/letter/w/7c8e57/32.png) [@w.delange](https://forums.toadworld.com/u/w.delange)\ **Post date:** [September 11, 2015, 2:23am UTC](https://forums.toadworld.com/t/list-index-out-of-bounds-538976288-when-exporting-dataset-to-excel/34093/2 "2015-09-11T02:23:14Z")
Tried that to to XLS and XLSX, network or not network. No problems with saving. Also the option “Display all results in grid” does not make any difference (as did in the past). **From:** NoDabble [[mailto:bounce-NoDabble@toadworld.com](mailto:bounce-NoDabble@toadworld.com)] **Sent:** Friday, 11 September, 2015 10:12 **To:** [toadoraclebeta@toadworld.com](mailto:toadoraclebeta@toadworld.com) **Subject:** [Toad for Oracle - Beta Discussion Forum] List index out of bounds (538976288) when exporting dataset to Excel **[List index out of bounds (538976288) when exporting dataset to Excel](http://www.toadworld.com/products/toad-for-oracle/toad_for_oracle_beta_program/f/86/t/25413)** Thread created by NoDabble Toad Beta 12.8.0.26 This only happens when the dataset contains a date. To replicate, try this: Select sysdate from dual; Then right click in the data grid, choose Export Dataset, format Excel File, click OK. To reply, please reply-all to this email. [Stop receiving emails](http://www.toadworld.com/products/toad-for-oracle/toad_for_oracle_beta_program/f/86/t/25413?subscribe=false) on this subject. Or [ Unsubscribe from Toad for Oracle - Beta](http://www.toadworld.com/products/toad-for-oracle/toad_for_oracle_beta_program/f/86?subscribe=false) notifications altogether. Toad for Oracle - Beta Discussion Forum [Flag](http://www.toadworld.com/products/toad-for-oracle/toad_for_oracle_beta_program/f/86/t/25413?AbuseContentId=e83f513e-b204-4b80-9a7a-abb9c01aa72b&AbuseContentTypeId=46448885-d0e6-4133-bbfb-f0cd7b0fd6f7&AbuseFlag=true) this post as spam/abuse. Wim de Lange Senior IT expert ALcontrol Laboratories [Steenhouwerstraat 15](http://maps.google.nl/maps?f=q&hl=nl&q=Steenhouwerstraat%2015+3194%20AG+NL) 3194 AG Rotterdam NL Tel +31 10 23 14 724 • Mobile +31 65 15 34 387 Fax +31 10 41 63 034 e-mail W.deLange@alcontrol.nl • [ www.alcontrol.com](http://www.alcontrol.com) - The information in this e-mail is confidential and may also be legally privileged.The contents are intended for recipient only and are subject to the legal notice available at: www.alcontrol.nl. Registered Office:Alcontrol BV, Steenhouwerstraat 15, 3194 AG Rotterdam.\* ---
**Author:** ![NoDabble](https://avatars.discourse-cdn.com/v4/letter/n/9fc29f/32.png) [@NoDabble](https://forums.toadworld.com/u/NoDabble)\ **Post date:** [September 11, 2015, 3:24am UTC](https://forums.toadworld.com/t/list-index-out-of-bounds-538976288-when-exporting-dataset-to-excel/34093/3 "2015-09-11T03:24:23Z")
Weird. Thanks for trying. I’ll see if I can replicate my issue on another PC. For what it’s worth I’m running MS Office Professional Plus 2010, Excel v14.0.7153.5000 (32-bit) ---
**Author:** ![w.delange](https://avatars.discourse-cdn.com/v4/letter/w/7c8e57/32.png) [@w.delange](https://forums.toadworld.com/u/w.delange)\ **Post date:** [September 11, 2015, 3:43am UTC](https://forums.toadworld.com/t/list-index-out-of-bounds-538976288-when-exporting-dataset-to-excel/34093/4 "2015-09-11T03:43:12Z")
I use 64 bits Toad with 64 bits Office 2013 without the mentioned problem **From:** NoDabble [[mailto:bounce-NoDabble@toadworld.com](mailto:bounce-NoDabble@toadworld.com)] **Sent:** Friday, 11 September, 2015 12:25 **To:** [toadoraclebeta@toadworld.com](mailto:toadoraclebeta@toadworld.com) **Subject:** RE: [Toad for Oracle - Beta Discussion Forum] List index out of bounds (538976288) when exporting dataset to Excel **[RE: List index out of bounds (538976288) when exporting dataset to Excel](http://www.toadworld.com/products/toad-for-oracle/toad_for_oracle_beta_program/f/86/p/25413/56114#56114)** Reply by NoDabble Weird. Thanks for trying. I’ll see if I can replicate my issue on another PC. For what it’s worth I’m running MS Office Professional Plus 2010, Excel v14.0.7153.5000 (32-bit) To reply, please reply-all to this email. [Stop receiving emails](http://www.toadworld.com/products/toad-for-oracle/toad_for_oracle_beta_program/f/86/t/25413?subscribe=false) on this subject. Or [ Unsubscribe from Toad for Oracle - Beta](http://www.toadworld.com/products/toad-for-oracle/toad_for_oracle_beta_program/f/86?subscribe=false) notifications altogether. Toad for Oracle - Beta Discussion Forum [Flag](http://www.toadworld.com/products/toad-for-oracle/toad_for_oracle_beta_program/f/86/p/25413/56114?AbuseContentId=75af5212-c03c-40cc-8557-8be627a112a3&AbuseContentTypeId=f586769b-0822-468a-b7f3-a94d480ed9b0&AbuseFlag=true) this post as spam/abuse. Wim de Lange Senior IT expert ALcontrol Laboratories [Steenhouwerstraat 15](http://maps.google.nl/maps?f=q&hl=nl&q=Steenhouwerstraat%2015+3194%20AG+NL) 3194 AG Rotterdam NL Tel +31 10 23 14 724 • Mobile +31 65 15 34 387 Fax +31 10 41 63 034 e-mail W.deLange@alcontrol.nl • [ www.alcontrol.com](http://www.alcontrol.com) - The information in this e-mail is confidential and may also be legally privileged.The contents are intended for recipient only and are subject to the legal notice available at: www.alcontrol.nl. Registered Office:Alcontrol BV, Steenhouwerstraat 15, 3194 AG Rotterdam.\* ---
**Author:** ![w.delange](https://avatars.discourse-cdn.com/v4/letter/w/7c8e57/32.png) [@w.delange](https://forums.toadworld.com/u/w.delange)\ **Post date:** [September 11, 2015, 3:44am UTC](https://forums.toadworld.com/t/list-index-out-of-bounds-538976288-when-exporting-dataset-to-excel/34093/5 "2015-09-11T03:44:14Z")
Just a thought. What is the date and time format you are using? Maybe that has an influence on the error. **From:** NoDabble [[mailto:bounce-NoDabble@toadworld.com](mailto:bounce-NoDabble@toadworld.com)] **Sent:** Friday, 11 September, 2015 12:25 **To:** [toadoraclebeta@toadworld.com](mailto:toadoraclebeta@toadworld.com) **Subject:** RE: [Toad for Oracle - Beta Discussion Forum] List index out of bounds (538976288) when exporting dataset to Excel **[RE: List index out of bounds (538976288) when exporting dataset to Excel](http://www.toadworld.com/products/toad-for-oracle/toad_for_oracle_beta_program/f/86/p/25413/56114#56114)** Reply by NoDabble Weird. Thanks for trying. I’ll see if I can replicate my issue on another PC. For what it’s worth I’m running MS Office Professional Plus 2010, Excel v14.0.7153.5000 (32-bit) To reply, please reply-all to this email. [Stop receiving emails](http://www.toadworld.com/products/toad-for-oracle/toad_for_oracle_beta_program/f/86/t/25413?subscribe=false) on this subject. Or [ Unsubscribe from Toad for Oracle - Beta](http://www.toadworld.com/products/toad-for-oracle/toad_for_oracle_beta_program/f/86?subscribe=false) notifications altogether. Toad for Oracle - Beta Discussion Forum [Flag](http://www.toadworld.com/products/toad-for-oracle/toad_for_oracle_beta_program/f/86/p/25413/56114?AbuseContentId=75af5212-c03c-40cc-8557-8be627a112a3&AbuseContentTypeId=f586769b-0822-468a-b7f3-a94d480ed9b0&AbuseFlag=true) this post as spam/abuse. Wim de Lange Senior IT expert ALcontrol Laboratories [Steenhouwerstraat 15](http://maps.google.nl/maps?f=q&hl=nl&q=Steenhouwerstraat%2015+3194%20AG+NL) 3194 AG Rotterdam NL Tel +31 10 23 14 724 • Mobile +31 65 15 34 387 Fax +31 10 41 63 034 e-mail W.deLange@alcontrol.nl • [ www.alcontrol.com](http://www.alcontrol.com) - The information in this e-mail is confidential and may also be legally privileged.The contents are intended for recipient only and are subject to the legal notice available at: www.alcontrol.nl. Registered Office:Alcontrol BV, Steenhouwerstraat 15, 3194 AG Rotterdam.\* ---
**Author:** ![NoDabble](https://avatars.discourse-cdn.com/v4/letter/n/9fc29f/32.png) [@NoDabble](https://forums.toadworld.com/u/NoDabble)\ **Post date:** [September 11, 2015, 3:56am UTC](https://forums.toadworld.com/t/list-index-out-of-bounds-538976288-when-exporting-dataset-to-excel/34093/6 "2015-09-11T03:56:24Z")
My sysdate looks like this: 11/09/2015 11:52:19. I can export to an Excel instance but not an Excel file. I have tried it on Toad 12.5.1.1 using the same export settings (where possible) and it saves the file just fine. There is another Excel Export issue with 12.8 beta which may be related… If I export the results of this query… Select owner, object\_name, Timestamp, status From dba\_objects Where Rownum \< 10 …to Excel it saves the file, but when the file is opened Excel switches to Protected mode with the following message in red at the top: Office has detected a problem with this file. Editing it may harm your computer. Doesn’t happen with 12.5.1.1! ---
**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\ **Post date:** [September 11, 2015, 6:04am UTC](https://forums.toadworld.com/t/list-index-out-of-bounds-538976288-when-exporting-dataset-to-excel/34093/7 "2015-09-11T06:04:15Z")
I can reproduce the problem in 64 bit when exporting using the “Excel File” option to XLS, but XLSX works correctly. I’ll let you know when I have a solution. It works fine in 32 bit. Just so you know - the version of Excel makes no difference for the “Excel FIle” format. Excel does not even need to be installed for it to work (but it does for “Excel Instance”). As you might have guessed, the “File” and “Instance” export options use completely different technologies. Also, XLS and XLSX export formats are very different, so if it fails in one, it may work in the other. We just recently updated our Excel file writer component, so there may have been some problem there, but in my testing, I was able to export a million-row dataset (including dates and timestamps) without any errors. This many rows usually caused problems in prior versions. ---
**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\ **Post date:** [September 11, 2015, 8:39am UTC](https://forums.toadworld.com/t/list-index-out-of-bounds-538976288-when-exporting-dataset-to-excel/34093/8 "2015-09-11T08:39:34Z")
Fixed for next beta. ---
**Author:** ![NoDabble](https://avatars.discourse-cdn.com/v4/letter/n/9fc29f/32.png) [@NoDabble](https://forums.toadworld.com/u/NoDabble)\ **Post date:** [September 14, 2015, 2:45am UTC](https://forums.toadworld.com/t/list-index-out-of-bounds-538976288-when-exporting-dataset-to-excel/34093/9 "2015-09-14T02:45:57Z")
You’re right… saving as xlsx solves both of my problems. I’m happy to do that as a workaround. Thanks.