Data.ExportExcel

[labonte.tmb]

Hello everyone,
Hello everyone,
Does anyone know why I have this warning now when I want to export to Excel?
The problem is the same for Revit 2021 and 2022, everything was working fine a while ago.
Thank so much

[GavinCrump]

Assuming inputs are all valid it’s likely the ‘online repair’ issue. Searching that phrase on the forums will take you to the solution a few times over but effectively you need to take Windows/Excel through an online repair as the needed libraries aren’t present after windows updates for that node to run.

[leonard.moelders]

Please use the search function before creating a new topic on the same issue:

Dynamo not reading or exporting to excel

I have a few Dynamo scripts that either read an excel file or write to one. The scripts run fine on other machines, but on my machine, it will not read or write to excel. Is there some setting that I’m missing that toggles the read write function of external files like excel. I’m at the point where I am about to reimage the machine.

Data.ImportExcel operation failed

Tried this again today on my work computer, after a reboot, and still no joy. Rebuilt the graph from scratch in Revit 2021 (Dynamo 2.6.1) and still got the same error. Excel opens, but it does not go to the referenced sheet or read any data. Tried again tonight on my home computer, Revit 2022/Dynamo 2.10.1. Have not got around to setting up any packages on this version, but all of the nodes I was using were from Dynamo, so that was not an issue. Works fine at home. Slightly different versi…

Cannot Export File From Dynamo to Excel

[Doubt]

Import Export Excel not working in Microsoft 365

Generally you will need to run an online repair for microsoft excel. Windows updates take away a library they depend on using i think. Alternatively, try my excel nodes in Crumple package which i made to deal with this. In revit 2022+ the excelxml nodes should work reliably.

Otherwise our forum will consist of 25% “excel issue”-topics

[labonte.tmb]

thank you