Hey Guys! i’ve been stuck for a while at this one… Is it possible to export a Loop into Excel? What i, trying to do is to move a element in Revit. For example i move a wall from 0 to 1 by 0.1 steps with a LoopWhile. How can i transfer information from the wall (getparamatervalue) at each Loop-ste…

You can export to excel within a python node and then just do it with every loop: [image] How to use Data.ExportExcel method in a python scipt Revit Oh yes. My bad. I will change that in my post +1 import clr import sys sys.path.append('C:\Program Files (x86)\IronPython …

Hello, here an idea [loop export excel]

Thanks for the answer, but not exactly what i meant. My purpose is to move the element through all steps by just 1 click, because i have multiple of them. Then i want Dynamo to list the values at every movement in a excel sheet.

I did but it is expecting a openpare? What does it mean? [Forum]

You need to pay attention: Your python node is set up with cpython3. You need to change it to ironpython. [image]

Its still giving me the error quote… :confused: i changed the settings to ironpython and the python script node. While doing Dynamo told me, that ironpython is an old version and is no more supported. [Iron] [Iron2]

Wait, do you mean this one? [image] You cannot use python language in a code block. Furthermore your python node does not throw an error. The original code was written for Revit 2019 and I just tried it in Revit 2022 and it still works if the python node is set to ironpython: [image]

My bad sorry! Still im trying to do what youre doing but it doesnt seem to work. The wall gets moved so the rest of my script seems to work through. But the Excel file wont pop out. As you see on the picture i tried changing it from Python3 to IronPython and even used the migration assistant, but …

Can you turn on the preview for your list.create node? Seems to be an issue with that. I can just guess at the moment, but are you trying to concat the “TB m²” to values? Then you could do it like this: [image]

Sure. Here it is. Like i said. Im trying to get a Excel where multiple elements are getting listed with their value for every loop (moving them step by step) [Iron5]

You forgot to turn on the preview, like I did.

Loop export into Excel

Revit

dr96 September 28, 2022, 2:37pm 15

the Excel worked! Thanks!

but its not listing all my iterations. As you see in the picture the wall should loop from -0,38 to 0,812 and give me the value for all iterations (+0,1 steps) back in Excel.
im getting just one value in excel.

Topic		Replies	Views
How to use Data.ExportExcel method in a python scipt Revit excel , python , dynamo	7	3157	September 20, 2023
Dynamo Excel-Export Loop Revit excel	17	2195	April 14, 2021
Export list of lists to excel revit , excel , python , dynamo	3	840	July 23, 2020
Need to export this script result to excel Revit	9	787	May 25, 2022
How Can I Create a Loop in Dynamo? Revit dynamo	28	1008	September 13, 2023

Loop export into Excel

Related topics