Create a 3d arc by reading excel points

Hello everyone!

Just started to learn dynamo in order to make a uni project.
Long story short
I have an excel sheet of xyz coordinates of every start,center and end point of each arc and I want to make a loop that makes an arc for each one of those set of points .
While I managed to import the coordinates, I have trouble at getting the right point from the list and at finding how to make this a loop (loopwhile and range doesn’t seem to work )
Any advice is welcome

Hi @georgekon

How is your excel data is arranged can you send a picture of it

Regards

1 Like

here it is!

Hi @georgekon
I suggest a little bit of organizing should do the trick and no need for looping.
first, in your sheet make sure that all the numbers are numeric values
so if it was my project I prefer to make each point in a separate sheet, for example, all the center point coordinates in a single sheet as well as the other ends points
after importing each one to dynamo you will get three lists from each sheet corresponding to x,y,x

Regards

thanks a lot! I will try it out and text you back with the results!

1 Like