# Problems Writing to Excel - ExportExcel List length cut-off **URL:** \ **Category:** Lists-Logic\ **Created:** [November 26, 2018, 1:07pm UTC](https://forum.dynamobim.com/t/problems-writing-to-excel-exportexcel-list-length-cut-off/28920 "2018-11-26T13:07:29Z")\ **Posts on this page:** 12\ **Page:** 1
**Author:** ![chrisrossinnes](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/chrisrossinnes/32/60394_2.png) [@chrisrossinnes](https://forum.dynamobim.com/u/chrisrossinnes)\ **Post date:** [November 26, 2018, 1:07pm UTC](https://forum.dynamobim.com/t/problems-writing-to-excel-exportexcel-list-length-cut-off/28920/1 "2018-11-26T13:07:29Z")
Good day everyone. I’m having issues using the ExportExcel node to write to a predefined Excel Spreadsheet. The function runs, but with warnings every time I run it. The real issue is that it cuts off the list at around 650 line entries, and the list to export contains approx. 12500 entries. Warning it lists is: “Warning: Data.ExportExcel operation failed. Exception from HRESULT: 0x800A03EC” Tried using the BB Data and WriteExcel nodes from the archilab\_Bumblebee package but that doesn’t do anything. Exporting to .CSV works fine, just not as user friendly. Any ideas? ![TextNotes_WriteToFile](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/2/e/2eecb5f6439f5c40354dd20b1d9a1d23c4295693.jpeg) [TextNotes\_Extract.dyn](https://forum.dynamobim.com/uploads/short-url/pnMux2SPfO7yWGOXCGpkggksvzp.dyn) (40.2 KB) ---
**Author:** ![m.rijsmus](https://avatars.discourse-cdn.com/v4/letter/m/6f9a4e/32.png) [@m.rijsmus](https://forum.dynamobim.com/u/m.rijsmus)\ **Post date:** [November 26, 2018, 1:24pm UTC](https://forum.dynamobim.com/t/problems-writing-to-excel-exportexcel-list-length-cut-off/28920/2 "2018-11-26T13:24:58Z")
A simple search (right top) gives me > [@Problem with export from Revit to Excel with Dynamo](https://forum.dynamobim.com/t/problem-with-export-from-revit-to-excel-with-dynamo/10145): > > Hello community, I’m new in Dynamo but i try to understand basics. I try to make work this script. I read a lot of posts and try different solution but my script still don’t work. Every time i receive this error on last stage when i try to export my data to excel: Warning: Excel.WriteToFile operation failed. Exception from HRESULT: 0x800A03EC I cant upload attachments but i can share a link [HERE](https://drive.google.com/file/d/0B28bCMYPn4pfNVE3VVM5NDIxQU0/view?usp=sharing). Thanks for help !!! ---
**Author:** ![chrisrossinnes](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/chrisrossinnes/32/60394_2.png) [@chrisrossinnes](https://forum.dynamobim.com/u/chrisrossinnes)\ **Post date:** [November 26, 2018, 1:26pm UTC](https://forum.dynamobim.com/t/problems-writing-to-excel-exportexcel-list-length-cut-off/28920/3 "2018-11-26T13:26:40Z")
Apologies, I didn’t come across this when I searched - I obviously used the wrong search criteria. The proposed solution to that thread doesn’t address, or fix my issue as neither of the suggested answers are applicable. ---
**Author:** ![jacob.small](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/jacob.small/32/161030_2.png) [@jacob.small](https://forum.dynamobim.com/u/jacob.small)\ **Post date:** [November 26, 2018, 2:54pm UTC](https://forum.dynamobim.com/t/problems-writing-to-excel-exportexcel-list-length-cut-off/28920/4 "2018-11-26T14:54:36Z")
What was the result you got with the bumblebee nodes? ---
**Author:** ![chrisrossinnes](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/chrisrossinnes/32/60394_2.png) [@chrisrossinnes](https://forum.dynamobim.com/u/chrisrossinnes)\ **Post date:** [November 26, 2018, 3:41pm UTC](https://forum.dynamobim.com/t/problems-writing-to-excel-exportexcel-list-length-cut-off/28920/5 "2018-11-26T15:41:58Z")
> [@chrisrossinnes](#): > > Warning: Data.ExportExcel operation failed. Exception from HRESULT: 0x800A03EC “Warning: Data.ExportExcel operation failed. Exception from HRESULT: 0x800A03EC” It managed to write 648 lines to the Excel Spreadsheet, but nothing thereafter. ---
**Author:** ![jacob.small](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/jacob.small/32/161030_2.png) [@jacob.small](https://forum.dynamobim.com/u/jacob.small)\ **Post date:** [November 26, 2018, 5:01pm UTC](https://forum.dynamobim.com/t/problems-writing-to-excel-exportexcel-list-length-cut-off/28920/6 "2018-11-26T17:01:27Z")
What version of excel are you using? Include if it’s 32 or 64 bit. Also, what OS, Revit build, and Dynamo build. May help to have your Dynamo logs on this as well. ---
**Author:** ![chrisrossinnes](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/chrisrossinnes/32/60394_2.png) [@chrisrossinnes](https://forum.dynamobim.com/u/chrisrossinnes)\ **Post date:** [November 26, 2018, 6:03pm UTC](https://forum.dynamobim.com/t/problems-writing-to-excel-exportexcel-list-length-cut-off/28920/7 "2018-11-26T18:03:02Z")
System Stats: Microsoft Office Professional Plus 2010 - 32bit, version 14.0.7015.1000 Windows 7 Enterprise 64bit with Service Pack 1 installed Revit 2018 64bit build 18.3.1.2 Dynamo Core 2.0.1.5055 Dynamo Revit 2.0.1.5065 Log attached as .txt file[Log.txt](https://forum.dynamobim.com/uploads/short-url/90ttv0IiKvDskfb5WgFRZ3x3aZ9.txt) (23.1 KB) ---
**Author:** ![jacob.small](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/jacob.small/32/161030_2.png) [@jacob.small](https://forum.dynamobim.com/u/jacob.small)\ **Post date:** [November 26, 2018, 11:11pm UTC](https://forum.dynamobim.com/t/problems-writing-to-excel-exportexcel-list-length-cut-off/28920/8 "2018-11-26T23:11:14Z")
May be that excel 2010 isn’t supported due to a break API change by Microsoft. I’ll look into it on this end, but see if you can get an updated version on a machine to test with. ---
**Author:** ![chrisrossinnes](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/chrisrossinnes/32/60394_2.png) [@chrisrossinnes](https://forum.dynamobim.com/u/chrisrossinnes)\ **Post date:** [November 27, 2018, 7:17am UTC](https://forum.dynamobim.com/t/problems-writing-to-excel-exportexcel-list-length-cut-off/28920/9 "2018-11-27T07:17:10Z")
I’m tied into a corporate license for Office unfortunately. There is an OOTB node for exporting to Google Sheets I found last night that I am going to try with the script. I’ll post the result here. ---
**Author:** ![Kulkul](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/kulkul/32/49801_2.png) [@Kulkul](https://forum.dynamobim.com/u/Kulkul)\ **Post date:** [November 27, 2018, 8:19am UTC](https://forum.dynamobim.com/t/problems-writing-to-excel-exportexcel-list-length-cut-off/28920/10 "2018-11-27T08:19:48Z")
Hi @chrisrossinnes Do these changes and it will work for you: - Remove all custom packages and install only clockwork package. - Remove Whitespaces from strings, add String.TrimWhitespace node after TextElement.Text node. Cheers! ---
**Author:** ![chrisrossinnes](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/chrisrossinnes/32/60394_2.png) [@chrisrossinnes](https://forum.dynamobim.com/u/chrisrossinnes)\ **Post date:** [November 27, 2018, 8:22am UTC](https://forum.dynamobim.com/t/problems-writing-to-excel-exportexcel-list-length-cut-off/28920/11 "2018-11-27T08:22:38Z")
Thanks Kulkul! That worked perfectly, and made the script leaner too. Posting fixed .dyn here for reference. [TextNotes\_Extract.dyn](https://forum.dynamobim.com/uploads/short-url/4b3QsGPtj3GGP1HzeBngYpw51Z3.dyn) (29.3 KB) ---
**Author:** ![m.owens](https://avatars.discourse-cdn.com/v4/letter/m/bbe5ce/32.png) [@m.owens](https://forum.dynamobim.com/u/m.owens)\ **Post date:** [October 12, 2021, 10:40am UTC](https://forum.dynamobim.com/t/problems-writing-to-excel-exportexcel-list-length-cut-off/28920/12 "2021-10-12T10:40:47Z")
I was also having a similar issue. I did not remove all packages, but instead found a custom node from spring nodes (Dictionary) which was throwing an exception. I opened it up, copied the python node, and re-connected everything. After that, everything worked just fine.