Import/Export Excel to swap Revit Families by name and type

[Dynamo_Ann]

Hello,

Is it possible to get family and type element from a string name?

See pink group…

I have taken a really round about way, collecting the Family By Name, then all the Types from that family, then using string from object to filter out any true matches with the excel import, which I’ve had to add family and family type to to make it match… .

Is there a better/more reliable way?

methodology follows this post:

Export revit schedule, change/add data in excel & import again

Hi, I’ve been searching the forums & can’t seem to find what I’m looking for. I want to export a schedule for mechanical equipment to excel & be able to edit or add data to the excel spreadsheet such as comment & mark & then import this information back into the schedule. I can export schedules (using a script that someone linked in a previous thread) but it exports all schedules in the project & I don’t know how to import data again. Any help/advice would be greatly appreciated.

Despite the errors in my script this method works well.

Thanks in advance.