How to load datasheet values from excel to corresponding family types in Revit

[Arun_Prakash]

Hi All,

This post is in continuation with a previous post.,

How to scan spreadsheet get Intersecting cell

Hi All, I have a radiator datasheet, I need to select the capacity from looking into its type and length. [image] Progress as of now: [image] How do I get the intersecting cell? for eg: [image]

I now have Radiators loaded in the Project, and on the other end, I have powers for the standard Radiators in Excel Spreadsheet.

I don’t know how to use the logic to load in Power to all the instances in the project

Progress as od now:

Sample Datasheet for reference:

[Arun_Prakash]

Made some progress: