ilogic and goexcel

[viculises10]

Hi , Im trying to use ilogic to link values from excel to inventor. I don't get any errors but the code doesn't work.

I have two user parameters pipe size and pipe schedule and I have a cylinder with a parameter OD. My excel spread sheet has a column for Pipe sizes , next column is Pipe schedule and the last one is OD. The code is supposed to change the OD of the cylinder every time I update the parameters pipe size and pipe schedule but it doesn't do that. Because I don't get any errors i dont know whats wrong. attached are the excel file and the inventor ipart

[A.Acheson]

Hi @viculises10 

I haven't had a chance to open the ipart. Would it be an easier approach to just use an ipart exclusively with no ilogic? Simply paste values direct to excel table of the ipart. 

If you want to create an ilogic part please paste the code your using into the editor </> and we can see if the code is looking in the right locations. 

[Andrii_Humeniuk]

Hi @viculises10 . You need to remove empty rows in your excel file. I also changed your code a bit, and added an event triggers to the change of user parameters.