iLogic to build nozzle dimensions

[Anonymous]

Hi,

I have an excel table with different nozzle classes and sizes I am interested in (see attached). I am essentially trying to code iLogic to build my nozzles for me and I am a bit of a beginner.

I have so far managed to generate the following code and need a bit of help finishing it;

MultiValue.SetList("Class", "Class 150", "Class 300", "Class 400", "Class 600", "Class 900", "Class 1500", "Class 2500")
If Class = "Class 150" Then
GoExcel.TitleRow = 44
MultiValue.List("Nozzle1") = GoExcel.CellValues("Flanges.xls", "Sheet1", "O45", "O56")
ElseIf Class = "Class 300" Then
GoExcel.TitleRow = 68
MultiValue.List("Nozzle1") = GoExcel.CellValues("Flanges.xls", "Sheet1", "O69", "O80")
ElseIf SIZE = "Class 400" Then
GoExcel.TitleRow = 92
MultiValue.List("Nozzle1") = GoExcel.CellValues("Flanges.xls", "Sheet1", "O93", "O104")
End If
Dim oRow As Integer
Select Case Parameter("Nozzle1")
Case "D": oRow = 45
Case "T": oRow = 46
Case "A": oRow = 47
Case "E": oRow = 48
Case "L": oRow = 49
Case "B": oRow = 50
Case "P": oRow = 51
Case "DB": oRow = 52
Case "N": oRow = 53
Case "DB2": oRow = 54
Case "DRF": oRow = 55
Case "TTF": oRow = 56
End Select

 Any help will be much appreciated.  

Thanks.

[bradeneuropeArthur]

Why not embed the xls file in the part and use this to create your versions of the flange.

This is without I-logic and therefore much easier.

I could show you an example if you want....

[Anonymous]

braneneurope,

I have not thought about this to be honest. Any help or example you can share will be a great help.

Thanks.

[bradeneuropeArthur]

https://www.youtube.com/watch?v=eecgf5o844M

[bradeneuropeArthur]

You can use the Excel functionality to achieve your needs.

[bradeneuropeArthur]

this is for example a pipe with versions...