Hello everyone. My design group is wanting to create a master pipe template which has automatically-updating iProperties based on model geometry... We have been able to link the model to the iProperties, but now want to drive the model with an embedded excel. And could the driven items be in a drop-down list? Any help on this is greatly appreciated!
Solved! Go to Solution.
So you want to fill ure multivalue parameter with a list from the excel sheet?
If you made a named range in excel from the list that you want to insert in the multi value list. you could use this rule
'Named range name Dim named_range As String named_range = "Name" ' this is an array X*Y dimension rangeArray = GoExcel.NamedRangeValue(named_range) 'create a list to get the values of the first column Dim oList As ArrayList oList = New ArrayList Dim oIndex As Integer 'rangeArray.GetLength(0) means how many rows For oIndex = 1 To rangeArray.GetLength(0) ' add value of each row one by one oList.Add(rangeArray(oIndex,1)) Next 'set it to the list parameter MultiValue.List("Parameter name here") = oList
I have this for a flanged connection. When i change the NORM from DIN to ANSI the multivalue list changes from a DIN size list to ANSI sizes
The size values are from a excel based list, i think it's quite the same or not? You will just have to map the value you get to the right parameter then.
Can't find what you're looking for? Ask the community or share your knowledge.