# Need Help about import data form excel

**URL:** <https://forum.dynamobim.com/t/need-help-about-import-data-form-excel/77058>\
**Category:** Lists-Logic\
**Tags:** excel, dynamo\
**Created:** [May 29, 2022, 11:49pm UTC](https://forum.dynamobim.com/t/need-help-about-import-data-form-excel/77058 "2022-05-29T23:49:49Z")\
**Posts on this page:** 11\
**Page:** 1

<div class="post-metadata">

**Author:** ![hassanshaheen200424](https://avatars.discourse-cdn.com/v4/letter/h/aeb1de/32.png) [@hassanshaheen200424](https://forum.dynamobim.com/u/hassanshaheen200424)\
**Post date:** [May 29, 2022, 11:49pm UTC](https://forum.dynamobim.com/t/need-help-about-import-data-form-excel/77058/1 "2022-05-29T23:49:49Z")

</div>

plz any one help me i am trying to make script with dynamo to get data from excel i saw a lot of videos how to make it but i face a problem when i make string to write the name of work sheet in it and connect it with the excell data window it show me error … no one told me that the name of work sheet is not correct because i am sure of name and changed it many times

 ![00](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/9/5/95a22ce7aafd1372a9a614568873d4a0ebf1f93a.png)

---

<div class="post-metadata">

**Author:** ![WrightEngineering](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/wrightengineering/32/115676_2.png) [@WrightEngineering](https://forum.dynamobim.com/u/WrightEngineering)\
**Post date:** [May 29, 2022, 11:51pm UTC](https://forum.dynamobim.com/t/need-help-about-import-data-form-excel/77058/2 "2022-05-29T23:51:27Z")

</div>

Can you show what the error is?

---

<div class="post-metadata">

**Author:** ![GavinNicholls](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/gavinnicholls/32/190442_2.png) [@GavinNicholls](https://forum.dynamobim.com/u/GavinNicholls)\
**Post date:** [May 30, 2022, 12:19am UTC](https://forum.dynamobim.com/t/need-help-about-import-data-form-excel/77058/3 "2022-05-30T00:19:05Z")

</div>

I’m going to go out on a limb and guess this might be due to the typical repair issue. It looks like you’re using Revit 2023 so try the XML alternative node instead which is in that build of Dynamo.

Also you can try my Import Excel nodes in Crumple which I made to solve similar issues:

![image](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/2/3/23a65374b2131c8df2cd629ede1da9dc5285d6f3.png)

---

<div class="post-metadata">

**Author:** ![hassanshaheen200424](https://avatars.discourse-cdn.com/v4/letter/h/aeb1de/32.png) [@hassanshaheen200424](https://forum.dynamobim.com/u/hassanshaheen200424)\
**Post date:** [May 30, 2022, 2:34pm UTC](https://forum.dynamobim.com/t/need-help-about-import-data-form-excel/77058/4 "2022-05-30T14:34:15Z")

</div>

![00](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/d/a/da5e23a839a1086848ae45e7d7f306a462d2a2d8.png)

---

<div class="post-metadata">

**Author:** ![hassanshaheen200424](https://avatars.discourse-cdn.com/v4/letter/h/aeb1de/32.png) [@hassanshaheen200424](https://forum.dynamobim.com/u/hassanshaheen200424)\
**Post date:** [May 30, 2022, 2:44pm UTC](https://forum.dynamobim.com/t/need-help-about-import-data-form-excel/77058/5 "2022-05-30T14:44:57Z")

</div>

![00](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/e/4/e41b977cddfd3c1803890443fb196838d73a35be.png)  
Same problem despite the file has a data

---

<div class="post-metadata">

**Author:** ![Daan](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/daan/32/82246_2.png) [@Daan](https://forum.dynamobim.com/u/Daan)\
**Post date:** [May 30, 2022, 4:09pm UTC](https://forum.dynamobim.com/t/need-help-about-import-data-form-excel/77058/6 "2022-05-30T16:09:11Z")

</div>

I would assume that the problem lies with your Office installation.  
Have you tried reinstalling your Office ?

---

<div class="post-metadata">

**Author:** ![hassanshaheen200424](https://avatars.discourse-cdn.com/v4/letter/h/aeb1de/32.png) [@hassanshaheen200424](https://forum.dynamobim.com/u/hassanshaheen200424)\
**Post date:** [May 30, 2022, 7:24pm UTC](https://forum.dynamobim.com/t/need-help-about-import-data-form-excel/77058/7 "2022-05-30T19:24:17Z")

</div>

no but i will try it but what is the problem with my office ?

---

<div class="post-metadata">

**Author:** ![hassanshaheen200424](https://avatars.discourse-cdn.com/v4/letter/h/aeb1de/32.png) [@hassanshaheen200424](https://forum.dynamobim.com/u/hassanshaheen200424)\
**Post date:** [May 30, 2022, 7:33pm UTC](https://forum.dynamobim.com/t/need-help-about-import-data-form-excel/77058/8 "2022-05-30T19:33:32Z")

</div>

it works i am really really don’t know how i can thank u 😍 😍 😍

---

<div class="post-metadata">

**Author:** ![GavinNicholls](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/gavinnicholls/32/190442_2.png) [@GavinNicholls](https://forum.dynamobim.com/u/GavinNicholls)\
**Post date:** [May 30, 2022, 7:50pm UTC](https://forum.dynamobim.com/t/need-help-about-import-data-form-excel/77058/9 "2022-05-30T19:50:53Z")

</div>

Hrm bummer. Seems like there’s a few things that prevent the excel nodes, I’ve had mixed results depending on install states of Excel. Ah well, glad you got it to work!

---

<div class="post-metadata">

**Author:** ![WrightEngineering](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/wrightengineering/32/115676_2.png) [@WrightEngineering](https://forum.dynamobim.com/u/WrightEngineering)\
**Post date:** [May 31, 2022, 3:01am UTC](https://forum.dynamobim.com/t/need-help-about-import-data-form-excel/77058/10 "2022-05-31T03:01:12Z")

</div>

Yeah I’ve seen office installations as well as a certain version of navisworks causing the issue.

---

<div class="post-metadata">

**Author:** ![Dean.kichenbrand](https://avatars.discourse-cdn.com/v4/letter/d/b38774/32.png) [@Dean.kichenbrand](https://forum.dynamobim.com/u/Dean.kichenbrand)\
**Post date:** [September 2, 2022, 7:38am UTC](https://forum.dynamobim.com/t/need-help-about-import-data-form-excel/77058/11 "2022-09-02T07:38:23Z")

</div>

I had the same problem and fixed it by going to the extension tab en selecting Workspace References and was told DynamoIronPython was not installed, Installed it and it worked.
