I have a long list of excel elements (element IDs) in excel. Every so often, I want to select a subset of the list, and have the Revit 3D view readjust by selecting the elements and radjusting the scope box. To achieve this in Dynamo, I believe I need to put together a graph that reads the currentl…

@mike.kovacs I update the code with selection [image] Get Currently-selected Excel Cells (for subsequent Revit Action) Revit hello a solution using COM Interface Interop.Excel import clr clr.AddReference('ProtoGeometry') from Autodesk.DesignScript.Geometry import * #i…

Dynamo 2.0.2 does play well with 2018, but 2.0.3 plays even better and is worth the update.

cheers, I took a chance and installed it. Now I have the bumblebee package and another package called “Elementids Excel List to Revit Elements”. This second package is just one node that takes an Excel sheet and range as input, then selects the elements in Revit. I need to modify that node, and I’ve…

hello a solution using COM Interface Interop.Excel import clr clr.AddReference('ProtoGeometry') from Autodesk.DesignScript.Geometry import * #import Revit API clr.AddReference('RevitAPI') import Autodesk from Autodesk.Revit.DB import * clr.AddReference('RevitAPIUI') from Autodesk.Revit.UI import…

[image] c.poupin: import clr clr.AddReference('ProtoGeometry') from Autodesk.DesignScript.Geometry import * #import Revit API clr.AddReference('RevitAPI') import Autodesk from Autodesk.Revit.DB import * clr.AddReference('RevitServices') import RevitServices from RevitServices.Persistence impo…

I’ve replciated your exat graph, but can’t get any reaction from the Phython Script node. even if I change the code to include OUT = “testing” as line 1 of the code, the Watch node is blank. I flip the switch from True/False, and Automatic to Manual several times. Excel and Revit 2018 are open (but …

@mike.kovacs the script does not find an instance of Excel… make sure all Excel process are closed before open Excel file and launch script [excel kill] I update the code [image] Get Currently-selected Excel Cells (for subsequent Revit Action) Revit hello a solution …

Brilliant! That was helpful for getting your code to run. I’m much further along now. I can select element IDs in Excel and get an adjustable section box around them (see the graph below). However, the elements aren’t actually being “selected” – i.e. they’re not highlighted in Revit. So I found som…

Brilliant! Thanks very much for your support in achieving this

Hi, I am very interested in using this solution. Thank you so much. I’ve tried the code, but I’m getting an error. Please see below. When I run the script, a new excel empty window opens, and then I get the error message below. Thanks in advance [image]

Hello @a.halim make sure all Excel process are closed before open Excel file and launch script [excel kill] Which Excel version are you using?

Get Currently-selected Excel Cells (for subsequent Revit Action)

Revit

c.poupin May 27, 2020, 5:20pm 9

@mike.kovacs

I update the code with selection

you can also use the Periodic Mode

Dynamo to run automatically when excel is updated

Topic		Replies	Views
GetItematIndex - Select range of data Excel to Revit Packages	2	688	March 22, 2016
String sheet name data import excel Revit revit , excel	1	639	August 3, 2020
Update parameters based on Element ID by using Excel Revit revit , excel , dynamo	7	509	February 26, 2020
Import / Export Revit - Excel Revit revit , excel , dynamo	8	2643	May 3, 2023
Help! Sheets creation_Excel to Revit Packages	8	965	June 7, 2015

Get Currently-selected Excel Cells (for subsequent Revit Action)

Related topics