Data.ImportExcel operation failed

Revit
42

Perfect! This worked for me after searching for many days on this issue. Thanks.

43

Tried this again today on my work computer, after a reboot, and still no joy. Rebuilt…

Just noticed I never came back with what worked for me. Repairing Office did not fix the Dynamo issue, or the macros issue, for me. We finally did a clean uninstall of Office and then reinstalled it. Both the Dynamo read node and macros in Excel worked after that.

44

I had a similar problem,

I found a package at dynamo named “ExcelReader” with the node ExcelFile.Read, it does pretty much the same thing as “Data.ImportExel”, but it works.

Just need to take care with the data output, this node already transpose the list.

image
image445×517 42 KB