Data.Import Excel

Revit
, ,
1

Hello,
I have a problem with node “Data.Import Excel”. “File From Path” node seem to be ok. I tested this script on other computers with the same Revit and Dynamo version and every other users has not this bug.

Revit 2020.2.9
Dynamo Core 2.3.2.15696
Dynamo Revit 2.3.2.15724

image
image1284×521 99.4 KB

2

@bartosz.wielogorskiT ,

can you do the workaround with

https://dictionary.dynamobim.com/#/Office/Excel/Action/ReadFromFile

KR

Andreas

3

I found a solution,
The bug was in Microsoft 365 Apps program.
I made "Online Repair " in Control Panel and node works well.

1 Like
4

Near 100% certainty this is an issue with your office installation; Basically every time you update office MS breaks it’s own registry keys causing the interop tool to fail. There are online repairs for this, but in my experience you will be fighting it at every update/patch/anything from MS for the rest of the life of the system.

There are some options on how to get working again.

  1. Utilize another format (CSV)
  2. Upgrade to a supported Revit/Dynamo build with the new OpenXML excel nodes
  3. Use a 3rd party package that leverages the OpenXML method (I think there is one called ExcelReader, but I can’t recall)

My advice is to go to CSV - you can open and save them with Excel natively, or import the data as a link to ensure formulas and such work.

5

Thank you for the advice.