Eventhough a lot is written, I can’t figure a few things out myself. I want to import excel data into Revit using ID.
Working workflow::
export rooms with finishes to excel.
in excel use that data to fill a ‘roomfinish worksheet’
in excel another worksheet ‘export’ is autofilled with the ‘roomfinish worksheet’.
So step 3 is an excel worksheet which has the columns:
“ID” - “Name” - “Number” - “Wall Finish” - “Ceiling Finish” - “Floor Finish”
So step 4:
Dynamo: read excel, grab columns list transpose etc.
so dynamo should grab ID, select that element, set that element paramater values by columnvalues.
Object.Type string result:
list
0 System.Double
1 System.Double
etc.
String.ToNumber result
errors in: “Warning: One or more of the input types are not matching. Couldn’t find a version of ToNumber that takes arguments of type (__array)”
Are we trying to set IDs also from Excel? Is it possible?
My understanding was that objects’ ID (GUID) is set by Revit and like some other parameters, it is read-only…
I think if you import something from excel then you already lost a lot revit data.
the element no longer hangs the Ceiling Finish parameter so that’s why you always are getting an empty list at Element.SetparameterByName as it does in this way.
you have to work with lists to select the different parameters
or select again the same elements with dynamo by using guid id