topic Re: linked spreadsheet and iLogic in Inventor Forum

linked spreadsheet and iLogic

DarrinLindblom — Mon, 17 Aug 2015 16:02:02 GMT

I have been trying to use iLogic to get a cell value from a linked spreadsheet in my inventor part. I have been using the "goexcel" command to find the cell value that I am looking for and place that value in one of my inventor properties. Everything seems to be working fine. Except, in the background, more than one excel process is being opened and not all of them are being closed. This causes issues.

For example, if I run the rule in my inventor part file and then try to open the spreadsheet, I get the message that the spreadsheet is already open. Then, I can open it "read only". I can't see that the file is open unless I go to the task manager and view processes. Then I can see that it is open. Through the task manager, I can see the processes open and close when I run the rules. And, it is always leaving one process open.

See attached for picture of the rule I created. I have tried to use ilogic to close excel, but that didn't work either. If you can think of anything else to try, or if you can see an error, please let me know. Thanks for looking!

Re: linked spreadsheet and iLogic

DarrinLindblom — Mon, 17 Aug 2015 16:13:35 GMT

I am using Inventor pro 2014 and excel 10.

Re: linked spreadsheet and iLogic

Marco.Takx — Mon, 17 Aug 2015 18:00:13 GMT

I haven't test it yet because I have no example, but I think you need a GoExcel.Close command.

Re: linked spreadsheet and iLogic

DarrinLindblom — Mon, 17 Aug 2015 18:06:42 GMT

goexcel.close does not work. I was thinking the same thing.

I have attached the inventor part and the excel spreadsheet, if that helps.

Re: linked spreadsheet and iLogic

Marco.Takx — Mon, 17 Aug 2015 18:25:43 GMT

I don't see any error.

Are you up-to-date with the service packs/hotfixen.

Autodesk Inventor 2014 Service Packs/Hotfixen

Re: linked spreadsheet and iLogic

DarrinLindblom — Mon, 17 Aug 2015 18:46:02 GMT

I was on 2014 sp2 update 6. I updated to update 7 and tried again. Same results. Are you able to reproduce the issue?

Re: linked spreadsheet and iLogic

Marco.Takx — Mon, 17 Aug 2015 18:52:01 GMT

When I change a cel so it has to read a other value and open the spread sheet I haven't any problem

See video. Or do you mean something els.

Re: linked spreadsheet and iLogic

cwhetten — Mon, 17 Aug 2015 23:40:33 GMT

I have seen the same issue. Whenever I need to interact with Excel through iLogic, I just put three lines of GoExcel.Close, instead of one. Like this:

GoExcel.Close

It's silly, but I've not had the issue since I started doing this.

Cameron Whetten
Inventor 2014

Re: linked spreadsheet and iLogic

DarrinLindblom — Tue, 18 Aug 2015 13:54:40 GMT

I placed the goexcel.close command in all my part files yesterday and things got better. One thing that I had not been noticing was that some files required me to press the update button in order for the excel.exe process to close.

This morning, I have included the extra goexcel.close commands and, along with paying attention to updating, the excel.exe processes are all closing.

Thank you both for your input!