Warning: Data.ImportExcel operation failed

[eysk46551]

I’m using the Dinamo plugin on Revit 2022, and every time I try to Import an Excel file, I get the warning Data.ImportExcel operation failed.

I’ve been trying to figure out what’s wrong, but nothing seems to work. what could I possibly do to fix this problem?

[pyXam]

This could possibly be your fix?
https://www.autodesk.com/support/technical/article/caas/sfdcarticles/sfdcarticles/Warning-Data-ImportExcel-operation-failed-Could-not-load-file-or-assembly-Microsoft-Office-Interop-Excel-when-running-the-Dynamo-script-in-Revit.html

But try this fix first.

Data.ImportExcel operation failed

Hello, My firm uses a Citrix virtual environment to connect to projects around the globe. We are running multiple versions of Revit, MS Office 2016, among many other applications in a Windows 10 environment. We have run across an issue trying to use Excel nodes in Dynamo. I have a very simple script utilizing the Data.ImportExcel node but I receive the ‘Warning: Data.ImportExcel operation failed.’. Nodes for writing to Excel don’t work as well. My only hunch is that the node is trying to m…