topic Re: ilogic rules in version 2021 no longer working in Inventor Programming Forum

ilogic rules in version 2021 no longer working

Anonymous — Mon, 23 Nov 2020 08:30:54 GMT

Hello,
After installing Inventor 2021, the ilogic rule stopped me (on the 2020 and 2019 versions everything worked). Has anything changed with an update in iLogic commands.

Below I am attaching a template of .ipt parts, an excel file with source data and a file with the rule.

The rule worked as follows:
She asked for the excel file
Then she read the data and modified hello.
Finally, she saved the part under the name read from excel in .igs and .ipt format.

Can you tell me what could have changed in iLogic between version 2021 and 2020 ??

PS. Comments and msbox are written in Polish

Re: ilogic rules in version 2021 no longer working

JhoelForshav — Mon, 23 Nov 2020 13:14:12 GMT

Hi @Anonymous

I haven't looked at your attached files, but since your rule is working with excel I suspect it's the updates to the default excel engine in 2021 that causes problems for you. Have you tried setting the excel engine to COM?

See this thread for more info:

https://forums.autodesk.com/t5/inventor-customization/new-default-for-ilogic-excel-functions-in-inventor-2021/td-p/9740493

Re: ilogic rules in version 2021 no longer working

Anonymous — Tue, 24 Nov 2020 07:36:23 GMT

HI, @JhoelForshav
Thanks for your interest in my problem
Unfortunately, changing the settings from ENGINE to COM unfortunately did not help.
Rule using excel function:
GoExcel.Open(ExcelFile, "sheet")
Do Until String.IsNullOrEmpty(GoExcel.CellValue("A" & i))
Loop
GoExcel.CellValue("A" & i)
GoExcel.CellValue(ExcelFile, "sheet", "B" & i)

Could any of the listed functions have changed?
Thank you for your help
best regards
Matthew

Re: ilogic rules in version 2021 no longer working

JhoelForshav — Tue, 24 Nov 2020 08:10:32 GMT

@Anonymous

Seems like you run some loop until a cellvalue in your excelfile is empty. Then I assume your code actually edits the excel file. You can only edit the file with the COM-engine so I still think thats the problem here... Did you try restarting inventor after saving your changes to the excel-engine?

Re: ilogic rules in version 2021 no longer working

Anonymous — Tue, 24 Nov 2020 10:38:20 GMT

Hi, @JhoelForshav
Unfortunately, restarting the program and the computer did not help ...

I don't know if it matters, the excel data file is in .xlsb format

Someone could check the deleted files on his computer, after I suspect an error with the installation of inventor??

best regards
Matthew

Re: ilogic rules in version 2021 no longer working

JhoelForshav — Tue, 24 Nov 2020 10:46:46 GMT

@Anonymous

I don't know if it makes a difference but I dont think so... Have you tried saving the excel file as xlsx instead?

I just want to correct something I said in a previous post. You can in fact change cell values in excel using LibXL as well... The limitation with LibXL is that cell values that depends on formulas will not update accordingly.

Re: ilogic rules in version 2021 no longer working

JhoelForshav — Tue, 24 Nov 2020 10:51:57 GMT

Also, make sure that the computer meets the System requirements for spreadsheet in Inventor 2021:

https://knowledge.autodesk.com/support/inventor-products/learn-explore/caas/sfdcarticles/sfdcarticles/System-requirements-for-Autodesk-Inventor-2021.html?_ga=2.95610527.2067274630.1606113375-289203218.1560154612

Re: ilogic rules in version 2021 no longer working

Anonymous — Wed, 25 Nov 2020 19:00:20 GMT

Thank you for your help

The problem turned out to be 32 bit MS office.

after changing to 64 bit and changing ENGINE settings, everything started working