Fill different parameters for different objects from excel

Been trying to make this work.

I have a model with rooms.
I want to be able to switch the room names from one language to another
I’ve created Parameters for each language on the rooms
I have a list with room names and translations
with the graph below I can fill the parameters for the translations of one room
but I’m sure there’s a way to make it work all room names at once.

Fill multiple parameters from excel.dyf (32.4 KB)
NAMES.xls (45.5 KB)
room name TRANSLATION BASIC.dyn (27.4 KB)

Any tips or ideas?

Thanks :slight_smile:

room name TRANSLATION BASIC_TD.dyn (25.1 KB)

is this the type of thing that you are looking for?

This should work…
NamesTranslation.dyn (12.1 KB)
Deleted empty columns from excel sheet
names.xls (46 KB)

1 Like

awesome Vikram, it works beautifully!
Can you explain what you did in the code block? As you can see I’ve no programing skills :slight_smile:

thanks for the help,

1 Like


Hope this helps explain …