I have a writing problem in excel with dynamo

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.

Welcome to the forums :slight_smile:

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

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.

Thanks Alien for your answer!

1 Like

Tanks Alien!

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

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

Easy to do with List.Cycle or repeat node.

1 Like

Thanks a lot for your time!

I am new in Revit and Dynamo. Thanks Alien!

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

Happy Dynamoing :smiley:

1 Like