Import Excel Exception Could not load file or assembly 'Microsoft.Office.Interop.Excel, Version=15.0.0.0

[mohd-dxb]

Hi,

I'm not able to Read Excel from Dynamo Sandbox 2.10 or 2.11. I'm getting this error: I downloaded latest v15 Microsoft.Office.Interop.Excel.dll from Nuget and pasted in DynamoSandbox folder but still the same issue.

Thanks & Regards,

[github-actions[bot]]

Hello Kulkul7536, thank you for submitting this issue! We are super excited that you want to help us make Dynamo all that it can be. However, given that there has been no additional information added, this issue will be closed for now. Please reopen and provide additional information if you wish the Dynamo team to investigate further.

Additional information:

• Filling in of the provided Template (What did you do, What did you expect to see, What did you see instead, What packages or external references (if any) were used)
• Attaching the Stack Trace (Error message that shows up when Dynamo crashes - You can copy and paste this into the Github Issue)
• Upload a .DYN file that showcases the issue in action and any additional needed files, such as Revit (Note: If you cannot share a project, you can recreate this in a quick mock-up file)
• Upload a Screenshot of the error messages you see (Hover over the offending node and showcase said errors message in the screenshot)
• Reproducible steps on how to create the error in question.

[mohd-dxb]

Hi,

I'm not able to Read Excel from Dynamo Sandbox 2.10 or 2.11. I'm getting this error: I downloaded latest v15 Microsoft.Office.Interop.Excel.dll from Nuget and pasted in DynamoSandbox folder but still the same issue.

Thanks & Regards,

[mjkkirschner]

Hi @Kulkul7536 - I think theres a few things going on.

1. can you try installing https://www.microsoft.com/en-us/download/details.aspx?id=3508
2. what version of excel do you have installed? Can you try repairing the install, and making sure you install interop assemblies with it - it may be an option during install.
3. checkout hints here: https://knowledge.autodesk.com/support/revit-products/troubleshooting/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
4. when you copy the dll from nuget - make sure you unblock it. - I don't have faith in this solution.

[mohd-dxb]

Hi @mjkkirschner

Thanks for replying,

1. Yes i did try installing https://www.microsoft.com/en-us/download/details.aspx?id=3508. Still the same error.
2. Office 2013.
3. I tried to repair excel like shown on the link but i din't find any dll files in C:\Windows\Assemblies...
4. Not sure what you mean by copy the dll from nuget?

Best Regards, ~Kulkul

[mjkkirschner]

Hi @Kulkul7536 you said:

I downloaded latest v15 Microsoft.Office.Interop.Excel.dll from Nuget and pasted in DynamoSandbox folder but still the same issue.

I don't think that is a great solution because:

• the dll should come with excel, if it's not installed, there might be other missing components as well.
• the dll might be blocked, you downloaded it from nuget's website I guess, so it might have "mark of the web" - for example: https://stackoverflow.com/questions/4103683/problem-unblocking-assemblies-in-windows-7-home-premium/4103806

please see this thread regarding 2013: https://social.msdn.microsoft.com/Forums/sqlserver/en-US/3c74d31d-9c2a-49a4-accf-135267f11984/where-to-find-office-2013-pias-for-install?forum=vsto

it sounds like there is a particular checkbox during install to look for.

[mohd-dxb]

Hi @mjkkirschner

I downloaded v15 because of the exception, it requires v15. Another thing i noticed Excel node works fine with Revit 2019-2021. I get this excel error with Revit 2022, DynamoSandbox 2.10 and DynamoSandbox 2.11. I hope there has been no changes in the development in newer versions?

When i click on Change i get these checkboxes: And when i click on Add/Remove Features i get these. I installed them but still the same error:

[mjkkirschner]

Yes, that seems to be the option .Net Programmability Support, is it installed?

[mohd-dxb]

Yes it is installed but i didn't find any assembly: And when i run dynamo the same exception appears.

[mohd-dxb]

@mjkkirschner any other workaround?

[mjkkirschner]

Not that I know of @Kulkul7536 - I think we need to find out why your excel install refuses to install the interop binaries as part of it's install or repair process.

There could be some group policy on the machine to stop this feature from working I think.

Otherwise you can try your original solution by getting the binary from nuget - but make sure to unblock the resulting binary.

[mjkkirschner]

@Kulkul7536 we just saw this internally on a system, and a restart and excel update fixed it. Maybe give that a shot?

[mohd-dxb]

Thanks @mjkkirschner nah restarting didn't fix. Excel Update - How can I update excel alone?