linked spreadsheet and iLogic

[DarrinLindblom]

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!

[DarrinLindblom]

I am using Inventor pro 2014 and excel 10.

[Marco.Takx]

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

[DarrinLindblom]

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

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

[Marco.Takx]

I don't see any error.

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

Autodesk Inventor 2014 Service Packs/Hotfixen

[DarrinLindblom]

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

[Marco.Takx]

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.

[cwhetten · Accepted solution]

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

GoExcel.Close

GoExcel.Close

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

Cameron Whetten
Inventor 2014

[DarrinLindblom]

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!