error in code

vistametals — Fri, 22 Mar 2024 16:40:12 GMT

I am new to ilogic.

trying to read a value out of an excel workbook that is embedded in my IPT file.

I keep getting

hk_row = 9' deleted parameter

'width_row = 3' deleted parameter


If thk >= 20 Then 
	thk_row = "13"
	
ElseIf thk >= 17 Then 
		thk_row = "13"
ElseIf thk >= 16 Then 
		thk_row = "13"
ElseIf thk >= 15 Then 
		thk_row = "13"
ElseIf thk >= 14 Then 
		thk_row = "12"
ElseIf thk >= 13 Then 
		thk_row = "12"
ElseIf thk >= 12 Then 
		thk_row = "12"
ElseIf thk >= 10 Then 
		thk_row = "11"
ElseIf thk >= 9 Then 
		thk_row = "10"
ElseIf thk >= 8 Then 
		thk_row = "9"
ElseIf thk >= 7 Then 
		thk_row = "8"
ElseIf thk >= 6 Then 
		thk_row = "7"
ElseIf thk >= 5 Then
		thk_row = "6"
ElseIf thk >= 4 Then 
		thk_row = "5"	
ElseIf thk >= 3 Then 
		thk_row = "4"
ElseIf thk >= 2 Then 
		width_row = "3"
ElseIf thk >= 1 Then 
		thk_row = "2"
ElseIf thk > 0 Then 
		thk_row = "1"
		
	


End If

'thk_column = 1' deleted parameter

'width_column = 8' deleted parameter

If width >= 20 Then 
	thk_column = "N"
	
ElseIf width >= 17 Then 
		thk_column = "N"
ElseIf width >= 16 Then 
		thk_column = "N"
ElseIf width >= 15 Then 
		thk_column = "N"
ElseIf width >= 12 Then 
		thk_column = "M"
ElseIf width >= 10 Then 
		thk_column = "L"
ElseIf width >= 9 Then 
		thk_column = "K"
ElseIf width >= 8 Then 
		thk_column = "J"
ElseIf width >= 7 Then 
		thk_column = "I"
ElseIf width >= 6 Then 
		thk_column = "H"
ElseIf width >= 5 Then 
		thk_column = "G"
ElseIf width >= 4 Then 
		thk_column = "F"
ElseIf width >= 3 Then 
		thk_column = "E"
ElseIf width >= 2 Then
	    thk_column = "D"
ElseIf width >= 1 Then 
		thk_column = "C"
ElseIf width > 0 Then 
		thk_column = "B"
		
	


End If



If lg >= 20 Then 
	thk_chart = "Sheet39"
	
ElseIf lg >= 17 Then 
		thk_chart = "Sheet39"
ElseIf lg >= 16 Then 
		thk_chart = "Sheet39"
ElseIf lg >= 15 Then 
		thk_chart = "Sheet39"
ElseIf lg >= 14 Then 
		thk_chart = "Sheet25"
ElseIf lg >= 12 Then 
		thk_chart = "Sheet25"
ElseIf lg >= 10 Then 
		thk_chart = "Sheet24"
ElseIf lg >= 9 Then 
		thk_chart = "Sheet23"
ElseIf lg >= 8 Then 
		thk_chart = "Sheet22"
ElseIf lg >= 7 Then 
		thk_chart = "Sheet21"
ElseIf lg >= 6 Then 
		thk_chart = "Sheet20"
ElseIf lg >= 5 Then 
		thk_chart = "Sheet19"
ElseIf lg >= 4 Then 
		thk_chart = "Sheet18"
ElseIf lg >= 3 Then 
		thk_chart = "Sheet17"	
ElseIf lg >= 2 Then 
		thk_chart = "Sheet16"
ElseIf lg >= 1 Then 
		thk_chart = "Sheet15"
ElseIf lg > 0 Then 
		thk_chart = "Sheet14"
		
	


End If

oPath = "\\filesrv\USERS\ENGINEERING\Inventor\"
'("\\filesrv\Engineering\Inventor\Inventor\INVENTOR_MASTERS\rect_stk_chart.xlsx", "Sheet1", "help", "=", 1)
oFileName = "thk_stk_rect.xlsx"
colm = Parameter("thk_column")
oPN = Parameter("thk_row")
sht = Parameter("thk_chart")
'get row using part number 
oRow = GoExcel.FindRow(oPath & oFileName, sht,"ht", "=", oPN)

Parameter("stk_thk") = GoExcel.CellValue("3rd Party:thk_stk_rect.xlsx", sht,  colm & oPN ) 'get value in 2nd column
'Parameter("ID") = GoExcel.CellValue(oPath & oFileName, "Sheet1", "C" & oRow) 'get value in 3rd column
'Parameter("LG") = GoExcel.CellValue(oPath & oFileName, "Sheet1", "D" & oRow ) 'get value in 4th column

InventorVb.DocumentUpdate()

errors that a cannot figure out.

Error in rule: look_thk_combine, in document: rect_new.ipt

GoExcel: Could not match the column title: "ht"

System.ArgumentException: GoExcel: Could not match the column title: "ht"
at iLogic.GoExcel.FindColumn(String columnName)
at iLogic.GoExcel.FindRow(String fileName, String sheetName, Object[] sizeArgs)
at ThisRule.Main()
at Autodesk.iLogic.Exec.AppDomExec.ExecRuleInAssembly(Assembly assem)
at iLogic.RuleEvalContainer.ExecRuleEval(String execRule)

Re: error in code

A.Acheson — Sat, 23 Mar 2024 00:54:19 GMT

Hi @vistametals

These can be difficult to figure out without the running file and excel sheet. I would suggest to step through the code moving the message box between each line with a message box and keep going untill it errors out. You can then be sure the preceeding line caused the error. You will also need to deal with the parameters that have been deleted.

You can also try and target the lines thst the error message identifies. Check why it cannot find the objects.

Another thing to note is all cells in a range need to be filled in. Do not leave them blank. Use N/A or similar.

Re: error in code

vistametals — Thu, 28 Mar 2024 10:59:37 GMT

Thank you. I deleted the unused parameters and filled in the blank ranges. Then the rule worked. Thanks again.

Re: error in code

A.Acheson — Thu, 28 Mar 2024 17:15:29 GMT

Great to here you got it working. Can you mark as solved what instructions worked for you so others can know it was successfull.

Re: error in code

A.Acheson — Thu, 28 Mar 2024 17:19:40 GMT

Great to hear you got it working. Can you mark as solved what instructions worked for you so others can know it was successfull.

topic error in code in Inventor Programming Forum

error in code

Re: error in code

Re: error in code

Re: error in code

Re: error in code