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. Warn…

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!

A simple search (right top) gives me [image] Problem with export from Revit to Excel with Dynamo Revit 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 stil…

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.

What was the result you got with the bumblebee nodes?

[image] 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.

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.

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 (23.1 KB)

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.

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.

Thanks Kulkul! That worked perfectly, and made the script leaner too. Posting fixed .dyn here for reference. TextNotes_Extract.dyn (29.3 KB)

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.

Problems Writing to Excel - ExportExcel List length cut-off

Lists-Logic

m.rijsmus November 26, 2018, 1:24pm 2

A simple search (right top) gives me

Topic		Replies	Views
Need to export this script result to excel Revit	9	826	May 25, 2022
Error : HRESULT: 0x800A03EC Revit excel	17	4244	October 11, 2017
Problem with export from Revit to Excel Revit	18	3912	March 14, 2020
Dynamo Version 3 Excel Export Revit revit , dynamo	4	221	December 19, 2025
XMLExprortExel error msg unclear Lists-Logic revit , excel , dynamo	5	107	July 31, 2024

Problems Writing to Excel - ExportExcel List length cut-off

Related topics