We now add one more rule. This rule updates some of the iProperties for the manifold block.
For standard components, we can look up the Part Number in the embedded spreadsheet. Then, we use the value in the model_code cell to set the Part Number property for the part. You use the iProperties.Value function, which is available in the iProperties node of the Snippets area.
If component_type = "standard" Then i = GoExcel.FindRow("3rd Party:Embedding 1", "Sheet1", "port_size", "=", port_a_size) iProperties.Value("Project", "Part Number") = GoExcel.CurrentRowValue("model_code")
Else iProperties.Value("Project", "Part Number") = "HomeMade" End If
The rule is complete.