I am a new user to Dynamo and this will be my first post!
I wan’t to read an Excel file from Active Rows only!
If I filter my excel to only show a certain value, f.e “doors” (reading a large keynote file to set keynote value to categories in Revit). So if I filter Excel to show doors only, i want dynamo to read the “Active cells/active view only”.
I have tried to use the Bumblebee package - and “Range read”. But the range on the cells vary depending on what Category i filter on, f.e Doors might be shown in cells A1-A5. But if i then choose to filter on Windows they might be in cell A20-A25. And i don’t want to change the “Range read” in Dynamo everytime i filter in Excel.
As I said, I don’t wan’t to read by range unless the range can be “active cells only” or something like that… Is there any Dynamo / Python script who can solve this problem? Ty so much for your time!