Importing Excel data into Dynamo

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

Could you tell us what’s your:

  • Dynamo Version
  • Revit Version
  • Microsoft Office Version

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.

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

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