I’m trying to find a way to select views by using an excel spreadsheet, so far I figured I would export the list of View names from Revit then import that list on to Dynamo and use a filter to select the elements that are equal to the list on excel. I’m not sure why, but the output won’t match the views I need.
So far this is what I have an inclining that it might be a problem with the excel sheet, though I’m not sure because the spreadsheet is just the list of View name.
Changing the Lacing works, kind of. Though it is only selecting one of the views that I need. Is there a way so that it selects all the elements within the list?
My guess would be there is some subtle difference between what is in the model and what is in your excel file. Something like spaces or capitalization in your view titles. In the past I have used a ToUpper or ToLower node to eliminate capitalization as an issue, but that can depend on what naming conventions you are using. Could you post a new image and verify those items to see if it will resolve?
The values match so I’m not sure that is the case. I tried using to nodes to see if it will help but it just ended up not selecting anything.
*both naming conventions have “_”
Here is a workflow that I have used in the past and it appears to work. I would still think there is something in the string that is making them not match.
Thanks Sean turns out there was a problem with my excel sheet but it was just where the values are places on the cells. Thank you so much for your help
