Hi every one, ive done the latest Windows Update wich name is :
Im suspecting an error on Excel since last friday.
Error appear with Revit 2020, 2021, 2022. ( dynamo 2.3, 2.5 and 2.10)
Any suggestions ?
Thanks
You are accessing/writing a single file via 2 processes.
One of the two will surely throw an error.
Just use one process at a time.
-biboy
Same error without csv export
According to my experience, that error occurs when the excel file is opened by another application or two or more Dynamo node is trying to access the same file.
Please make sure that there are no other application opens the excel file (not even Microsoft Excel) and only one node is saving the file.
-biboy
Not in this case. Thank for your help @blsalvio . Have a nice day !
I think there’s a link with visual basic in the last microsoft Update.
But i don’t understand what.
Any suggestion for fixing this excel error ? @Kulkul @Alban_de_Chasteigner @solamour
Thanks
Best regards
Hello Jonathan,
The following is a few tips from @Michael_Kirschner2 :
When you install office - make sure you select “.net programability” feature for excel see: Install Office primary interop assemblies - Visual Studio (Windows) | Microsoft Learn
If that does not work - try installing:
you should not need them - they should have been installed with excel… but this is worth a shot:
https://www.microsoft.com/en-us/download/details.aspx?id=3508
Otherwise, please have a read of this thread where Mike offers a few other suggestions: Import Excel Exception Could not load file or assembly 'Microsoft.Office.Interop.Excel, Version=15.0.0.0 · Issue #11632 · DynamoDS/Dynamo · GitHub
I found the solution with IT : make sure your 64 bit Office version correspond to your exploitation system (64bits).
In my case, excel run in 32 bits overwise windows is 64bit.
Once 32 bit version removed and the other Office
version installed, problem disappear.
Import and export data works both of them.
Best regards
2 Likes