Here’s the scenario I have a lists from Excel that contains Sheet Number and several parameters value associated to that sheet. I’m cross referencing that list with the actual file to retrieve only the Sheets contain in the initial file (and eventually push the values from Excel to those) The results is a list of list with some list containing 1 \true value. So that’s the sheet i’m after to match in the file. Hopefully you are still with me :slight_smile: So for each True i want to push several parameter in the new Sheets [image]

I think this thread might help you. [image] How to Control Revit Family via an Excel File? Revit 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 th…

I don’t see where they are comparing list to then get sublists values, did i miss something?

Do I understand correctly? You have excel file with sheet number and other parameters. Then you want to find referencing sheets in revit by sheet number parameter and add/fill more values to those sheets? If not, just ignore :smiley:

Exact… so i wont ignore ahahahah

If I’m reading correctly I think this is what you’re looking for [image]

That’s a start but i can also do that without a Python Script. What i’m after is matching the values from Excel to the actual Project and then pushing all the parameters value to the appropriate sheet

Read once again thread that I linked - post 4. sheetNumber.xlsx (7.8 KB) SHEET_NUMBER.dyn (11.2 KB) sheet.rvt (308 KB)

Comparing 2 lists and "extracting the true" values

Uncategorized

Tomasz_Puchala September 12, 2016, 2:48pm 2

I think this thread might help you.

Topic		Replies	Views
Compare excel list to revit list and set value Uncategorized	6	521	September 22, 2020
Read data list from excel and assigns data to Revit Family parameters by Name Revit dynamo	11	1982	November 3, 2023
Read from Excel and Write to Revit Lists-Logic revit , excel , dynamo	5	1805	September 28, 2017
Index if values matches Uncategorized revit , excel , dynamo	8	5880	February 28, 2018
Compare Excel Values and Revit Parameter - Write From Excel To Revit Uncategorized	2	626	January 14, 2020

Comparing 2 lists and "extracting the true" values

Related topics