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
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.
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
1 Like