Something wrong when using Microsoft.Office.Interop.Excel in Revit 2025, Dynamo 3.0.2

c.poupin · April 17, 2024, 6:39am

Hi,

Interrop still works, but Net Core don’t have access to the Global Assembly Cache GAC

I recently updated an example here for Net 8 compatibility

Cyril-Pop/IronPython-Samples/blob/master/Excel Interop/Import_Export_Xls_v6.0.py

# update 15/04/2023 for ipy3
# update 28/07/2023 for .Net 6
import clr
import sys
import System
clr.AddReference("System.Numerics")
from System import Array
from System.Collections.Generic import *

clr.AddReference('System.Drawing')
import System.Drawing
from System.Drawing import *

clr.AddReference('System.Data')
from System.Data import *


from System.Runtime.InteropServices import Marshal
# lst Enum Values
class ExcelEnum:

This file has been truncated. show original

Pandas, openpyxl and Openxml are also viable solutions

Topic		Replies	Views
DynamoIronPython2.7 Package for Dynamo 3 in Revit 2025 Developers python , package	12	578	June 1, 2024
Revit 2026 / Microsoft Excel problems Revit	9	176	September 2, 2025
ExcelInterop vs OpenXML in CPython3 Developers excel	25	1139	August 20, 2025
The future of Dynamo (for Revit) : Python IronPython? Developers	8	4337	December 22, 2017
R25/Dynamo 3.3 & IronPython Revit revit , python , dynamo	4	124	March 10, 2025

Something wrong when using Microsoft.Office.Interop.Excel in Revit 2025, Dynamo 3.0.2

Related topics