# Export.Data

**URL:** <https://forum.dynamobim.com/t/export-data/63035>\
**Category:** Developers\
**Tags:** excel, dynamo, windows\
**Created:** [April 19, 2021, 2:27pm UTC](https://forum.dynamobim.com/t/export-data/63035 "2021-04-19T14:27:17Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![jonathan.riboud](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/jonathan.riboud/32/94974_2.png) [@jonathan.riboud](https://forum.dynamobim.com/u/jonathan.riboud)\
**Post date:** [April 19, 2021, 2:27pm UTC](https://forum.dynamobim.com/t/export-data/63035/1 "2021-04-19T14:27:17Z")

</div>

![Revit_IBcbOLr35i](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/2/1/21b671cd40b3abff892fe8991aeb8142b164c11c.png)

Hi every one, ive done the latest Windows Update wich name is :

 ![ApplicationFrameHost_TEqFOl4aqO](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/5/3/53b6b04e6ba17b01ecfe3855fe751d9a9d4d6efa.png)

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

---

<div class="post-metadata">

**Author:** ![blsalvio](https://avatars.discourse-cdn.com/v4/letter/b/ad7895/32.png) [@blsalvio](https://forum.dynamobim.com/u/blsalvio)\
**Post date:** [April 20, 2021, 12:23am UTC](https://forum.dynamobim.com/t/export-data/63035/2 "2021-04-20T00:23:15Z")

</div>

Hi @jonathan.riboud

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

---

<div class="post-metadata">

**Author:** ![jonathan.riboud](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/jonathan.riboud/32/94974_2.png) [@jonathan.riboud](https://forum.dynamobim.com/u/jonathan.riboud)\
**Post date:** [April 21, 2021, 7:31am UTC](https://forum.dynamobim.com/t/export-data/63035/3 "2021-04-21T07:31:34Z")

</div>

Same error without csv export

---

<div class="post-metadata">

**Author:** ![blsalvio](https://avatars.discourse-cdn.com/v4/letter/b/ad7895/32.png) [@blsalvio](https://forum.dynamobim.com/u/blsalvio)\
**Post date:** [April 21, 2021, 7:42am UTC](https://forum.dynamobim.com/t/export-data/63035/4 "2021-04-21T07:42:13Z")

</div>

hi @jonathan.riboud

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

---

<div class="post-metadata">

**Author:** ![jonathan.riboud](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/jonathan.riboud/32/94974_2.png) [@jonathan.riboud](https://forum.dynamobim.com/u/jonathan.riboud)\
**Post date:** [April 21, 2021, 7:46am UTC](https://forum.dynamobim.com/t/export-data/63035/5 "2021-04-21T07:46:58Z")

</div>

![Revit_RbPpVylNPH](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/3/8/382d61c5b4a8ca5e04a158cc9c96d30466393c4c.png)

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.

---

<div class="post-metadata">

**Author:** ![jonathan.riboud](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/jonathan.riboud/32/94974_2.png) [@jonathan.riboud](https://forum.dynamobim.com/u/jonathan.riboud)\
**Post date:** [May 4, 2021, 1:04pm UTC](https://forum.dynamobim.com/t/export-data/63035/6 "2021-05-04T13:04:25Z")

</div>

Any suggestion for fixing this excel error ? @Kulkul @Alban_de_Chasteigner@solamour  
Thanks

Best regards

---

<div class="post-metadata">

**Author:** ![solamour](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/solamour/32/153516_2.png) [@solamour](https://forum.dynamobim.com/u/solamour)\
**Post date:** [May 4, 2021, 6:28pm UTC](https://forum.dynamobim.com/t/export-data/63035/7 "2021-05-04T18:28:30Z")

</div>

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](https://docs.microsoft.com/en-us/visualstudio/vsto/how-to-install-office-primary-interop-assemblies?view=vs-2019)

> 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](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](https://github.com/DynamoDS/Dynamo/issues/11632)

---

<div class="post-metadata">

**Author:** ![jonathan.riboud](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/jonathan.riboud/32/94974_2.png) [@jonathan.riboud](https://forum.dynamobim.com/u/jonathan.riboud)\
**Post date:** [May 5, 2021, 5:34am UTC](https://forum.dynamobim.com/t/export-data/63035/8 "2021-05-05T05:34:02Z")

</div>

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
