topic Robot Structural Analysis 2025-Close Excel Dynamo in Robot Structural Analysis Forum

Robot Structural Analysis 2025-Close Excel Dynamo

stefanyC6JZ7 — Mon, 05 Aug 2024 15:13:53 GMT

Hello everyone,
I am trying to use RSA2025 to run dynamo scripts. I am trying to close Excel with the script but I get the following error:

Please find the code from the script below :

import sys import clr import System clr.AddReference('Microsoft.Office.Interop.Excel, Version=15.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c') from Microsoft.Office.Interop import Excel from System.Runtime.InteropServices import Marshal def excel_close(lst_namefile): xlApp = Excel.Application(Marshal.GetActiveObject("Excel.Application")) print(xlApp) allWorkbooks = Excel.Workbooks(xlApp.get_Workbooks()) print([x for x in allWorkbooks]) lst_WkbsName = [Excel.Workbook(x).get_Name() for x in allWorkbooks] for namefile in lst_namefile: if namefile in lst_WkbsName: Tesluiten = Excel.Workbook(allWorkbooks.get_Item(namefile)) Tesluiten.Close() xlApp.Quit() toList = lambda x : x if isinstance(x, list) else [x] OUT = excel_close(toList(IN[0]))

Could you please help me solving this issue?

Best regards,
Stefany

Re: Robot Structural Analysis 2025-Close Excel Dynamo

1234eddie — Tue, 06 Aug 2024 09:15:05 GMT

Hi All,

just to add a little bit extra information.

Here is the full error message

Message

FileNotFoundException : Unable to find assembly ‘Microsoft.Office.Interop.Excel, Version=15.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c’. at Python.Runtime.CLRModule.AddReference(String name)

at System.RuntimeMethodHandle.InvokeMethod(Object target, Void** arguments, Signature sig, Boolean isConstructor)

at System.Reflection.MethodBaseInvoker.InvokeDirectByRefWithFewArgs(Object obj, Span`1 copyOfArgs, BindingFlags invokeAttr) [’ File "

Version Dynamo RSA 2022 runs fine.

Version Dynamo RSA 2025

I hope @okapawal @Rafal.Gaweda or maybe others can have a quick look at this?

Many thanks in advance

Gr Edward

Re: Robot Structural Analysis 2025-Close Excel Dynamo

okapawal — Tue, 06 Aug 2024 09:23:59 GMT

@1234eddie
Can you check or post it n the Dynamo Forum ? Dynamo (dynamobim.com)

It is rather Dynamo core issue.