Thanks Tomasz, for your reply.
But for some reason when I connect the output from the List.GetItem.AtIndex to either Point.ByCoordinates or FamilyInstance.ByCoordinates it doesn’t generate a point list, unlike your illustration.
Essentially what I would like to do is extract the values from the attached Excel spreadsheet to either create new or move existing families in the Revit file.
The Cube shape is immaterial, it could be any family, I have used a cube with parametric values a,b,c for the base, width and height, and an x,y,z position to illustrate the ability to control a generic family.
The link to my previous example was to see how to control the parametric values from within Dynamo, now I would like to extend it to extracting the xyz values from a “database”, in this case an Excel spreadsheet.
Below is the an updated structure of the Dynamo file, the first part is looking at changing the MARK Value of the Cubes which seems to work, the second part is looking at control of the xyz position of the Revit Family, and the third part is looking at the cube parameters a,b and c (base, width and height) from an Excel file.
I looked at two methods to control the point values, ie extracting from the excel columns to create a point list by the individual xyz values, and alternatively by creating a points list in Excel with the “CONCATENATE” function, but neither seemed to work.
Any help on what I’m doing wrong will be greatly appreciated.
New files are attached below.xLS2CUBED_02.dyn (35.8 KB)
Cubes.xls (23.5 KB)
Cubes.rvt (1.2 MB)