Importfromexcel set mark


Hi,

i couldn’t find any information on this on the internet so i’m going to try my luck here.

I have a script where a load in a family from coordinates of an excel. in this excel is also a name for the individual elements. how can i script my way to putting the right mark on the element. i’ve tried groupbykey and using the unqiuekeys but that didnt work

There are plenty of topics on how to properly filter and match Excel import data with Revit. Try reading through some of those to get some ideas.

It would be beneficial if you included the node preview bubbles in your screenshot, but it looks like you filter the first index for nulls or empty strings but don’t filter the other indices. This is breaking the relationships between your column values. Filter everything for nulls/empties and then your data should stay intact.

2 Likes


If you want to apply filter( in case of cleaning input data from excel), you need to apply that filter for all( 0, 1, 2 values from input).
If data cleans up, you just need to directly connect 0 input items to value.

That’s true. but each coordinate has a mark / name to identify the family or elements im placing there. So if i dont filter / match the marks will be filled in at random and not by the right xyz coordinate. if i do it by the way you’re suggesting it’ll be placed at random no?

No. They are ordered by excel rows. We don’t need to match them anymore.

ah in that case i think im using the wrong list filter. because if i use the filter by index it filters the names and fills it out randomly when i run it.

Zoom in closer before exporting graph so that you can get the image with the nodes name.


this will be better


You can open these results to make sure things not go randomly.

Solved it. theres probably a shorter node to become this result but it worked. dropped last item untill i became the correct element code of each list