Importing Excel data into Dynamo

Revit
, ,
1

I am getting an error while importing the excel into dynamo.

  • Warning: Data.ImportExcel operation failed.
    Could not load file or assembly ‘Microsoft.Office.Interop.Excel, Version=15.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c’ or one of its dependencies. The system cannot find the file specified.

Kindly help me out and provide me the solution for this

2

Could you tell us what’s your:

  • Dynamo Version
  • Revit Version
  • Microsoft Office Version
3
4

I had this problem today. After reading this thread tested in Revit 2020.2.4 Dynamo 2.3, Office 16, but no problem for Revit 2021. I got the error that @mzjensen posted, and his linked thread fix worked. I ran the office updater and the problem went away in 2020.

5

We have just released some OpenXML nodes which mean you can read and write .XLSX nodes without Excel installed in Dynamo Core 2.12 :slight_smile: Available in Dynamo Sandbox now, and your favourite host soon!

You can read about it here: Dynamo Core 2.12 Release - Part 1/2 - Dynamo BIM

3 Likes
6

This will be cool. I have hopped on a VM to test in the production environment many times and have been given errors because I haven’t logged into Office yet on the machine.

1 Like
7

Issue still persists in

Revit 2022.1
Dynamo 2.12
Office 365 - Excel version 2111

The import and write to excel nodes fail.

OpenXML versions work though with XLSX files.

1 Like