Revit 2025, MIcrosoft.Office.Interop.Excel issue

rtorrez · February 8, 2025, 1:04pm

Hello everyone, I have started trying some of my scripts in revit 2025 and I got an error when I tried to load Microsoft.Office.Interop.Excel.

This only happens in revit 2025, 2024 and 2023 works fine, same pyRevit version.

I will appreciate any help on this

Regards

Script Executor Traceback:
System.IO.FileNotFoundException: Could not load file or assembly ‘Microsoft.Office.Interop.Excel, Version=11.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c’. The system cannot find the file specified.
File name: ‘Microsoft.Office.Interop.Excel, Version=11.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c’
at System.Reflection.RuntimeAssembly.g____PInvoke|49_0(NativeAssemblyNameParts* __pAssemblyNameParts_native, ObjectHandleOnStack __requestingAssembly_native, StackCrawlMarkHandle __stackMark_native, Int32 __throwOnFileNotFound_native, ObjectHandleOnStack __assemblyLoadContext_native, ObjectHandleOnStack __retAssembly_native)
at System.Reflection.RuntimeAssembly.InternalLoad(AssemblyName assemblyName, StackCrawlMark& stackMark, AssemblyLoadContext assemblyLoadContext, RuntimeAssembly requestingAssembly, Boolean throwOnFileNotFound)
at System.Reflection.Assembly.Load(String assemblyString)
at Microsoft.Scripting.PlatformAdaptationLayer.LoadAssembly(String name)
at IronPython.Runtime.ClrModule.AddReferenceByName(CodeContext context, String name)
at IronPython.Runtime.ClrModule.AddReferenceByName(CodeContext context, String names)
at Microsoft.Scripting.Interpreter.ActionCallInstruction2.Run(InterpretedFrame frame) at Microsoft.Scripting.Interpreter.Interpreter.Run(InterpretedFrame frame) at Microsoft.Scripting.Interpreter.LightLambda.Run4[T0,T1,T2,T3,TRet](T0 arg0, T1 arg1, T2 arg2, T3 arg3) at System.Dynamic.UpdateDelegates.UpdateAndExecute3[T0,T1,T2,TRet](CallSite site, T0 arg0, T1 arg1, T2 arg2) at Microsoft.Scripting.Interpreter.DynamicInstruction4.Run(InterpretedFrame frame)
at Microsoft.Scripting.Interpreter.Interpreter.HandleException(InterpretedFrame frame, Exception exception)
at Microsoft.Scripting.Interpreter.Interpreter.HandleException(InterpretedFrame frame, Exception exception)
at Microsoft.Scripting.Interpreter.Interpreter.Run(InterpretedFrame frame)
at Microsoft.Scripting.Interpreter.LightLambda.Run1[T0,TRet](T0 arg0)
at IronPython.Compiler.RuntimeScriptCode.InvokeTarget(Scope scope)
at IronPython.Runtime.PythonContext.InitializeModule(String fileName, ModuleContext moduleContext, ScriptCode scriptCode, ModuleOptions options)
at IronPython.Runtime.Importer.LoadFromDisk(CodeContext context, String name, String fullName, String str)
at IronPython.Runtime.Importer.ImportFromPathHook(CodeContext context, String name, String fullName, List path, Func5 defaultLoader) at IronPython.Runtime.Importer.ImportFromPath(CodeContext context, String name, String fullName, List path) at IronPython.Runtime.Importer.ImportTopAbsolute(CodeContext context, String name) at IronPython.Runtime.Importer.ImportModule(CodeContext context, Object globals, String modName, Boolean bottom, Int32 level) at IronPython.Modules.Builtin.__import__(CodeContext context, String name, Object globals, Object locals, Object fromlist, Int32 level) at IronPython.Runtime.Operations.PythonOps.ImportBottom(CodeContext context, String fullName, Int32 level) at Microsoft.Scripting.Interpreter.FuncCallInstruction4.Run(InterpretedFrame frame)
at Microsoft.Scripting.Interpreter.Interpreter.Run(InterpretedFrame frame)
at Microsoft.Scripting.Interpreter.LightLambda.Run2[T0,T1,TRet](T0 arg0, T1 arg1)
at IronPython.Compiler.PythonScriptCode.RunWorker(CodeContext ctx)
at IronPython.Compiler.PythonScriptCode.Run(Scope scope)
at IronPython.Compiler.RuntimeScriptCode.InvokeTarget(Scope scope)
at Microsoft.Scripting.Hosting.CompiledCode.Execute(ScriptScope scope)
at PyRevitLabs.PyRevit.Runtime.IronPythonEngine.Execute(ScriptRuntime& runtime)

sanzoghenzo · February 9, 2025, 7:04am

github.com/pyrevitlabs/pyRevit

[Bug]: Revit 2025 - Could not add reference to assembly Microsoft.Office.Interop.Excel

opened 10:39AM - 04 Feb 25 UTC

closed 06:27PM - 06 Feb 25 UTC

baaswietse

Bug

### ✈ Pre-Flight checks - [x] I **don't have SentinelOne** antivirus installed …(see above for the solution) - [x] I have **searched in the issues** (open and closed) but couldn't find a similar issue - [x] I have **searched in the [pyRevit Forum](https://discourse.pyrevitlabs.io)** for similar issues - [x] I already **followed the [installation troubleshooting guide](https://pyrevitlabs.notion.site/Installation-issues-f6495adb56254e9e8021f8a68e3b2ab7) thoroughly** - [x] I am using the **latest pyRevit Version** ### 🐞 Describe the bug After installing PyRevit v5.0.0 I get below error when trying to open a Excel file. I only get this error in Revit 2025, in other Revit version it works fine. Even tho they use the same IronPython engine and PyRevit version. ### ⌨ Error/Debug Message ```shell IronPython Traceback: Traceback (most recent call last): File "C:\Users\Wietse_d\Documents\Github\WYC-addins\WYC-addins-v2.extension\WYC V2.tab\Dev.panel\SharedParameters.pulldown\AddSharedParameters.pushbutton\script.py", line 11, in <module> IOError: System.IO.IOException: Could not add reference to assembly Microsoft.Office.Interop.Excel at IronPython.Runtime.ClrModule.AddReference(CodeContext context, String name) at IronPython.Runtime.ClrModule.AddReference(CodeContext context, Object[] references) at Microsoft.Scripting.Interpreter.ActionCallInstruction`2.Run(InterpretedFrame frame) at Microsoft.Scripting.Interpreter.Interpreter.Run(InterpretedFrame frame) at Microsoft.Scripting.Interpreter.LightLambda.Run4[T0,T1,T2,T3,TRet](T0 arg0, T1 arg1, T2 arg2, T3 arg3) at System.Dynamic.UpdateDelegates.UpdateAndExecute3[T0,T1,T2,TRet](CallSite site, T0 arg0, T1 arg1, T2 arg2) at Microsoft.Scripting.Interpreter.DynamicInstruction`4.Run(InterpretedFrame frame) at Microsoft.Scripting.Interpreter.Interpreter.Run(InterpretedFrame frame) at Microsoft.Scripting.Interpreter.LightLambda.Run2[T0,T1,TRet](T0 arg0, T1 arg1) at IronPython.Compiler.PythonScriptCode.RunWorker(CodeContext ctx) at IronPython.Compiler.RuntimeScriptCode.InvokeTarget(Scope scope) at Microsoft.Scripting.Hosting.CompiledCode.Execute(ScriptScope scope) at PyRevitLabs.PyRevit.Runtime.IronPythonEngine.Execute(ScriptRuntime& runtime) Script Executor Traceback: System.IO.IOException: Could not add reference to assembly Microsoft.Office.Interop.Excel at IronPython.Runtime.ClrModule.AddReference(CodeContext context, String name) at IronPython.Runtime.ClrModule.AddReference(CodeContext context, Object[] references) at Microsoft.Scripting.Interpreter.ActionCallInstruction`2.Run(InterpretedFrame frame) at Microsoft.Scripting.Interpreter.Interpreter.Run(InterpretedFrame frame) at Microsoft.Scripting.Interpreter.LightLambda.Run4[T0,T1,T2,T3,TRet](T0 arg0, T1 arg1, T2 arg2, T3 arg3) at System.Dynamic.UpdateDelegates.UpdateAndExecute3[T0,T1,T2,TRet](CallSite site, T0 arg0, T1 arg1, T2 arg2) at Microsoft.Scripting.Interpreter.DynamicInstruction`4.Run(InterpretedFrame frame) at Microsoft.Scripting.Interpreter.Interpreter.Run(InterpretedFrame frame) at Microsoft.Scripting.Interpreter.LightLambda.Run2[T0,T1,TRet](T0 arg0, T1 arg1) at IronPython.Compiler.PythonScriptCode.RunWorker(CodeContext ctx) at IronPython.Compiler.RuntimeScriptCode.InvokeTarget(Scope scope) at Microsoft.Scripting.Hosting.CompiledCode.Execute(ScriptScope scope) at PyRevitLabs.PyRevit.Runtime.IronPythonEngine.Execute(ScriptRuntime& runtime) ``` ### ♻️ To Reproduce Run below code in Revit 2025 ``` import os import clr clr.AddReference("Microsoft.Office.Interop.Excel") # <- Error apears on this line import Microsoft.Office.Interop.Excel as Excel from System.Runtime.InteropServices import Marshal ``` ### ⏲️ Expected behavior Being able to import Microsoft.Office.Interop.Excel ### 🖥️ Hardware and Software Setup (please complete the following information) ```shell ==> Registered Clones (full git repos) master | Deploy: "basepublic" | Branch: "master" | Version: "5.0.0.24174+2300" | Path: "C:\Users\Wietse_d\AppData\Roaming\pyRevit\pyRevit\master" ==> Registered Clones (deployed from archive/image) ==> Attachments master | Product: "Autodesk Revit 2025" | Engine: DEFAULT (2712) | Path: "C:\Users\Wietse_d\AppData\Roaming\pyRevit\pyRevit\master" master | Product: "2024.3" | Engine: DEFAULT (2712) | Path: "C:\Users\Wietse_d\AppData\Roaming\pyRevit\pyRevit\master" master | Product: "23.1.4" | Engine: DEFAULT (2712) | Path: "C:\Users\Wietse_d\AppData\Roaming\pyRevit\pyRevit\master" master | Product: "2022.1.5" | Engine: DEFAULT (2712) | Path: "C:\Users\Wietse_d\AppData\Roaming\pyRevit\pyRevit\master" master | Product: "2021.1.9" | Engine: DEFAULT (2712) | Path: "C:\Users\Wietse_d\AppData\Roaming\pyRevit\pyRevit\master" ==> Installed Extensions EF-Tools | Type: UIExtension | Repo: "https://github.com/ErikFrits/EF-Tools.git" | Installed: "C:\Users\Wietse_d\AppData\Roaming\pyRevit\Extensions\EF-Tools.extension" pyArchitect | Type: UIExtension | Repo: "https://github.com/romangolev/pyArchitect.git" | Installed: "C:\Users\Wietse_d\AppData\Roaming\pyRevit\Extensions\pyArchitect.extension" pyChilizer | Type: UIExtension | Repo: "https://github.com/dnenov/pyChilizer" | Installed: "C:\Users\Wietse_d\AppData\Roaming\pyRevit\Extensions\pyChilizer.extension" pySSG | Type: UIExtension | Repo: "https://github.com/kbruxvoort/SSG.extension.git" | Installed: "C:\Users\Wietse_d\AppData\Roaming\pyRevit\Extensions\pySSG.extension" WYC-addins | Type: Unknown | Repo: "" | Installed: "C:\Users\Wietse_d\Documents\Github\WDE-addins\WYC-addins.extension" WYC-addins-v2 | Type: Unknown | Repo: "" | Installed: "C:\Users\Wietse_d\Documents\Github\WYC-addins\WYC-addins-v2.extension" WYC-tools | Type: Unknown | Repo: "https://github.com/baaswietse/WYC-Tools.git" | Installed: "C:\Users\Wietse_d\AppData\Roaming\pyRevit\Extensions\WYC-tools.extension" ==> Default Extension Search Path C:\Users\Wietse_d\AppData\Roaming\pyRevit\Extensions ==> Extension Search Paths C:\Users\Wietse_d\Documents\Github\WDE-addins C:\Users\Wietse_d\Documents\Github\WYC-addins C:\Users\Wietse_d\AppData\Roaming\pyRevit\Extensions ==> Extension Sources - Default https://github.com/pyrevitlabs/pyRevit/raw/master/extensions/extensions.json ==> Extension Sources - Additional ==> Installed Revits Autodesk Revit 2025 | Version: 25.0.2.419 | Build: 20240307_1300(x64) | Language: 1033 | Path: "C:\Program Files\Autodesk\Revit 2025\" 2024.3 | Version: 24.3.0.13 | Build: 20240912_1515(x64) | Language: 1033 | Path: "C:\Program Files\Autodesk\Revit 2024\" 23.1.4 | Version: 23.1.40.56 | Build: 20240411_0945(x64) | Language: 1033 | Path: "C:\Program Files\Autodesk\Revit 2023\" 2022.1.5 | Version: 22.1.50.17 | Build: 20230915_1530(x64) | Language: 1033 | Path: "C:\Program Files\Autodesk\Revit 2022\" 2021.1.9 | Version: 21.1.90.15 | Build: 20230907_1515(x64) | Language: 1033 | Path: "C:\Program Files\Autodesk\Revit 2021\" ==> Running Revit Instances PID: 22008 | 2025.4 | Version: 25.4.0.32 | Build: 20241202_1040(x64) | Language: 0 | Path: "C:\Program Files\Autodesk\Revit 2025" PID: 25668 | 23.1.4 | Version: 23.1.40.56 | Build: 20240411_0945(x64) | Language: 0 | Path: "C:\Program Files\Autodesk\Revit 2023" ==> User Environment Microsoft Windows 10 [Version 10.0.26100] Executing User: WYCKAERT\Wietse_D Active User: WYCKAERT\Wietse_D Admin Access: No %APPDATA%: "C:\Users\Wietse_d\AppData\Roaming" Latest Installed .Net Framework: 8.0.12 Installed .Net Target Packs: v4.0 v4.5 v4.5.1 v4.5.2 v4.6 v4.6.1 v4.7.2 v4.8 v4.X Installed .Net-Core Target Packs: v8.0.204 v8.0.206 pyRevit CLI v5.0.0.25034+1521.5254fce169ea7164f9452751d9c91c580e45ef5b ``` ### Additional context _No response_

AlexanderVDB · May 21, 2025, 3:41pm

hej @sanzoghenzo & @rtorrez ,
for me this issues does not seems to be resolved.
my script still work in revit 2023 as it did before but 2025 is still bugged and not adding the reference to assembly.
Ps.: i am using the lastest version of pyrevit to date: [pyRevit v5.1.0 - Revit 2026 Support]

this is my code and error:

# -*- coding: utf-8 -*-

"""

Excel utility functions for reading and writing data to Excel files.

"""

# ===================================================

# IMPORTS

# ===================================================

import clr, os, sys, shutil

# Add .NET Interop Reference

clr.AddReference('Microsoft.Office.Interop.Excel')

from Microsoft.Office.Interop import Excel # type: ignore

ERROR:

IronPython Traceback:
Traceback (most recent call last):
 File "C:\Users\AlexanderV\AppData\Roaming\pyRevit\Extensions\BBpy\BBpy.extension\BBpy.tab\Import & Export.panel\Schedules.stack\ExportMS.Pushbutton\script.py", line 24, in <module>
 File "C:\Users\AlexanderV\AppData\Roaming\pyRevit\Extensions\BBpy\BBpy.extension\lib\excelUtils.py", line 12, in <module>
IOError: System.IO.IOException: Could not add reference to assembly Microsoft.Office.Interop.Excel
 at IronPython.Runtime.ClrModule.AddReference(CodeContext context, String name)
 at IronPython.Runtime.ClrModule.AddReference(CodeContext context, Object[] references)
 at Microsoft.Scripting.Interpreter.ActionCallInstruction`2.Run(InterpretedFrame frame)
 at Microsoft.Scripting.Interpreter.Interpreter.Run(InterpretedFrame frame)
 at Microsoft.Scripting.Interpreter.LightLambda.Run4[T0,T1,T2,T3,TRet](T0 arg0, T1 arg1, T2 arg2, T3 arg3)
 at System.Dynamic.UpdateDelegates.UpdateAndExecute3[T0,T1,T2,TRet](CallSite site, T0 arg0, T1 arg1, T2 arg2)
 at IronPython.Compiler.Ast.CallExpression.Invoke1Instruction.Run(InterpretedFrame frame)
 at Microsoft.Scripting.Interpreter.Interpreter.Run(InterpretedFrame frame)
 at Microsoft.Scripting.Interpreter.LightLambda.Run1[T0,TRet](T0 arg0)
 at IronPython.Compiler.RuntimeScriptCode.InvokeTarget(Scope scope)
 at IronPython.Runtime.PythonContext.InitializeModule(String fileName, ModuleContext moduleContext, ScriptCode scriptCode, ModuleOptions options)
 at IronPython.Runtime.Importer.LoadFromDisk(CodeContext context, String name, String fullName, String str)
 at IronPython.Runtime.Importer.ImportFromPathHook(CodeContext context, String name, String fullName, List path, Func`5 defaultLoader)
 at IronPython.Runtime.Importer.ImportFromPath(CodeContext context, String name, String fullName, List path)
 at IronPython.Runtime.Importer.ImportTopAbsolute(CodeContext context, String name)
 at IronPython.Runtime.Importer.ImportModule(CodeContext context, Object globals, String modName, Boolean bottom, Int32 level)
 at IronPython.Modules.Builtin.__import__(CodeContext context, String name, Object globals, Object locals, Object fromlist, Int32 level)
 at IronPython.Runtime.Importer.ImportLightThrow(CodeContext context, String fullName, PythonTuple from, Int32 level)
 at Microsoft.Scripting.Interpreter.FuncCallInstruction`5.Run(InterpretedFrame frame)
 at Microsoft.Scripting.Interpreter.Interpreter.Run(InterpretedFrame frame)
 at Microsoft.Scripting.Interpreter.LightLambda.Run2[T0,T1,TRet](T0 arg0, T1 arg1)
 at IronPython.Compiler.PythonScriptCode.RunWorker(CodeContext ctx)
 at IronPython.Compiler.RuntimeScriptCode.InvokeTarget(Scope scope)
 at Microsoft.Scripting.Hosting.CompiledCode.Execute(ScriptScope scope)
 at PyRevitLabs.PyRevit.Runtime.IronPythonEngine.Execute(ScriptRuntime& runtime)

Script Executor Traceback:
System.IO.IOException: Could not add reference to assembly Microsoft.Office.Interop.Excel
 at IronPython.Runtime.ClrModule.AddReference(CodeContext context, String name)
 at IronPython.Runtime.ClrModule.AddReference(CodeContext context, Object[] references)
 at Microsoft.Scripting.Interpreter.ActionCallInstruction`2.Run(InterpretedFrame frame)
 at Microsoft.Scripting.Interpreter.Interpreter.Run(InterpretedFrame frame)
 at Microsoft.Scripting.Interpreter.LightLambda.Run4[T0,T1,T2,T3,TRet](T0 arg0, T1 arg1, T2 arg2, T3 arg3)
 at System.Dynamic.UpdateDelegates.UpdateAndExecute3[T0,T1,T2,TRet](CallSite site, T0 arg0, T1 arg1, T2 arg2)
 at IronPython.Compiler.Ast.CallExpression.Invoke1Instruction.Run(InterpretedFrame frame)
 at Microsoft.Scripting.Interpreter.Interpreter.Run(InterpretedFrame frame)
 at Microsoft.Scripting.Interpreter.LightLambda.Run1[T0,TRet](T0 arg0)
 at IronPython.Compiler.RuntimeScriptCode.InvokeTarget(Scope scope)
 at IronPython.Runtime.PythonContext.InitializeModule(String fileName, ModuleContext moduleContext, ScriptCode scriptCode, ModuleOptions options)
 at IronPython.Runtime.Importer.LoadFromDisk(CodeContext context, String name, String fullName, String str)
 at IronPython.Runtime.Importer.ImportFromPathHook(CodeContext context, String name, String fullName, List path, Func`5 defaultLoader)
 at IronPython.Runtime.Importer.ImportFromPath(CodeContext context, String name, String fullName, List path)
 at IronPython.Runtime.Importer.ImportTopAbsolute(CodeContext context, String name)
 at IronPython.Runtime.Importer.ImportModule(CodeContext context, Object globals, String modName, Boolean bottom, Int32 level)
 at IronPython.Modules.Builtin.__import__(CodeContext context, String name, Object globals, Object locals, Object fromlist, Int32 level)
 at IronPython.Runtime.Importer.ImportLightThrow(CodeContext context, String fullName, PythonTuple from, Int32 level)
 at Microsoft.Scripting.Interpreter.FuncCallInstruction`5.Run(InterpretedFrame frame)
 at Microsoft.Scripting.Interpreter.Interpreter.Run(InterpretedFrame frame)
 at Microsoft.Scripting.Interpreter.LightLambda.Run2[T0,T1,TRet](T0 arg0, T1 arg1)
 at IronPython.Compiler.PythonScriptCode.RunWorker(CodeContext ctx)
 at IronPython.Compiler.RuntimeScriptCode.InvokeTarget(Scope scope)
 at Microsoft.Scripting.Hosting.CompiledCode.Execute(ScriptScope scope)
 at PyRevitLabs.PyRevit.Runtime.IronPythonEngine.Execute(ScriptRuntime& runtime)

Jean-Marc · May 21, 2025, 7:07pm

Try using pyRevit/site-packages/xlsxwriter at 9e1ccbc5ba5a81dfb03de279ca156caa963ea119 · pyrevitlabs/pyRevit · GitHub

And have a look at all the linked refered in the issue. Plenty of other ways to solve the PB.

AlexanderVDB · May 21, 2025, 7:26pm

@Jean-Marc thx, i always just read the issue on github and foudn the xl, xlrd and xlwriter modules.
i have for tool long been avoinding and now that i use them they are so much easier then i thought .

I read the article from Gavincrump on the dynamo forums, concering the Cpython situation.
What is your feedback on this?
Should it be best to convert all my scripts to Cpython (engine)?
How ould i then best approach UI elements in scripts?

thx for the answer, i’ll close the issues here.

Jean-Marc · May 21, 2025, 7:44pm

I would not go the cpython road just now. Not close to being ready. I have bigger hopes around Autodesk releasing eventually an open source pythonnet3 engine, the one they develop for dynamo (this is an option but not settled on the dynamo/Autodesk team side from my latest discussions with Sol)

UI wise, personally I keep thinks simple and use the forms module extensively. You can understand my reluctance to go to cpython.

AlexanderVDB · May 23, 2025, 6:54pm

Hi Jean-Marc,

what is the way to go for writing in an existing excel file?
I don’t see any functionality for in that in the interop.xl nor in the xlsxwriter.
They only write new excel files.

i was able to create create a lot of excel read script and i’m now working on the write side of things but can’t seems to find alot of material on this.