# I have a writing problem in excel with dynamo

**URL:** <https://forum.dynamobim.com/t/i-have-a-writing-problem-in-excel-with-dynamo/104597>\
**Category:** Revit\
**Tags:** excel, dynamo\
**Created:** [September 24, 2024, 9:34am UTC](https://forum.dynamobim.com/t/i-have-a-writing-problem-in-excel-with-dynamo/104597 "2024-09-24T09:34:07Z")\
**Posts on this page:** 9\
**Page:** 1

<div class="post-metadata">

**Author:** ![maurostudio](https://avatars.discourse-cdn.com/v4/letter/m/9f8e36/32.png) [@maurostudio](https://forum.dynamobim.com/u/maurostudio)\
**Post date:** [September 24, 2024, 9:34am UTC](https://forum.dynamobim.com/t/i-have-a-writing-problem-in-excel-with-dynamo/104597/1 "2024-09-24T09:34:07Z")

</div>

Hi everyone! I am new to Revit and Dynamo!. Thanks a lot for help me! I have a problem with writing data to Excel with Dynamo. Let me explain my question briefly. I used the archilab\_Bumblebee node with BB-Data to write to Excel. I have three types of data to insert into an excel sheet that was sent to me. The first data is a temperature. For example 20°. I used a code block “20°” connected to a “string from object” and to the BB-data. The result is that it writes the data vertically in separate excel cells. The second problem concerns the writing of the name of the manufacturer. I also used in this case a code block “name of the manufacturer”. The result is that Dynamo writes the name in an excel box letter by letter (example: I want to write the name of the manufacturer, Dynamo writes me: “n” in b1, “o” in c1, “m” in d1, “e” in e1). Last question if I write a number for example 50. the result is that it only writes 5. This is a problem that concerns the writing of the dynamo script or formatting of the excel file.  
Thanks for anyone who wants to help me.

---

<div class="post-metadata">

**Author:** ![Alien](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/alien/32/40701_2.png) [@Alien](https://forum.dynamobim.com/u/Alien)\
**Post date:** [September 24, 2024, 9:37am UTC](https://forum.dynamobim.com/t/i-have-a-writing-problem-in-excel-with-dynamo/104597/2 "2024-09-24T09:37:07Z")

</div>

Welcome to the forums 🙂

I had this fun when I first used the BB nodes too. 😃

You need to make sure that your lists that you feed into the BB nodes all have the exact same structure.

I found it very useful to experiment with my list structures until it worked.

---

<div class="post-metadata">

**Author:** ![maurostudio](https://avatars.discourse-cdn.com/v4/letter/m/9f8e36/32.png) [@maurostudio](https://forum.dynamobim.com/u/maurostudio)\
**Post date:** [September 24, 2024, 9:40am UTC](https://forum.dynamobim.com/t/i-have-a-writing-problem-in-excel-with-dynamo/104597/3 "2024-09-24T09:40:41Z")

</div>

Thanks Alien for your answer!

---

<div class="post-metadata">

**Author:** ![Alien](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/alien/32/40701_2.png) [@Alien](https://forum.dynamobim.com/u/Alien)\
**Post date:** [September 24, 2024, 9:54am UTC](https://forum.dynamobim.com/t/i-have-a-writing-problem-in-excel-with-dynamo/104597/4 "2024-09-24T09:54:50Z")

</div>

![image](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/7/3/735e96863a984bb0b8db5fb891cf334f98ccadb2.jpeg)

 ![image](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/d/0/d0d86e5839f4b8e67620c00d3b672f5a61e212ac.jpeg)

 ![image](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/5/f/5f29e9adb25c1e08e7b0eccd22f60d65dc336c24.jpeg)

 ![image](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/8/2/82a97334221dcc79e57afe588e88a0d83505ae42.jpeg)

---

<div class="post-metadata">

**Author:** ![maurostudio](https://avatars.discourse-cdn.com/v4/letter/m/9f8e36/32.png) [@maurostudio](https://forum.dynamobim.com/u/maurostudio)\
**Post date:** [September 24, 2024, 9:58am UTC](https://forum.dynamobim.com/t/i-have-a-writing-problem-in-excel-with-dynamo/104597/5 "2024-09-24T09:58:49Z")

</div>

Tanks Alien!

---

<div class="post-metadata">

**Author:** ![Alien](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/alien/32/40701_2.png) [@Alien](https://forum.dynamobim.com/u/Alien)\
**Post date:** [September 24, 2024, 10:06am UTC](https://forum.dynamobim.com/t/i-have-a-writing-problem-in-excel-with-dynamo/104597/6 "2024-09-24T10:06:28Z")

</div>

Just to add… This is one that confused me for ages:

 ![image](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/5/1/51f98b94886e21e93366ac1b11847a96e48640e9.jpeg)

If you’re working with more data you need to put sheetName in lists too.

Easy to do with List.Cycle or repeat node.

---

<div class="post-metadata">

**Author:** ![maurostudio](https://avatars.discourse-cdn.com/v4/letter/m/9f8e36/32.png) [@maurostudio](https://forum.dynamobim.com/u/maurostudio)\
**Post date:** [September 24, 2024, 10:09am UTC](https://forum.dynamobim.com/t/i-have-a-writing-problem-in-excel-with-dynamo/104597/7 "2024-09-24T10:09:02Z")

</div>

Thanks a lot for your time!

---

<div class="post-metadata">

**Author:** ![maurostudio](https://avatars.discourse-cdn.com/v4/letter/m/9f8e36/32.png) [@maurostudio](https://forum.dynamobim.com/u/maurostudio)\
**Post date:** [September 24, 2024, 10:11am UTC](https://forum.dynamobim.com/t/i-have-a-writing-problem-in-excel-with-dynamo/104597/8 "2024-09-24T10:11:36Z")

</div>

I am new in Revit and Dynamo. Thanks Alien!

---

<div class="post-metadata">

**Author:** ![Alien](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/alien/32/40701_2.png) [@Alien](https://forum.dynamobim.com/u/Alien)\
**Post date:** [September 24, 2024, 10:12am UTC](https://forum.dynamobim.com/t/i-have-a-writing-problem-in-excel-with-dynamo/104597/9 "2024-09-24T10:12:39Z")

</div>

No problem.  
If it fixes your issue mark it, “solution”.

Happy Dynamoing 😃
