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…

Could you tell us what’s your: Dynamo Version Revit Version Microsoft Office Version

[image] Excel Data.ImportExcel operation Failed Revit Anyone having Excel import trouble today? Computer ran windows updates 2 days ago and suddenly I cant import Excel. note that i also installed Autocad and Navisworks 2022 yesterday as well. This is Revit 2020 - Dyna…

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 @zachri.jensen 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

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.

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.

Importing Excel data into Dynamo

Revit

mzjensen July 27, 2021, 6:05pm 3

Topic		Replies	Views
Warning: Data.ImportExcel operation failed Revit excel , dynamo	1	529	June 12, 2023
Warning: Data.ImportExcel operation failed. Excel is not installed Uncategorized	15	1950	February 21, 2021
Import info from Excel? Data.ImportExcel operation Failed Revit revit , excel , importinstance , dynamo , levels	21	16167	September 20, 2023
Export to Excel Not Working? Uncategorized	17	3123	July 17, 2023
Data.OpenXMLExportExcel is throwing errors overnight Revit revit , excel , dynamo	6	328	May 25, 2025

Importing Excel data into Dynamo

Related topics