Arraying Family based on Excel.Read


#1

Hello,

I am working on a document to create and array a programming chip family based on an excel read. So far, I’ve been able to use some data correctly; I can space the families out based on their width. But in order to create their length spacing (you can see in the image there are two rows) I’ve only managed to do so by copying most of the Dynamo script over again.

I’m wondering if there is a way to create the number of rows and place the families according to a list of items pulled from excel. In this case those types are: one user, two user, three user, etc…

Any partial or related help is greatly appreciated!Script Revit


#2

Just realized text isn’t showing up in the script image:
Script


#3

I’m not 100% up on the play with Excel, but have a look at my thread asking a similar question (Albeit, I was asking to parse out to excel). Peter Kompolschek has a method that does it!

http://dynamobim.com/forums/topic/write-to-excel/

Try reverse engineering that maybe?


#4

Try the “List.GroupListOfListsByKey” from the Clockwork package:

2015-03-20_154312


#5

Sol Amour, Thanks for the reply. I’ll have to dig deeper into Peter’s solution to see if I can get it to work for me. The biggest challenge I think is going to be arraying the data back into a single list based on all of its parameters.


#6

Dimitar, “List.GroupListOfListsByKey” is very helpful for sorting based on different sub-categories. I now have to figure out how to place the families in the Y direction based on the parent list, and in the X direction based on sub list. Thank you very much!